Ok this is what I have - but it is asking me to Enter the Date received
twice. Is there a way that I can have it ask only one but still only give me
the what I need for both queries?
SELECT [Correspondence Volumes].[DATE RECEIVED], [Correspondence
Volumes].[QUEUE ID], [Correspondence Queues].[QUEUE NAME], [Correspondence
Volumes].[VOLUME RECEIVED]
FROM [Correspondence Volumes] INNER JOIN [Correspondence Queues] ON
[Correspondence Volumes].[QUEUE ID]=[Correspondence Queues].ID
WHERE ((([Correspondence Volumes].[DATE RECEIVED])=[Enter Date]) AND
(([Correspondence Volumes].[VOLUME RECEIVED])>0));
UNION ALL SELECT VOLUMES.[DATE RECEIVED], VOLUMES.[QUEUE ID], QUEUES.[QUEUE
NAME], VOLUMES.[VOLUME RECEIVED]
FROM QUEUES INNER JOIN VOLUMES ON QUEUES.ID = VOLUMES.[QUEUE ID]
WHERE (((VOLUMES.[DATE RECEIVED])=[Enter Date Received]) AND
((VOLUMES.[VOLUME RECEIVED])>0));
> Since your field sets match, open one of the queries in SQL design view and
> paste the other query's SQL as such:
[quoted text clipped - 19 lines]
> >FROM QUEUES INNER JOIN VOLUMES ON QUEUES.ID = VOLUMES.[QUEUE ID]
> >WHERE (((VOLUMES.[DATE RECEIVED])=[Enter Date Received]));
kingston - 20 Oct 2006 15:06 GMT
Try making both parameters the same, i.e. [Enter Date]. If that doesn't work,
I think you may need to make a form to trigger the query based on a single
date control.
>Ok this is what I have - but it is asking me to Enter the Date received
>twice. Is there a way that I can have it ask only one but still only give me
[quoted text clipped - 18 lines]
>> >FROM QUEUES INNER JOIN VOLUMES ON QUEUES.ID = VOLUMES.[QUEUE ID]
>> >WHERE (((VOLUMES.[DATE RECEIVED])=[Enter Date Received]));
WMorsberger - 20 Oct 2006 15:13 GMT
That worked when I made the parameters the same. Thank you so much for your
help.
> Try making both parameters the same, i.e. [Enter Date]. If that doesn't work,
> I think you may need to make a form to trigger the query based on a single
[quoted text clipped - 22 lines]
> >> >FROM QUEUES INNER JOIN VOLUMES ON QUEUES.ID = VOLUMES.[QUEUE ID]
> >> >WHERE (((VOLUMES.[DATE RECEIVED])=[Enter Date Received]));