Hi,<br> I'm making a report. I have a criteria called household size and in the report if the household size is one, then i want it to display a checkmark in the checkbox in the column under 1. How do i write the expression in this case? If it doesn't make sense, respond that it doesn't and i'll explain more...<br><br>Jim <p>Jim Smitty<br><a href=mailto:jimschmitty@hotmail.com>jimschmitty@hotmail.com</a><br><a href= > </a><br>
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
If, then what???
- Thread starter JimSmitty
- Start date
you can add many nested IIfs...<br><br>Do you have groups of size like 1-5 6-10 ???? How many columns? What does the sql of your query look like?- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question