***Update:- Just cracked this one by using T-SQL, if anyone needs the solution please just let me know, thanks.***
Hi all, I'm trying to create a query in Access 2010 based on a warranty_expiry field (data type: Date/Time) that will give me all the records where the warranty is due to expire between 90 and 31 days prior to the current days date (I'll then do another to pick up the ones that fall into the 30-0 days catagory afterwards). Needless to say I'm struggling, can anyone assist please?
KR, M
Hi all, I'm trying to create a query in Access 2010 based on a warranty_expiry field (data type: Date/Time) that will give me all the records where the warranty is due to expire between 90 and 31 days prior to the current days date (I'll then do another to pick up the ones that fall into the 30-0 days catagory afterwards). Needless to say I'm struggling, can anyone assist please?
KR, M
Last edited: