All, using Access 2010. I have a couple of queries below:
Code:
CustNum CustEx State Acct. CustNum State Rate
1234 1234 AL 100 1234 AL $2.00
1234A 1234A AL 100 1234A AL $2.50
1234 1234 NV 102 1234B NV $3.00
I am trying to create another query to get this result
Code:
CustNum CustEx State Rate Acct.
1234 1234 AL $2.00 100
1234 1234A AL $2.50 100
1234 1234B NV $3.00 102
But I’m getting this result.
Code:
CustNum CustEx State Rate Acct.
1234 1234 AL $2.00 100
1234 1234A AL $2.00 100
1234 1234B NV $3.00 102
I tried an IIF statement:
Code:
rates: IIF(LEN([CustRates].[CustNum]>4,[CustRates].[CustNum].[rate],[ CustRates].[ CustNum].[rate]))
but I’m getting “wrong number of arguments” error
What am I doing wrong? Can anyone help please? Thanks