to query a date of birth but the date field is in text data type 1

[soulpecker]

i'm trying to query a date of birth field wherein i want to have it in ascending order on a specified month. for example, i want to see names of people whose birthday starts from 01oct to 31 oct.the year doesn't matter. the problem is the field was not in date data type but in text.i cannot change it to date data type because all dates in this business are written like 991030 instead of 10/30/99. i tried the wildcards but didn't work. thanks for the help!

 

[elizabeth]

You can use Access's built-in string functions to isolate the substring you're interested in. Add a calculated column to your query such: "BirthMonth: Left(Birthdate, 2)" -- then you can sort or use selection criteria on that field.

 

[Guest_imported]

Another idea is to use &quot;Like 9910*&quot; in the criteria. Seems like this would work... <p>John Vogel<br><a href=mailto:john@computerwiz.net>john@computerwiz.net</a><br><a href=

http://computerwiz.net>ComputerWiz</a><br>

 

[elizabeth]

Oops! When I looked again I saw that the month is the middle 2, rather than first 2 characters. So the string function would be: BirthMonth: Mid(Birthdate, 2,2).