One Table/Three queries and reports

[Mitchy]

I currently use a table to store data about quotations. Each record has three associated dates, date received, date quoted and purchase date. I would like to do a query for a specific time frame to analyze these quotes. How can I specify a single date range that will apply to the three different dates?

 

[Onyxpurr]

Set the criteria for all dates to the date range. However do not put the date ranges on the same criteria line.

E.G.

Date Received Date Quoted Date Purchased
---------------------------------------------------
[Date Range]
---------------------------------------------------
[Date Range]
---------------------------------------------------
[Date Range]

 

[Mitchy]

Will I have to enter the date range three times?

PS I am not a programmer so please keep any answer simple.

 

[Onyxpurr]

If you set the parameter to the same in each criteria field, like the example below, then you will only have to enter it once.

Date Received Date Quoted Date Purchased
--------------------------------------------------------------------------------------------
>=[From Date:] and <=[To Date:]
--------------------------------------------------------------------------------------------
>=[From Date:] and <=[To Date:]

---------------------------------------------------------------------------------------------
>=[From Date:] and <=[To Date:]