Re: Staff missing report

Please copy and post the SQL of your query.

(Possibly unneeded instructions follow)
Open the query
Select View:Sql from the Menu
Select all the text
Copy it
Paste it into the message


"NoviceIan" <NoviceIan@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D6F3B178-E6AC-497E-90B9-B84FB0F73606@xxxxxxxxxxxxxxxx
> Hi,
>
> I've already tried changing the join in the query with no luck.
>
> Fullname (Query which concatenates forename and surname)
> Interview Date LAST (Interview Table)
> Interview Type [Criteria: Performance Review] (Interview Table)
> Staff Type [Criteria: Active] (Staff Table)
>
> The fullname query is used frequently in the database to fuel lookup
> fields
> so we generally use it in queries as well instead of concatenating in each
> query.
>
>
> "John Spencer" wrote:
>
>> 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
>>
>>
>>


.

Relevant Pages

  • Re: Staff missing report
    ... I would write the query as the following UNTESTED query. ... FROM LEFT JOIN (Fullname LEFT JOIN Interview ... >>> Fullname (Query which concatenates forename and surname) ...
    (microsoft.public.access.reports)
  • Re: Staff missing report
    ... FROM Interview as T ... >> I would write the query as the following UNTESTED query. ... sorting in the query is more or less useless for reports. ...
    (microsoft.public.access.reports)
  • Re: Counting yes values only in query
    ... your query and add in more fields. ... Select Totals from the View menu ... don't forget to tell us what type of field [Initial Interview] is? ... > Sorry to be a pain about this but I get an error message ...
    (microsoft.public.access.queries)
  • Basic Security Steps
    ... Even I know all the different anserwers for the questions, ... still I wanted the best one for this query. ... asked in an interview recently... ... Dan! ...
    (microsoft.public.sqlserver.security)
  • Re: Updatable Query (trying to edit records)
    ... the query so some fields are lookup fields. ... The only reason the Staff table is ... CABudgetHrs to arrive at the budgeted $ for that assignment. ... two tables ClientAssignment and Staff. ...
    (microsoft.public.access.queries)