Hello!
I have a db which has amongst others 5 columns with expiry dates in for certificates, all the dates are different.
I've made a query that searches all the expiry dates which are <Now()+60, this is fine, however it then returns all the columns for that record. Example:
Name: Paul
Cert 1 : 12/7/19 (within 60 days of today)
Cert 2 : 13/8/19 (within 60 days of today)
Cert 3 : 25/12/19
Cert 4 : 01/09/21
When the query runs because cert 1 and 2 are within the 60 days it picks this record from the table, but it also shows certs 3 and 4 because they are in the same record.
Is there anyway that the query can run and only show cert 1 and 2 in the above example, although cert 3 and 4 are in the same record they aren't within the <Now()+60.
But I want the query to search all these dates and then only return the fields that are true to the criteria, not every column for that record.
Does that make sense!
Thanks very much in advance!
I have a db which has amongst others 5 columns with expiry dates in for certificates, all the dates are different.
I've made a query that searches all the expiry dates which are <Now()+60, this is fine, however it then returns all the columns for that record. Example:
Name: Paul
Cert 1 : 12/7/19 (within 60 days of today)
Cert 2 : 13/8/19 (within 60 days of today)
Cert 3 : 25/12/19
Cert 4 : 01/09/21
When the query runs because cert 1 and 2 are within the 60 days it picks this record from the table, but it also shows certs 3 and 4 because they are in the same record.
Is there anyway that the query can run and only show cert 1 and 2 in the above example, although cert 3 and 4 are in the same record they aren't within the <Now()+60.
But I want the query to search all these dates and then only return the fields that are true to the criteria, not every column for that record.
Does that make sense!
Thanks very much in advance!