how do I enter parameter values?

[Guest]

I am having trouble with two fields for which I need cumulative sums on a
report. They look exactly like two other fields (in terms of properties) in
the database that are working but for some reason, when I create a report, it
asks me to enter the parameter values for these two fields and I cannot
figure out what is wrong. Basically, it needs to calculate anything greater
than 0. Almost all the numbers in this field are 3 or less. I just don't
understand how these two fields differ from the other two.

Help is appreciated.

KarenK

 

[Guest]

Couple things to check for...

Make sure the field names in the report are the ExAcT same as the field
names in the table/query.
Is your report based off a query? If so, is there criteria for these
fields? If so how is it written?
If the report is based off the query, does the query yield the results you
want or does it give you the same error message?

Let me know if any of these helped.

 

[Guest]

Micah:

I used the report wizard to create the report, pulling in the fields I
wanted to see in the finished product. Four of those fields were number
fields. I typed in everything properly in the properties box under Control
Source to calculate the sums, but only two of the fields work. I've compared
all four fields and the two that don't work look exactly like the ones that
do (except where necessary). If there is a fundamenetal problem somewhere
I'm just not seeing it. I want to calculate anything greater than 0. Sigh...

 

[Guest]

Can you post all those formulas? All four of them. Looks can be deceiving.
I have good news and bad news. The good news is there is something very
simple that we can correct that'll get your report to work properly. The bad
news is since I'm not at your computer looking at what you're looking at, I
need your help to determine what that simple thing is. You're being very
general in describing the problem. There are some usual suspects, but when
those fail, we need a little bit of detail to determine the problem. So I
need from you some details...Is this report based off a Query or a Table? I
know you used a wizard, but the answer helps narrow down the list of
culprits. What are the formulas in the fields that work and the fields that
don't work? Are these fields unique to the Report (meaning you built them in
the report) or are these fields unique to the Query (again if the report is
even based off a Query)? I'm more than happy to help as soon as I know this.

 

[Guest]

Micah:

I'm sure the solution is simple too. The report is based on a table, using
fields created for the table. I'm very new to Access so I don't know what
some of the terms mean. When you ask about the formula, do you mean the
formula for the calculated sum in the ControlSource? I wrote
=Sum([numberattending]).

I appreciate your help - and your patience!!

Karen

 

[Guest]

Micah:

PROBLEM SOLVED! You were right - I didn't type the fields exactly as they
were in the table. I left out the space between the words. Whew!

Thanks so much!

Karen