date/time query

[Steve M]

Each record has a name field and seven date/time fields. These fields are
used to record when a review date is. I need to create a query that will
show if any of the date/time fields are older than the current date. The
date/time fields are called 'desreview1' 2 etc. I need to be able to see
which person is out of date on each field. (if all that makes sense)

cheers baz

 

[MGFoster]

Each record has a name field and seven date/time fields. These fields are
used to record when a review date is. I need to create a query that will
show if any of the date/time fields are older than the current date. The
date/time fields are called 'desreview1' 2 etc. I need to be able to see
which person is out of date on each field. (if all that makes sense)

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Sounds like an not Normal table. Read about db design and Normalization
in _Database Design for Mere Mortals_, by Hernandez.

Use the IIf() function

IIf(desreview1 > Date(),"review1",
IIf(desreview2 > Date(), "review2",
IIf(desreview3 > Date(), "review3")))

Continue for all columns. Sheesh...

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQlHDx4echKqOuFEgEQLmPgCgwBtXODCvtmtt/aFD8NehAoxyBhIAmwQ3
kUBqMg/JSGmA0jbvCXGpc01m
=DYIw
-----END PGP SIGNATURE-----