Re: Staff missing report
- From: "John Spencer" <spencer@xxxxxxxxx>
- Date: Fri, 6 Jan 2006 12:10:52 -0500
Yes it can be done. You probably just need to change the join in the query
and maybe the criteria.
Can you post the query you are using to generate the report?
"NoviceIan" <NoviceIan@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D831ADD3-1477-46EB-8082-0D9636EB3686@xxxxxxxxxxxxxxxx
> Hi,
>
> We have a staff database which we use to monitor staff's annual
> performance
> review. We have a staff table and an Interview table. When staff have
> their
> review we complete an interview form which populates the underlying
> interview
> table.
>
> We would like to create a report which will show the date of the staff's
> last performance review. At present the report we have developed only
> displays staff who have had a review. Staff who have not had one (new
> staff
> etc) are not included as they have no record in the interview table.
>
> However we would still like them to be displayed on the report with a
> blank
> date. Is this possible?
>
> Many thanks
>
> Ian
.
- Prev by Date: Re: after update populate field from a query
- Next by Date: Re: Staff missing report
- Previous by thread: Re: after update populate field from a query
- Next by thread: Re: Staff missing report
- Index(es):
Relevant Pages
|
Loading
