Review Dates Query Results

[Villarreal68]

Hello everyone,

Using Acess 2007

This is what I have:

I have one Query with the following:
Main.ID, Main.First Name, Main.Last Name, Main.Assigned Date

I created a Daily Report using this Query to tell me when I need to meet again with these people.

I have a Report that has the following:
Main.ID, Main.First Name, Main. Last Name, Main.Assigned Date, [Assigned Date]+30,[Assigned Date]+60,[Assigned Date]+90,[Assigned Date]+120,[Assigned Date]+150,[Assigned Date]+180

What I would like to do:

The current report shows ALL records with the requested information. How can I have the Query or Report filter out the records that do not have any of the review dates falling on today's date?

I hope I explained myself. If further explanation is necessary let me know.

Any help is greatly appreciated.

René

 

[Villarreal68]

Am I talking rubbish? Is this not doable? Is there a better way of acomplishing this? i wonder...

 

[Villarreal68]

I figured it out! I'll post it here just in case someone ponder on the solution

I had to do the [AssignedDate]+# in the Query not the Report and format([AssignedDate]+#,"short date")

Then I was able to add the Criteria: Format(Date(),"Short Date") and presto!

It only took me a couple of days!