Unsure how to do this.....

[cubbyamber]

I put the codes in just like yours are, I did the query just like yours and it's not working right. I have attached the database so you can hopefully take a look at it and tell me what I did wrong.

The query is called order details query and so is the report.

Tracy

 

[pbaldy]

I don't know exactly what you want to see. For one thing, I have grouping in mine (Sorting and Grouping) and you don't.

 

[Karma]

That can't possibly work. With an Iif() statement, you require both a True and False condition. You've got a True condition, e.g. '1*[Service Price]', but no False condition. That's not going to fly.

Bob

Actually you don't, if you don't supply the false condition it will return a null value.

 

[cubbyamber]

Thank you, I got it figured out. I had to mess with it a little bit but it worked. I would like to send you a token of appreciation for all the hard work and effort you have put into this and helping me. Let me know where I can send it.

Tracy