G
Guest
Four Report Problems: (So you know my Control Source for the Report, it is a
Query.)
1)Sometimes, the FieldID AutoNumber, ie,â€45,†shows in the Report rather
than the entered information, ie, “Client.†I pull the Field Name from the
Field List into the Report. Incidentally, when I run the Query, “Clientâ€
shows, not “45.†If I change the text box to a combo box, sometimes the
problem is eliminated, sometimes not. But, using a Combo Box leads to another
problem:
2) I want to use the Field Name, ie [Whoes] in the “Whoes Footerâ€. Inside
the Text Box =â€Summary of “&[Whoes] & " (" & Count(*) & " " &
IIf(Count(*)=1,"detail record","detail records") & ")"
However, I cannot use the Combo Box (needed to view data input) inside the
Text Box.
3) I have “0.00†appearing throughout the report. The Default Value is set
to “0,†with the Standard Format and 2 decimal places. 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]) and when that
did not work, the comment you’d made earlier about the Null field, I put
=IIF(Nz(Client Check Amount],0),†“,[Client Check Amount])
4) The “Description Footer†and the “Whoes Footer†are appearing in the
Report above the Headers at the top of the page! (This is a new problem) I’ve
compared previous reports, the properties, etc. and can’t seem to find the
problem.
Incidentally, I don’t write code and have limited knowledge of expressions
or simple calculations.
I really hope someone has a lot of patience and can help me out. As in the
past, I’ll be extremely grateful.
Query.)
1)Sometimes, the FieldID AutoNumber, ie,â€45,†shows in the Report rather
than the entered information, ie, “Client.†I pull the Field Name from the
Field List into the Report. Incidentally, when I run the Query, “Clientâ€
shows, not “45.†If I change the text box to a combo box, sometimes the
problem is eliminated, sometimes not. But, using a Combo Box leads to another
problem:
2) I want to use the Field Name, ie [Whoes] in the “Whoes Footerâ€. Inside
the Text Box =â€Summary of “&[Whoes] & " (" & Count(*) & " " &
IIf(Count(*)=1,"detail record","detail records") & ")"
However, I cannot use the Combo Box (needed to view data input) inside the
Text Box.
3) I have “0.00†appearing throughout the report. The Default Value is set
to “0,†with the Standard Format and 2 decimal places. 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]) and when that
did not work, the comment you’d made earlier about the Null field, I put
=IIF(Nz(Client Check Amount],0),†“,[Client Check Amount])
4) The “Description Footer†and the “Whoes Footer†are appearing in the
Report above the Headers at the top of the page! (This is a new problem) I’ve
compared previous reports, the properties, etc. and can’t seem to find the
problem.
Incidentally, I don’t write code and have limited knowledge of expressions
or simple calculations.
I really hope someone has a lot of patience and can help me out. As in the
past, I’ll be extremely grateful.