A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Four Report Problems



 
 
Thread Tools Display Modes
  #1  
Old July 29th, 2007, 11:34 PM posted to microsoft.public.access,microsoft.public.access.reports
tina
external usenet poster
 
Posts: 1,997
Default Four Report Problems

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.






 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:23 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.