Entering a Criteria to calculate a Future Date

[gbleslie029]

I am relatively new to Access and would like some help please. I am ok with the cosmetics but when it comes to criterion/VB etc it is a different story.

I have created a query based on a table and need to enter a criteria to calculate 77 days in advanced based on a field in the query.

The name of the field that I want to look at is Start_Date and I want to enter the criteria in the criteria for a field named Review_Date, which will return the date 77 days in advance.

Maybe I shouldn't be doing this in a query, maybe I should be entering something in a form field. To be truthful I really dont know.

Your help would be appreciated.

G

 

[llkhoutx]

Create the following column in your query:

State_Date: {Query_Column_Name) + 77

 

[plog]

The name of the field that I want to look at is Start_Date and I want to enter the criteria in the criteria for a field named Review_Date, which will return the date 77 days in advance.

Assuming the above sentence is what you actually want (not certain it is), you would create a query based on your table. Bring down both [Start_Date] and [Review_Date]. Under [Review_Date] you would put this in the criteria:

=Date() + 77


Then, when that does what you asked, but not what you want, post back here with a better explanation. It would be helpful if you posted sample data from your table along with the expected data you want from your query based on that sample data.

 

[arnelgp]

SELECT * FROM yourTable WHERE [Start_Date] >= [Review_Date] + 77

or

SELECT * FROM yourTable WHERE [Review_Date] >= [Start_Date] + 77

select whichever will suit you, whether Review_Date is the parameter then use the first. otherwise the second.

 

[gbleslie029]

Thank you guys for your help.

Maybe I didn't make myself clear but thank you all very much.

I have used arnelgp suggestion and I works perfectly for what I want.

Thanks guys and keep up the great work.
G