Query for date greater than 6 weeks

[JackieMottram]

I am trying to create a query in a database based on getting refunds off organisations that have been overpaid by us. We have up to 3 request dates for the refunds. These request dates have to be 6 weeks apart. I want to run a query that shows me that it is 6 weeks after the previous request date and I need to follow up on payment. This may sound easy, but I have no idea what to do. Any suggestions?

 

[EMP]

In the query you can use the DateAdd() function to add 6 weeks and 12 weeks to the [First Request] field e.g.

SELECT [OrganisationID], [First Request],
DateAdd("ww",6,[First Request]) AS [Second Request],
DateAdd("ww",12,[First Request]) AS [Third Request]
FROM TableName;

 

[Mile-O]

This expression will give the date six weeks ahead.

DateAdd("d", 42, OriginalDate)