I have a database where a table will be imported and it has a date field that i want to be able to subtract from the current date. With in a query is it possible to code it where it looks for the date in the table and where ever there is a date it subtracts that date by the current date the query is ran? I hope thats not confusing. When the table is imported it will not have a field that is labled "current date" but i am hoping there is a code or something that I can use that will look at the date that is within the table imported and subtract it by the current date the query is ran. Please help if anyone thinks they can ... thanks ....