GroupBy Query

[dvannoy]

I have a query that is linked to a DB file that pulls data from an AS400. There is a field called Container. In my query I am doing a groupby and doing a count on the field called container. There is also two other fields called approval and wip.

The problem I have is there could be 20 pieces that come in on a manifest same line item but with different wip and approval codes. doesnt happen that much. since it's a groupby query when it does a count on the container it will not count all the containers if the wip and approvals are not all the same..

what can i set the other fields at so i can just get a count of the containers without having a worry about all the other fields type...

Thanks in advance


DVannoy
A+,Network+,CNA
dvannoy@onyxes.com

 

[THoey]

Please list your query, file format and table structure so that we might be able to more easily assist you. Terry M. Hoey