You need to use the Mid() function as in my posts #9 and #13
I have tested it. It seems to work!
Access Developer
Windows XP 
Access 2003
You need to use the Mid() function as in my posts #9 and #13
I have tested it. It seems to work!
If this helped, please click the star at the bottom left of this posting and add to my reputation. Many thanks.
Bob Fitzpatrick
Access Developer
Windows XP Access 2003
You need to use the Mid() funtion not Left().
See my posts #9 and #13
Sorry. Thought my last post had been lost. Can't see how to delete this one.
If this helped, please click the star at the bottom left of this posting and add to my reputation
Bob Fitzpatrick
Moderator
Windows XP Access 2003
My error, I went back and copied something -- the wrong something -- Bob was right that Mid() should be used.
His(Bob) statement should work.
DUXPrice: IIf(Mid([WBCode],4,1)="X",([WBCost]*2)*(9/10),Null)
I personally would use
DUXPrice: IIf(Mid([WBCode],4,1)="X",([WBCost]*2)*(9/10),0)
but you must also ensure that your WBCost values exist.
If you get all 0 responses, then your Iif has been found to be False.
Try again and let us know.
Access Developer
Windows XP Access 2003
I think the OP said that WBCost would never be Null but incase it use:
DUXPrice: IIf(Mid([WBCode],4,1)="X",(Nz([WBCost],0)*2)*(9/10),0)
If this helped, please click the star at the bottom left of this posting and add to my reputation
Bob Fitzpatrick
Advanced Beginner
Windows 7 64bit Access 2010 64bit
Got it working - thanks a million
DUXPrice: Round(IIf(Mid([WBCode],4,1)="X",([WBCost]*2)*(9/10),0),1)
Moderator
Windows XP Access 2003
!!! don't forget to bookmark the link with all the functions with examples !!!
Glad you got it working.
Posting Permissions
Reply With Quote