Query Criteria!

[Bob V]

Only records that are 3 years old, <1095 days Is this possible Thanks for
any help....Bob

 

[Bob V]

This does not work because Date field is Text <Date()-"1095" Thanks for any
help..Bob

 

[John W. Vinson]

This does not work because Date field is Text <Date()-"1095" Thanks for any
help..Bob

What are the contents of this misnamed Date field? Text that looks like a
date? a number? or what?

John W. Vinson [MVP]

 

[Bob V]

Thanks John, it is [DateNo] and its is a text field so as I can display it
to look like this on a form 25-Dec-07
thanks Bob

 

[John W. Vinson]

Thanks John, it is [DateNo] and its is a text field so as I can display it
to look like this on a form 25-Dec-07

Do you also have a Date/Time field in the table? If so, you can simply display
IT using dd-mmm-yy as the format of a form textbox. There is NO need to store
date information in a text field, and (since Access won't recognize it as a
date) every reason not to do so!

John W. Vinson [MVP]

 

[Bob V]

Thanks John, Change the field to Date/Time Great...Bob

Thanks John, it is [DateNo] and its is a text field so as I can display it
to look like this on a form 25-Dec-07

Do you also have a Date/Time field in the table? If so, you can simply
display
IT using dd-mmm-yy as the format of a form textbox. There is NO need to
store
date information in a text field, and (since Access won't recognize it as
a
date) every reason not to do so!

John W. Vinson [MVP]