Access Help Access number expression query

Joined
Jun 15, 2005
Messages
1
Reaction score
0
hey, just joined today..

Anyway need help with a query.

Im trying to create an IFF query expression in Access,

Im trying to check if a string of 12 numbers is between an input start and input end number range.

problem is the input numbers consist of 10 digits meaning i need to remove the first 2 digits of the 12 number string somehow.

i.e parcel number = 031111111111 (string)
input the start range number as 100000000 (integer)
input the end range number as 2000000000 (integer)

i need to exclude the 03 from the 12 digit parcel number which is saved as string.
(i cannnot change the format of the parcel number field.)

can anyone help.

code being used is as follows.


Expr1: IIf([PA Parcel Record]![Parcel_Number] Between ([Parcel Range - From]) And ([Parcel Range - To]),'match','wrong')
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top