Totals in a report

  • Thread starter Thread starter MLC
  • Start date Start date
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?
 
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 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...
 
Back
Top