Hello,
I am creating a database and new to access. I have been going through the tutorials here to clean up what i have done thus far. However, it seems I have bitten off more than i can chew.
Please I am asking for your help.
I want to build a query that finds the minimum date which will now be the new expiry date for a vehicle permit.
The table has four (4) columns namely SPE, RE, COFE, & IE. These are all dates. from that one record i need to find the earliest date which would now be the new expiry date.
Permit#(pk) SPE RE COFE IE
PT-001 5/11/20 10/31/20 8/9/20 3/11/20
How do I do that?
Thanks for your help.