Support Required (1 Viewer)

majid.pervaiz · Jan 20, 2018

Dear Friends,

I have one table where i have multiple expiry fields, i would like to see the records which will be expiring in coming one month.
So for example, in one record i have all these different dates if one of the date is even falling in the criteria (i.e. expiring in one month) the result should show the record.

i am attaching the database also for your easy reference, it is one table database only

i would really appreciate your support on this
:banghead:

jdraw · Jan 20, 2018

Your database has 4 tables?
I recommend you research Normalization to assist you with design.
You should avoid names with embedded spaces.
Good luck.

mike60smart · Jan 20, 2018

Hi

I take it that the Driver Information is your main table.

A driver's Licence will expire after a set Number of Months.

To maintain a History of these expiry dates you need to have a table to record these records.

The same applies for Passport and Driving Permit Expiry Dates.

Also a Driver on a Specific DATE will drive a Specific ROUTE and pickup a Number of Students.

This means you need more than 1 table to record this process.

Your table also needs a Unique Autonumber Primary Key field and NOT the ID_No you are currently using as a Primary Key.

arnelgp · Jan 20, 2018

Checkout the queries i made.
I think no need to make history of those expiry. Just overwrite the old ones. Nobody is interested on expired date.

majid.pervaiz · Jan 20, 2018

True I am not interested to save expiry .. I just want user to know that the id/passport/license .. whenever one of it will be expiring in coming one month the user should be notified

majid.pervaiz · Jan 20, 2018

Dear Arnelgp,

thanks for your support to make these 4 queries, how i can show this as one record because there is repetitions also

arnelgp · Jan 20, 2018

There is another query qryExpireAny. At the right mist column is the status whuch one is expiring/expired.

majid.pervaiz · Jan 20, 2018

arnelgp said:
There is another query qryExpireAny. At the right mist column is the status whuch one is expiring/expired.

Bro - you are simply access genius ...

Support Required (1 Viewer)

majid.pervaiz

Registered User.

Attachments

jdraw

Super Moderator

mike60smart

Registered User.

arnelgp

..forever waiting... waiting for jellybean!

Attachments

majid.pervaiz

Registered User.

majid.pervaiz

Registered User.

arnelgp

..forever waiting... waiting for jellybean!

Attachments

majid.pervaiz

Registered User.

Similar threads

Users who are viewing this thread