Access Formula Needed

  • Thread starter Thread starter Santi
  • Start date Start date
S

Santi

I’m trying to create an Access formula that when I do a query it will only
show me effective dates until about two months in advance. Can anyone help me?
 
It's a little hard to know what you're asking, but see if it heads you in
the right direction to enter something like this in the Criteria row for
your date field in query design view:

< DateAdd("m",2,Date())
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date Formula Needed 1
Access 2007 - reverse of what Linked Table Manager does 1
Relationships 1
Vacation Time + Sick Time + Overtime + Time Management 1
Get Start date of Week number and Year 10
How to structure a Table with many, many, many Fields? 16
Page number in footer by group 11
Query Question 7

Back
Top