0

Hi, I'm currently creating a database and need to create a query to show all the records that the warrenty date expires within the next week. i know this is a simple query as I did it when doing my A-Level in computer studies however I was working in a pub for the last year and am out of practise. So far I have simply put the criteria in the warrenty expiration date as ">=Now()+7" however that seem to be displaying the records with a date between now and 7 years from now. I hope someone can help me with this before I do too much damage to myself banging my head against my desk. thanks.

3
Contributors
2
Replies
3
Views
12 Years
Discussion Span
Last Post by ingrid kalnins
0

Hi, I'm currently creating a database and need to create a query to show all the records that the warrenty date expires within the next week. i know this is a simple query as I did it when doing my A-Level in computer studies however I was working in a pub for the last year and am out of practise. So far I have simply put the criteria in the warrenty expiration date as ">=Now()+7" however that seem to be displaying the records with a date between now and 7 years from now. I hope someone can help me with this before I do too much damage to myself banging my head against my desk. thanks.

If you find out, can you help me work out the query for all records with a deadline date before a certain date.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.