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')
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')