Report based on Expiration Dates

[LadyDev]

Can I generate a report based on expiration dates of the user? Similiar to the password scenario --- 'your password is about to expire in 2 days, do you want to change'.

But instead of a pop-up I want to push a cmd button to generate the report with all expired --and/or-- will expire in x days report.

Does anyone know how I can start the code? Thanks!

 

[Trendsetter]

If you are using a menu or switchboard system then you can make an command button visible on the menu when the user is within say 10 days of expiration. The command button can be connected to a report which will list the users that need to be informed of impending expiration.
A report would need to have criteria in the query that is used to populate the report that calculated the number of days past or to the expiration date:
DaysateDiff([ExpirationDate],Date())
Set the criteria to say <10 which would then show those that will be within the next 10 days and those that have already expired.

 

[fixious]

How do I do this query, really basic member here. Thanks