If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Report Problems--Three Questions
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. |
#2
|
|||
|
|||
Report Problems--Three Questions
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]) -- Duane Hookom Microsoft Access MVP "znibk" wrote: 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. |
Thread Tools | |
Display Modes | |
|
|