Compile or Group field in Query

[Guest]

I have a query that has 12 or so fields. In its records I have doubles in the
code field. I would like to combine the the records that the code is the
same. I can do this by using the group function in the query and summing the
quantity field and grouping the code field but when I add other important
fields to this query everything goes haywire. Any help please. I am using MS
Access xp.
Thanks,Ed

 

[John Spencer]

When you add fields to the query and group by them then grouping uses all
the fields. When any one of them changes value, a new group is "created".

Can you explain what you are trying to accomplish in a little more detail?
Why are you adding the additional fields?

For instance, if you need to add a field so you can apply criteria against
the field, you can change the group by to Where. The field will not appear
in the results, but will be available to set search criteria.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..