Totals in a report

M

MLC

I built a report for some truck expenses. I have several
weekly values per truck expense in my table. I want to
create a report showing only the totals per truck for a
range of dates on my report. Anyone know the best way to
do this?
 
F

Fons Ponsioen

I assume you have the report based on a query.
you must have a date which I'll call SvcDate
in the query under the SvcDate column in the criteria
block you could put
Between [Enter start date])And [Enter End date]
You'll be prompted for the start and end date of report
each time you run the report.
Hope this helps.
Fons
 
M

MLC

-----Original Message-----
I assume you have the report based on a query.
you must have a date which I'll call SvcDate
in the query under the SvcDate column in the criteria
block you could put
Between [Enter start date])And [Enter End date]
You'll be prompted for the start and end date of report
each time you run the report.
Hope this helps.
Fons
-----Original Message-----
I built a report for some truck expenses. I have several
weekly values per truck expense in my table. I want to
create a report showing only the totals per truck for a
range of dates on my report. Anyone know the best way to
do this?
.
Click to expand...
.
Yes thanks! That works!
Click to expand...
 
Top