M
Maria
Hi,
I recently had a problem selecting dates from a parameter query, and I wrote
to this forum and was helped by several of you. I have now encountered
another problem that I can't seem to figure out at all. I have a database
that tracks employee driver observations. I need to have a report in which
it states which driver in any given month has had an observation, and which
drivers still need to be observed. I was able to make the report asking
which drivers still need to be observed through your help, but now I am
having a problem with the report on drivers who have already been observed.
Many times a driver is observed more than once in a month's time, and when I
asked for a report on drivers who have been observed, it brings up a
driver's name several times with each date. I want the driver's name, date
of observation, employee ID, and observer's name only to appear once in the
report. I have tried selecting hide duplicate records in the field property
in the report, but that just hides that one field and all the rest of the
data is visible. I have tried creating a query with the employee ID number
and date, and grouping them and selecting Last in one of the fields. I then
created a second query using that query and addiitonal fields to identify
the driver, and that worked, but it included every date in every month. When
I added the criteria to select a month, (for example, all drivers who have
been observed from 11/1/05 to 11/30/05, it didn't include any drivers if
they also had a date in December, I guess because of my choosing Last in the
first query. I've tried using the
In (Select Top 1 [DateID] From tblObservation Where
[EmployeeID]=[tblEmployeeInfo].[EmployeeID] Order By [DateID] Desc), but
that is just pulling 175 names for November when there should be 348. Can
anybody give me any idea of how to go about doing this? Thanks so much for
your help. These message boards have been a godsend for me.
Maria
I recently had a problem selecting dates from a parameter query, and I wrote
to this forum and was helped by several of you. I have now encountered
another problem that I can't seem to figure out at all. I have a database
that tracks employee driver observations. I need to have a report in which
it states which driver in any given month has had an observation, and which
drivers still need to be observed. I was able to make the report asking
which drivers still need to be observed through your help, but now I am
having a problem with the report on drivers who have already been observed.
Many times a driver is observed more than once in a month's time, and when I
asked for a report on drivers who have been observed, it brings up a
driver's name several times with each date. I want the driver's name, date
of observation, employee ID, and observer's name only to appear once in the
report. I have tried selecting hide duplicate records in the field property
in the report, but that just hides that one field and all the rest of the
data is visible. I have tried creating a query with the employee ID number
and date, and grouping them and selecting Last in one of the fields. I then
created a second query using that query and addiitonal fields to identify
the driver, and that worked, but it included every date in every month. When
I added the criteria to select a month, (for example, all drivers who have
been observed from 11/1/05 to 11/30/05, it didn't include any drivers if
they also had a date in December, I guess because of my choosing Last in the
first query. I've tried using the
In (Select Top 1 [DateID] From tblObservation Where
[EmployeeID]=[tblEmployeeInfo].[EmployeeID] Order By [DateID] Desc), but
that is just pulling 175 names for November when there should be 348. Can
anybody give me any idea of how to go about doing this? Thanks so much for
your help. These message boards have been a godsend for me.
Maria