Please Help??????????

[KRISH]

Hi!
Everybody

I am using [ID] like "M001", "M002", ..... in my Table. I
want to get a report with a criteria say the [ID] from
M053 to M077. Please help how to get the report.

Krish

 

[Wayne Morgan]

Try criteria similar to

CInt(Right([ID], 3)) Between 53 And 77

or to do this in a query, you would make a calculated field

Field: Expr1:CInt(Right([ID], 3))
Criteria: Between 53 And 77