Formatting of query results

[jabenj]

Hi All. I made an INNER JOIN query that returns entries from two tables that are related by a common Lot#. So I want the query to record all entries, from two tables that are related to a Lot# that the user enters. I was able to do this, however, the query returns duplicate entries. It's returning data from both tables in the same row. I want it to return records distint to each table on separate rows. How do i DO this? My current query statement is as follows:

SELECT DISTINCTROW [Blendsheet Input].Date, [Blendsheet Input].Product, [Blendsheet Input].BatchNum, [Blendsheet Input].TransferredWeight, [Blendsheet Output].Weight, [Blendsheet Output].Customer, [Blendsheet Output].Date
FROM [Blendsheet Input] INNER JOIN [Blendsheet Output] ON [Blendsheet Input].LotNum = [Blendsheet Output].[Lot #]
WHERE ((([Blendsheet Input].LotNum)=[Enter Lot#]));

Thanks for any help in advance

 

[PHV]

records distint to each table on separate rows
Like an UNION query ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[jabenj]

Yes. Records distinct to each table on separate rows. Tried a union query. Couldn't get it to work. Maybe i was doing someting wrong. But is a union query what i need?