Re: query question

[MacWheel99@xxxxxxx]

>  need to find out if records are being posted twice to an inventory
>  file-and query is all that I have to work with.
>  Is there a way to use query to select records from a file based on the fact
>  that the data in several fields is identical to the data in those fields in
>  another record when in fact that combination of fields should be unique in
>  the file?

I have done something very similar.
You can use query to create a work file.
I have a library used exclusively for work files from Query & IBM *OUTFILEs.

You can create a query to COUNT number of records that have certain
characteristics & combinations, and put THAT in a query work file.

Now use another query to read your work file & only include the dat there
that is a count of more than one.  Do your subtotals, of the query to the
work file, such that you have in the total records the fields to match back
to the original data, so you end up only listing the duplications,

MacWheel99@aol.com (Alister Wm Macintyre) (Al Mac)