counting with a query

[Guest]

I have a table that that shows gross weights, date, and driver of received
deliveries. I want to sort out a drivers overweight deliveries but, I also
want to know the total deliveries of that driver for a specified period of
time. I got a query to do the overweights per driver but I can not get the
total loads delivered from that driver too. Do I need two sperate queries?

 

[Jeff Boyce]

How do you determine "overweight"? I don't see a way to figure that, based
only on Driver, Date and GrossWeight.

Yes, you'll probably need to do one query to get total deliveries and
another to do "overweights". Instead of trying to do one query for both,
why not use a report to display the results of each query? You could use a
main-report/subreport construction...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

To display the overweight, I set criteria in the gross weight field of
greater than.