Max on Date Field - 7 Days

[Bombshell Disaster]

Hi All

I want to do an unmatched query, but first I need to set up my criteria. I have a date field and I need to find Max of Date Field which I can do with a Totals query. I then want to find records with a Max of Date Field - 7 days, this is where I am going round in circles. Then I will do the unmatched query.

Any pointers please?

 

[John Big Booty]

You will need to use a series of cascading queries.

You've got your Query to find the Max of Date.

Now you can create a second query. Now put table and your Max query in the top of the Query Builder grid, and use the following as criteria

[QueryName].[MaxOfDate] - 7

It should look something like;

 

[John Big Booty]

...and then use the results of that query in your unmatched query.

 

[Bombshell Disaster]

Thanks John, just what I was looking for!