Web Development

Ask something
Question Locked

Microsoft Access Query Date

0 helpful
3 replies

by jase_888

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am creating a database on sofwtare licenses, I want to create a query which brings up licenses that are coming up to thier expiry date like 3 months before hand.

I just wondered if anyone knew how to do this????

Thanks Jason

3 replies

by unhappyuser

SELECT Count([Code]) AS Processed
FROM Consumers
WHERE (((Consumers.[Type])="DATA") AND ((Consumer.[Date])

by tony hopkinson

You'll have to check the exact syntax but it would be something like

select * from Licenses Where DateSubtract(month,3,ExpiryDate) < GetDate()

This discussion is closed to new replies.