Help with "Like" Criteria

[Guest]

I'm attempting to query a field containing and ID number which contains a
date for a specific year: Example: LN1105072
Where "LN" = Initials, "110507" the date I'm after, and the "2" an employee
number.
I can set the criteria as: Like "*" & [Enter Date Desired] & "*"
and pull a specific date but would like to be able to pull all of 2007
somehow. To do this I need to be able to ask specifically for positions 7 and
8 of this ID number. Could someone please shed some light? Thanks!

 

[John Spencer]

Field: IdNumber
Criteria: Like "??????" & [Enter 2-Digit Year & "*"

OR this alternative

Field: Mid(IDNumber,7,2)
Criteria: [Enter 2-Digit Year]

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Guest]

Perfect! Thanks John.
--
If you can read this, thank a Teacher...
If your reading it in English, thank a Veteran!

Field: IdNumber
Criteria: Like "??????" & [Enter 2-Digit Year & "*"

OR this alternative

Field: Mid(IDNumber,7,2)
Criteria: [Enter 2-Digit Year]

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

I'm attempting to query a field containing and ID number which contains a
date for a specific year: Example: LN1105072
Where "LN" = Initials, "110507" the date I'm after, and the "2" an
employee
number.
I can set the criteria as: Like "*" & [Enter Date Desired] & "*"
and pull a specific date but would like to be able to pull all of 2007
somehow. To do this I need to be able to ask specifically for positions 7
and
8 of this ID number. Could someone please shed some light? Thanks!