Query on Date Field plus "X" Number of Days

[MSAccessOldTimer]

My query is built on a table which contains a date field "A". I need to return only those records where field "A" is 56 days past the date in each record. Using Date()+56 shows the records based on today's date plus 56 days, not 56 days past the actual date "A" recorded in each record.



I appreciate any assistance!

[orange]

Date is a reserved word in Access with explicit meaning.
It seems you are seeking criteria for your query.
Something like

Select * from YourTable
Where [your datefieldA] + 56 =Date

[MSAccessOldTimer]

So does that go in the criteria area for DateFieldA in the query? I tried it and got a syntax error message. I should point out that there are 5 other fields that are also in the query, so the query is not just based on DateFieldA.

[orange]

Can you select the SQL View of the query; then copy the code and post it?

[MSAccessOldTimer]

DateFieldA is bolded. Thank you!

SELECT [1-qryAssociates-Active].Badge, [1-qryAssociates-Active].Associate, [1-qryAssociates-Active].Section, [1-qryAssociates-Active].ForktruckTempLicense, [1-qryAssociates-Active].Forktruck_2yrLicense, [1-qryAssociates-Active].ForktruckActive
FROM [1-qryAssociates-Active]
WHERE ((([1-qryAssociates-Active].ForktruckTempLicense)<Date()-56) AND (([1-qryAssociates-Active].Forktruck_2yrLicense) Is Null) AND (([1-qryAssociates-Active].ForktruckActive)="-1"));

[orange]

Is ForktruckActive a Boolean Yes/No field?

If so, you might try

SELECT [1-qryAssociates-Active].Badge
, [1-qryAssociates-Active].Associate
, [1-qryAssociates-Active].Section
, [1-qryAssociates-Active].ForktruckTempLicense
, [1-qryAssociates-Active].Forktruck_2yrLicense
, [1-qryAssociates-Active].ForktruckActive
FROM [1-qryAssociates-Active]
WHERE ((([1-qryAssociates-Active].ForktruckTempLicense)<Date()-56) AND
 (([1-qryAssociates-Active].Forktruck_2yrLicense) Is Null) AND 
(([1-qryAssociates-Active].ForktruckActive)= True));

If you need more assistance, I suggest you post a copy of your database. If the data is private/personal, you could use names like Porky Pig, John Doe etc. We don't need real data, but more interested in the structure and logic.
Good luck.

[MSAccessOldTimer]

Yes, that is correct, the ForktruckActive field is yes/no. And thank you Orange...that codes works perfectly!!

[orange]

You are very welcome. Happy to help.