Sixty days ago for a date

[MagicalDean]

I am trying to work out how I can do two things:
1. Get a query to show the results for users in a table whos [Subscription Date] is more than 60 days ago. I have been trying for age but cannot work it out

2. To allow a user to choose or enter values in a textbook or from a combo box that can be then used as criteria in a query

Any help is greatly apprechiated! Thank you in advance

 

[ZmrAbdulla]

Q 1)In the criteria of the date field
<=Date()-60
Q 2) in the criteria of the field that you want to filter
Forms![MyFormName]![MyTextBoxName]
or
Forms![MyFormName]![MyComboBoxName]
hth

Zameer Abdulla
_{Jack of Visual Basic Programming, Master in Dining & Sleeping}
Visit Me

 

[MagicalDean]

Ahhh! Thanks so much for your help