My IIF statement is in the detail portion of the report. It is in a Text box for the code.
Its like this IIF([tbldetail.code] not like "other*" and [tbldetail.code] not like "cash advance*", [tbldetail.code])
In the detail portion of the report I have a code field that I want to display on certain information. I have an iif statement setup to display the ones that I want showing but in the else portion I don't have doing anything so it just leave a blank spot on the report like this.
Marker 1000...
I already have it set to 255 in the table. My problem is on the form I want to only allow the user to be able to type in that many charcters because if they type in more than that the program blows up.
I am trying to use the field balance twice in a report. Each balance is for a different date. I made two separate queries for the two balances and used one query within another. When I try to use the fields in the report it says that the field balance may be referring to more than one table...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.