Query level grouping 1

[EVE734]

Hi - I am trying to run a query based on three tables(Batch, Rejection, Error) with established relationships. For example:
The Batch Table has fields: KEY,BA,DOC,DOS,#oftkts
The Rejection table has fields: REJ_ID,NAME,MRN (Also "ForeignKEY" field joining to batch table "KEY" field)
The Error table has fields:Error_ID,ERRORTYPE
(Also "Rej_ID" field joining to Rejection table)

I don't want duplicate records to appear in my output.
Output appears like this:
KEY BA DOC DOS #OFTKTS Rej_ID NAME MRN ERROR_ID Type
1 GMT MKE 3/28 22 2 SMITH 111 1 MSDS
1 GMT MKE 3/28 22 2 SMITH 111 2 ATDL
1 GMT MKE 3/28 22 3 DOE 222 3 ILPC

But I want it to appear like this:
KEY BA DOC DOS #OFTKTS Rej_ID NAME MRN ERROR_ID Type
1 GMT MKE 3/28 22 2 SMITH 111 1 MSDS
2 ATDL
3 DOE 222 3 ILPC

so unique information from each table is only output once.
I know I can do this at the report level, but can it be done at the query (or form) level?

THANK YOU!

 

[dhookom]

AFAIK, this can't be done in a form or query.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[EVE734]

I was afraid you might say that. Thanks for responding.