Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

delete query (delete months that are >=25 months old)

Status
Not open for further replies.
mwheads

mwheads

Programmer
Apr 24, 2004
38
0
0
ZA
Hi All

What criteria do I use in a delete query if I want to keep a stock of 2 years and delete anything that is 25 Months+.
Field name is Month

I can get it right in days but not in months.

Thanks
 
Sort by date Sort by votes
I can get it right in days but not in months
So, 2 years should be 730.5 days.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TheresAlwaysAWay
  • Locked
  • Question
Delete query takes FOREVER to run 1
Replies
11
Views
99
jedraw
jedraw
atadbitslow
  • Locked
  • Question
how to search data and display matches that include the user's input, but not necessarily match
Replies
5
Views
122
atadbitslow
atadbitslow
Moss100
  • Locked
  • Question
Create a Report from a query and then personalise the report for each client - possible?
Replies
2
Views
55
dhookom
dhookom
qqp
  • Locked
  • Question
Need my msgbox that warns user of missing criteria to stop the rest of the code from running
Replies
2
Views
70
Andrzejek
Andrzejek
BradCustom
  • Locked
  • Question
Convert Access query to SQL query
Replies
5
Views
94
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top