lemondrop9344
New member
- Local time
- Today, 05:08
- Joined
- Feb 11, 2018
- Messages
- 5
I am trying to evaluate the contents of a field entitled FASITYTPE from a database created by another entity. The field will contain a value of 1, 2 or 3.
If the value is 1, I want to add 2688876544 to create a field entitled SERIALNUMBER and place it in a field entitld TXID. If the value is 2, I want to add 2600468480 to the SERIALNUMBER and place it in the TXID field. If the value is 3, I want to place TYPE 3 in the TXID field.
This is (along with other variations) is what I am trying to get ACCESS to process:
TXID: IIf([FASITETYPE]=1,([SERIALNUMBER]+2688876544),IIf([FSAITETYPE]=2,([SERIALNUMBER]+2600468480),"TYPE 3"))
When I run the query, I am prompted for a FASITYTPE parameter. It's been a while since I've played around with ACCESS. Please help me to understand where I've messed up with my statement.
Thanks in advance for any help.
If the value is 1, I want to add 2688876544 to create a field entitled SERIALNUMBER and place it in a field entitld TXID. If the value is 2, I want to add 2600468480 to the SERIALNUMBER and place it in the TXID field. If the value is 3, I want to place TYPE 3 in the TXID field.
This is (along with other variations) is what I am trying to get ACCESS to process:
TXID: IIf([FASITETYPE]=1,([SERIALNUMBER]+2688876544),IIf([FSAITETYPE]=2,([SERIALNUMBER]+2600468480),"TYPE 3"))
When I run the query, I am prompted for a FASITYTPE parameter. It's been a while since I've played around with ACCESS. Please help me to understand where I've messed up with my statement.
Thanks in advance for any help.