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

  • Thread starter Thread starter KRISH
  • Start date Start date
K

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
 
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
 
Back
Top