P
p-rat
I have a report that is for Truck Driver tickets. The detail records
show Truck Number, Driver, Location, and Date. The report is grouped
as such. The end user fills in a parameter the date range and the
location.
The detail records pull in correctly. The issue I have is that the
driver will be PAID 10 hours in the day but only drive 6 hours out of
the day. The PAID hours comes from a payroll from and query. All the
summing of the detail record is correct. I have a DLookup coming from
a payroll screen that brings in the Driver Paid hours.
The end user when clicking on the report pulls up a parameter screen
that can choose more than one location. If there is only one location
chosen the DLookup and DSum from the payroll query works fine, but
when more than one location is pulled from the paramater box it seems
to add up all the locations. Would anyone know a solution to my
problem? Is there an inherint problem with access and chosing mulitple
locations on a report?
show Truck Number, Driver, Location, and Date. The report is grouped
as such. The end user fills in a parameter the date range and the
location.
The detail records pull in correctly. The issue I have is that the
driver will be PAID 10 hours in the day but only drive 6 hours out of
the day. The PAID hours comes from a payroll from and query. All the
summing of the detail record is correct. I have a DLookup coming from
a payroll screen that brings in the Driver Paid hours.
The end user when clicking on the report pulls up a parameter screen
that can choose more than one location. If there is only one location
chosen the DLookup and DSum from the payroll query works fine, but
when more than one location is pulled from the paramater box it seems
to add up all the locations. Would anyone know a solution to my
problem? Is there an inherint problem with access and chosing mulitple
locations on a report?