how do I enter parameter values?

K

KarenK

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
 
M

Micah Chaney

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.
 
K

KarenK

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
 
K

KarenK

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
 
Top