Eliminate Duplicate Catagory With Smallest Value in another field

J

Jeff C

I am importing financial data from exported text files. The balance sheet is
set up with sections of duplicate format and fields but with gross values in
one section and calculated statistical values in the second section.

I end up with two instances of every category.

I want to return only the instance of each category that holds currency
values in other fields greater than the currency values in the other instance
of the same category.

Don't know if I am being clear or not? Can anyone offer a solution?

Example:

supplies 3500 3200
supplies 15.70 12.30

I only want to return the

supplies 3500 3200

Thank you in advance
 
K

KARL DEWEY

Use a Totals query and change the Group By to Maximum for the numerial fields.
 
J

Jeff C

Thanks Karl, that's great. There are four numerical fields, one or more
could be null, how can I work around this???
 
Top