Calculated Fields (1 Viewer)

lnoles

Registered User.
Local time
Today, 02:17
Joined
Dec 22, 1999
Messages
19
Whenever I add a calculated field in my report, I get a dialog box asking me to 'Enter Parameter Value' when I open the report.
I am using query results in my calculations.
=[QueryName]![CountOfType]
Any Suggestions?
 

Travis

Registered User.
Local time
Yesterday, 19:17
Joined
Dec 17, 1999
Messages
1,332
I found I got this kind of error for a calculated field when the field that I was referencing was not on the report.

e.g. I want to concatinate the First Last and Middle name fields so on my report the fields control source looks like this:

=[firstName] & " " & [MiddleName] & " " & [LastName]

Access requires that the [firstName], [MiddleName] and [LastName] fields be apart of the report. Just make them hidden and no one will be the wiser.
 

Users who are viewing this thread

Top Bottom