The Archn00b
Registered User.
- Local time
- Yesterday, 16:50
- Joined
- Jun 26, 2013
- Messages
- 76
Hello everyone,
I think this is a vba question at heart so I've posted this here.
Adding fields into a function has been a problem for me:
The logic I'm trying to create is the following: If the number of Fuel Types is greater than two, then the field will have the value 'MPS.' Otherwise, the field will just have the regular fuel type value. It's referencing this fuel type field in the function that is the problem. I have not been able to get this working.
Any ideas? Thanks!
I think this is a vba question at heart so I've posted this here.
Adding fields into a function has been a problem for me:
Code:
IIf((Count([qryADDR].[Fuel Type]>2), 'MPS', [qryADDR].[Fuel Type])
The logic I'm trying to create is the following: If the number of Fuel Types is greater than two, then the field will have the value 'MPS.' Otherwise, the field will just have the regular fuel type value. It's referencing this fuel type field in the function that is the problem. I have not been able to get this working.
Any ideas? Thanks!