Help With Report Totals

[RJL1]

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'&quot

Thanks
Ricardo

 

[CosmoKramer]

If your report is grouped by ship_carrier, you could put something like this in the group footer:

=Count([ship_carrier])

If not, and you want to use a DCount statement ,try this:

=DCount("[ship_carrier]", "statsquery", "[ship_carrier] ='EXPORT'")

 

[RJL1]

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