suppressing data, no duplication

[Harriet]

Hello,

I am trying to suppress info in a query in Access. I have two queries I
want to combine to show both their data. Both have a 'number' field and both
have a date field. I want to be able to select a date range and pull back
data for both, without one of them repeating the 'number' field for each
number field of the other's data.

Below I've selected the date of the first query so it is the driver...how do
I select a range and make it apply to both so that the data in the number
field is listed only once for each query? How would I suppress the
duplication?

Ex.
SELECT [tAccuship Calls Union Query].[Accuship Call Number], [tAccuship
Calls Union Query].[Date Received], [tAccuship Registration Union
Query].[Accuship Registration number], [tAccuship Registration Union
Query].[Date Received]
FROM [tAccuship Calls Union Query], [tAccuship Registration Union Query]
WHERE ([tAccuship Calls Union Query].[Date Received] >= CDate([Start Date])
and [tAccuship Calls Union Query].[Date Received] < DateAdd("d", 1,
CDate([End Date])));

Harriet W.