Hi I need to create a query whereby to find out which product needs to renew its warranty. The attributes involved are 'DateAcquired' and 'Warranty'. I prompted the user to key in the current date. Is there any way to take the difference between the inputted date and DateAcquired plus the warranty period in years? Please help.

Look for the DateDiff function.

http://msdn.microsoft.com/library/de...ctdatediff.asp