comments inline.
"znibk" wrote in message
...
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,"
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
"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.
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.
"tina" wrote:
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
"znibk" wrote in message
...
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.