What is wrong with my IIF expression?

Appreciate all the help but i've got it working already. thanks though.
 
I've done that one and as I pointed out you don't need to check the quantity as if only 1 is bought then you end up adding zero to the price of one, however as the price is always 10 then post 19 is all that is required.

Brian
 
I must admit that I had assumed that that would result in no entry.

Brian

Normally, I would think that too, but I never assume anything until I verify it with the end users.

I believe that my version (as long as it is correct) will also cover price changes whenever they occur.
 
Your code will only be correct if the [Menu Price] is 10! If it's anything else your code will fail! The

+5

in your code needs to be

+ ([Menu Price]*0.5

as I showed you, unless the [Menu Price] is always 10!

Try you code out where [Menu Price] is 12 and see! It is always a mistake to test an expression for validity only using one Value!

Linq ;0)>
 
Linq
That has been mentioned in my first post but Joe is not interested.

Brian
 
Last edited:
This is really eerie, Brian! I'm used to seeing you help around here, but when I last posted I had seen no posts in this thread from you! And I reviewed all posts just prior to sending my last one!

And I only thought MS Access had Gremlins about!

Linq ;0)>
 

Users who are viewing this thread

Back
Top Bottom