J
jojo1uf
Hi,
I have 2 fields: Effective Date (xx/xx/xxxx) and Expiration Date
(xx/xx/xxxx). I want to prompt the user for the effective date and the
expiration date. I want all the records that fall within that specified
range.
*Also, I want another query to search a date field (xx/xx/xxxx) for the year
(ie. 2004, 2005) only.
Your expertise is greatly appreciated.
I have 2 fields: Effective Date (xx/xx/xxxx) and Expiration Date
(xx/xx/xxxx). I want to prompt the user for the effective date and the
expiration date. I want all the records that fall within that specified
range.
*Also, I want another query to search a date field (xx/xx/xxxx) for the year
(ie. 2004, 2005) only.
Your expertise is greatly appreciated.