Logical Functions in queries

[Mschneider331]

I need do create a query that will display:
Company Name
Invoice Number
and a message the will say "check for volume discount" if the quantity orders is at least 5, and they are not getting a discount percent.

I know how to create the query just don't know how to create the message.

[Micron]

Add a calculated field to your query and put criteria on it that satisfies your limit for the message, along with whatever other limits there are (perhaps such as 'where discountpercent <> Null')
Message: IIf([qty]> 5,"check for discount","")

[Mschneider331]

Thank you. I figured it out, but now I need it to only display the ones that didn't get a discount. I tried typing in 0 in the criteria but it doesn't work. This is what the discount field looks like when its 0 discounts even though they purchased 5 or more items.

[Micron]

You'll have to post more info than that. Try to imagine me trying to solve this with what you are showing; no sql statement, no image of the query design - only a relationships picture and a snippet of results that isn't what you want.