What are the proper Criteria for a Field?

[Doug]

I have a Table created for membership to a club. There is a Field with the
Data Type: Text, and using an INPUT MASK is: 0000\LLL\00;0; that reads:
ex. 2005 Mar 20. It was created this way because the user
inputting the data was making too many mistakes. In the Table using Text
Filters I am able to filter all the years that I want but the months and days
are NOT in proper order. I have the same problem when I create a Query using
a criteria. I know there is a blank between the year, month and day. What
can I do to create a criteria that would fix this problem?

 

[XPS350]

I have a Table created for  membership to a club.  There is a Field with the  
  Data Type:  Text,  and using an INPUT MASK is:  0000\LLL\00;0;  that reads:
             ex.  2005 Mar 20. It was created this way because the user
inputting the data was making too many mistakes.  In the Table using Text
Filters I am able to filter all the years that I want but the months and days
are NOT in proper order.  I have the same problem when I create a Queryusing
a criteria.  I know there is a blank between the year, month and day.   What
can I do to create a criteria that would fix this problem?

Why don't you use a DATE field to store DATES? That would make life
much easyer.

Groeten,

Peter
http://access.xps350.com

 

[Arvin Meyer [MVP]]

Text fields will not store dates in the proper order. You must use the Date
datatype to store your dates. Set the Regional Settings in the Control Panel
for the way you want to display the date.

 

[Doug]

Thankyou very much Arvin for your constructive reply.
I have tried your suggestion and it works just fine.
Thanks again for your time.