So for the homework, I put the IIF function for the quote and paid as fields on the report instead of part of the query.

Any Con to doing that, other than you can't get to that field from another report?

Is there a limit on how many fields you can have in a query?

Thanks

---

Reply from Richard Rost:

It's been over a year since I recorded that, so I don't remember what the homework was... but just do whatever I said to do in the video. LOL. Ha ha. :)

This is one of those "6 of one way, half-dozen of another" things. There's really no BEST way to do it - whatever works for your situation. Part of me teaching you alternatives is so that you can see what might work best for each scenario.

There is a limit to the number of fields you can have in a query, but realistically you should never hit it.