how is your SQL knowledge? The best solution is 2 steps:
(1) Figure out the minimum date you want to search for. Then find the max date you want to find. The min will be sometime close to when the plate will expire (or today which is Now()) and max will be expiration date. These values will go in your SQL "Where" statement.
(2) Create and open a record set using your SQL statement to find only the relevant licenses. Use this to show all the data that appears.
Example of SQL:
Select licencePlate
from car (table)
where expiration > mindate
and expiration < maxdate
**of course you will sub in your own field names.
Thanks, I do understand Sql to a limit and would have been able to do what you
said if it was just one field that am running the search on. I have like 13 columns i need to run the search on for each car as it has various licences like Vehicle Licence, Heavy Duty Permit and all that. So what do I do?Am going to try using a join after I create separate recordset for each column, would that work?