Query criteria

[ineedhelp]

I am creating a database containing sales information, and the company has a
warranty policy that expires 90 after the payment date. I have a field
containing all of the different payment dates, and a field containing all of
the different company names that have bought a product. I want to create a
query that display all of the companies that have expired warranties, this
means that when the query is run, it will refer to the current date and
display the companies whose payment date was over 90 days ago. What criteria
should I enter?

 

[Dennis]

Create a column in your query called
WarrantyExpires: DateAdd("d",90,[PaymentDate])
In the criteria for this column put
<Date()