Are you saying that each row has fields allowing details for 6 different
certifications and their expiration dates, like "Certification1,
Certification1ExpiryDate, Certification2, Certification2ExpiryDate, ...,
Certification6, Certification6ExpiryDate, with those not being used simply
Null? If so, I'd suggest remodelling your tables so that they're normalized.
What I've described above should be two separate tables: one containing the
personal information about the individual, and a second table that's linked
to the first table, and has 1 row for each certification. (In other words,
if an individual has 1 certification, there would be 1 row in the second
table, if the individual has 6 certifications, there would be 6 rows in the
second table.)
If that's what you've already got, you'll need to provide details of your
table layouts.
--
Doug Steele, Microsoft Access MVP
(no private e-mails, please)
Larry S. said:
I think I failed to provide enough data. My fields consist of a person's
name, other personal info and each person has multiple (6) certifications
with different expiration dates. I would like to run a parameter query,
inputting a specific month and all certifications that expire that month
will
show with the person's name, etc.
I could use some assistance in defining the criteria and where it should
be
placed.
I apologize if I've confused this more. Thanks again...
LS
Michael H said:
Hi. Try using the DateAdd function:
DateAdd("m",-1,[DateField])
-Michael
Larry S. said:
I have a field containing a date that a certification expires. I would
like
a reminder 1 month out from the expiration. How do I create a date
expression/query that will subtract 1 month from the entered expiration
date?
Thank you in advance...
LS
