Four Report Problems

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

znibk - 29 Jul 2007 00:26 GMT

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.

Reply to this Message

tina - 29 Jul 2007 02:28 GMT

problems 1 and 2 are caused by the Lookup field you created in the
underlying table. recommend you change the field in the table to an
"ordinary" Text or Number field. for more information, see
http://www.mvps.org/access/lookupfields.htm.

problem 3 occurs because the name of the textbox *control* in the report is
[Client Check Amount]. in a calculated control, you can't refer to the name
of the control itself in the expression, so change the name of the control.

problem 4 i didn't really get, sorry.

hth

> Four Report Problems: (So you know my Control Source for the Report, it is a
> Query.)
[quoted text clipped - 13 lines]
> 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.
[quoted text clipped - 4 lines]
> I really hope someone has a lot of patience and can help me out. As in the
> past, I'll be extremely grateful.

Reply to this Message

znibk - 29 Jul 2007 19:56 GMT

Tina,

Thanks for your suggestions. I tried them and also went to the website, but
was unable to fix my problems, so would you please see if you can see what I
did wron from the descriptions I wrote below of what I did.

I went to my table and set my Field Name to "Text," on the "LookUp Tab" at
the bottom, I chose "ComboBox," Chose my "Table," "Whoes," and set the
"Column Width" to "1.5." I opened the table. I have a "Drop Down Arrow", but
when I clicked on it, the information from the "Control Source Table,"
"Whoes," shows the FieldID and the Field Name. I do not have a list of
showing whoes expense it is, ie "Joe Green." What did I do wrong?

Also, I tried addiing a new name in the Query, but it keeps telling me "You
tried to execute a query that does not include the specific expression 'Bank'
as part of an aggregate function." I looked in several "Help" sites and could
not find out how exactly I'm supposed to add the "FieldName," "Bank" to the
new name, "ClCkAmtTot:=sum([ClCkAmt])." So, I unfortunately, don't seem to
know how to do what you suggested.

And, do you know how to solve Problem 3, the unsitely "0.00" that appear
when the no check has been written making the "FieldName," "Client Check
Amount" Null.

I rechecked my Properties for the report and found I had actually chosen the
table as my "Control Source." I changed that to query, as I thought I had and
Problem 4 went away!

I hope you can help me out further. But, please remember that I am a
beginner.

> problems 1 and 2 are caused by the Lookup field you created in the
> underlying table. recommend you change the field in the table to an
[quoted text clipped - 48 lines]
> > I really hope someone has a lot of patience and can help me out. As in the
> > past, I'll be extremely grateful.

Reply to this Message

tina - 29 Jul 2007 23:34 GMT

comments inline.

> Tina,
>
[quoted text clipped - 3 lines]
>
> I went to my table and set my Field Name to "Text,"

you named the field "Text"? uh, before or after you posted? if after, then
you misunderstood me (and Duane, and MVP Marshall Barton); don't rename the
field - just go to the Lookup tab and change the DisplayControl property to
Textbox. that gets rid of the Lookup, as we suggested.

> on the "LookUp Tab" at
> the bottom, I chose "ComboBox," Chose my "Table," "Whoes," and set the
[quoted text clipped - 9 lines]
> new name, "ClCkAmtTot:=sum([ClCkAmt])." So, I unfortunately, don't seem to
> know how to do what you suggested.

here, i've no clue what you're doing. Marsh advised you to "modify the
report's
record source query to join the table to the clients table and get the
client name from there." i left that out of my post, which i shouldn't have,
as it's necessary to make the client name field(s) available in the report.

> And, do you know how to solve Problem 3, the unsitely "0.00" that appear
> when the no check has been written making the "FieldName," "Client Check
> Amount" Null.

again, you have to change the *name of the control in the report*;
presumably it's currently named [Client Check Amount]. as for the expression
itself, if you simply want to hide zero values, try

=IIf([Client Check Amount] = 0, Null, [Client Check Amount])

> I rechecked my Properties for the report and found I had actually chosen the
> table as my "Control Source." I changed that to query, as I thought I had and
> Problem 4 went away!

i hope you mean that you changed the *RecordSource property of the report*
to the query's name, *not* the ControlSource of a control on the report.

hth

> I hope you can help me out further. But, please remember that I am a
> beginner.
[quoted text clipped - 51 lines]
> > > I really hope someone has a lot of patience and can help me out. As in the
> > > past, I'll be extremely grateful.

Reply to this Message

Cool Man Dude - 29 Jul 2007 20:55 GMT

Ask Microsoft.
www.microsoft.com

> Four Report Problems: (So you know my Control Source for the Report, it is
> a
[quoted text clipped - 40 lines]
> I really hope someone has a lot of patience and can help me out. As in the
> past, I’ll be extremely grateful.

Reply to this Message