Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help With Report Totals

Status
Not open for further replies.

RJL1

Technical User
Oct 3, 2002
228
US
I have a report that lists all of the order shipped for a given date range. The report has the following fields

shipped_date
order_no
ship_carrier
misc2
freight_charges
ship_weight

The query name is statsquery
The report name is statsreport

I need to get the total count of orders shipped for each carrier (i.e. EXPORT 125 orders)

I try using DCount but it gives me and error
=DCopunt("ship_carrier", "statsquery", "ship_carrier ='EXPORT'")

Thanks
Ricardo
 
If your report is grouped by ship_carrier, you could put something like this in the group footer:
Code:
=Count([ship_carrier])
If not, and you want to use a DCount statement ,try this:
Code:
=DCount("[ship_carrier]", "statsquery", "[ship_carrier] ='EXPORT'")
 
I got the first method to work but not the dcount. I need to have all the totals in the report header or footer so it would be something like this

EXPORT 45
UPS 1 DAY AIR 33
UPS 2 DAY AIR 50

the report can be long and looking in each page for a total would not work. Any sugestions

Thanks
Ricardo
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top