counting with a query

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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
 
Back
Top