Recent content by Cicely DeMars

Is there a way to get a separate page for each page of the report, kind of like a mail merge without going to Word to do the merge? Thank you for any help.

I thought about doing the case or the multiple field table, I was hoping to aviod them, but that's what I will try next. Thank you for the help!!

I have an IIF() that has to evaluate one of 55 possible entries in the county field, then return one of 18 values in the district field. I tried using the IIF and typing it out, but Access says it is to complex, (not to mention tough to keep track of for me). ex...

That is the same issue that I am dealing with. Look at the 'urgent' post by wrekless on 7/18 see if that would work for you. I am going to try it for my report.

I am in need of instructions on how to supress fields in a report where the field contains no data, and move the remaining fields into the empty space. Example: A roster of members listing contact info and a member has no fax number listed. The next entry, email field, will then move into the...