Query with dates and text

[theworm]

We have a training database in our company, some of our classes expire in 6 months, 1 year, 2 year and some will never expire. I have been adding 100 years to the never expire ones, but some people don't like that method. Is there a way that I could have the date expires displayed as the true date and when the date expires is > than x it will display "Never"?
Thanks for any help.

[jzwp11]

In your table, if you leave the date field blank (null) for classes that never expire and have dates for those that do, you can use an isNull() function nested in an IIF() function in a query to display what you want. Something along these lines should work

SELECT classname, IIF(isNull(expirationdatefieldname),"Never",expirationdatefieldname) as Expiration
FROM yourtablename

[weekend00]

Is there a way that I could have the date expires displayed as the true date and when the date expires is > than x it will display "Never"?

if the [date expires] field is a data/time field, you can't put "Never" in the table, but you can show "Never" in reports or queries or forms

Please see jzwp11's query example.

[theworm]

I will try your suggestions.
Thanks

[jzwp11]

Please let us know if it works out for you.