Report Problems--Three Questions

[Guest]

This database is the first time I've used the AutoNumber as my Primary Key
and I'm having many trials. As the Subject says "Three Questions."
1) I use a query to my reports. Sometimes, the FieldID AutoNumber, ie, “13,â€
shows in the Report "Print Preview" rather than the entered information, ie,
“Joe Green.†I pull the Field Name from the Query. Incidentally, when I run
the Query, “Joe Green†shows, not “13.â€

2) The “Description Footer†and the “Whoes Footer†are appearing in the
report above the headers at the top of the page!

3) I have “0.00†appearing throughout the report. All default values set to
“0,†I don't want that. I'm afraid if I go back and leave the Default Value
blank, that may create even more problems in the future, so I tried the
following two expressions in the field text box and get an Invalid Control
Source and Circular Reference message when I try to get out of the text box.
I tried
=IIF(Is Null([Client Check Amount]),†“,[Client Check Amount])
When that did not work, I tried
=IIF(Nz(Client Check Amount],0),†“,[Client Check Amount])
Any help would be greatly appreciated.

 

[Guest]

1) don't use lookup fields in tables
http://www.mvps.org/access/lookupfields.htm. If you want to see a text value
then include the table containing the actual text in the report's record
source.

2) You haven't told us anything about your sorting/grouping and
headers/footers. You may be having issues with the Force New Page property

3) If you want to display a numeric text box containing a 0 as empty, just
set the Format property. Don't do anything to the control source. Also, if
you change the control source to an expression, you must make sure the name
of the text box is not the name of a field. Also, I would not create an
expression that might return a string or might return a number. If you really
need to use IIf(), I would use

=IIF(Nz([Client Check Amount],0)=0, Null, [Client Check Amount])