Access 2007 - Help building a query

[Legacy 93538]

Hi

I was wondering if anyone could help me create a query in access which would do the following as i cant seem to work it out.

Currently i have two tables table 1 and 2. I want to create a query which selects ID, Description, Chase date, Receievd date from table 1 & Closedate and startdate form table 2.(These tables already have a inner join by the ID column)

The criteria i need is that when the query runs a inputbox appears where you enter a date and then the query takes that date and adds 21 (e.g. if the entered date was 17/11/2011, the query would add 21 to it so it would be 08/12/2011). It would then use that date and bring back any Chase date which are equal to or less than that date and that are blank in Receieved date, closedate and startdate.

However i am not sure how to do this? I am currently using the Query Design tool in design view, and i am having trouble entering the criteria. Can anyone help me?

Thank you

JessicaSeymour

 

[jackd]

Based on your description, I think the following will work.
Create a new query in the query wizard, go to SQL View and paste the following:

PARAMETERS PleaseEnterADate Date;

SELECT
ID
, Description
, [Chase date]
, [Received date]
,[Closedate]
,[startdate]
FROM [Table 1] INNER JOIN [Table 2] ON
[Table 1].ID = [Table 2].ID
WHERE
[Chase date] <= PleaseEnterADate + 21 AND
[Received date] IS NULL AND
[Closedate] IS NULL AND
[startdate] IS NULL


Good luck