Duplicate Records

[dvannoy]

I have a query that includes a group by query and two tables. This query will only show line items from a document that all have the same status. All of the sudden im getting duplicate records if there are 3 line items that are complete, the query shows six.

can anyone help with this?

Thanks

 

[tlbroadbent]

Please post the query and the table structures so we can analyze what you are doing.

Thanks, Terry

http://members.home.net/tlbroadbent/prog.htm

------------------------------------
Experience is the hardest kind of teacher. It gives you the test first, and the lesson afterward.

 

[bosully]

have you tried-

Select Distinct <field> From <table>

-?

Brendan