Report-Expression-Enter Parameter Values

D

david bruyntjes

Hi,

I'm designing my first database and have run into the following problem;

In a report I am designing I would like to have a calculation at the end of
the report that multiplies a sum that has been calculated in the same report
with a value that has been calculated by a specific query I have designed.

In the text box in the report I have the following expression:

=[Sum Of NormalTime]*[Full Salary Adjustment List]![Net NT HR]

When I try to view the report in the Normal View the report asks me to enter
parameter values for the Query from which I have taken specific values for
the above mentioned calculation (Full Salary Adjustment List). As far as I
know this Query is not a parameter query and I haven't set any such
parameters in any of the tables and queries that contributed to its creation.

Any help would be greatly appreciated!
 
D

Damian S

Hi David,

Any time a query prompts you for parameters it means that it doesn't
understand a field that you have referenced, therefore it prompts you to
specify it. Go back through your query and check that you haven't
accidentally mis-typed a field name etc. Do the same on your report, and
with your sorting/grouping.

Other than that, perhaps your field should be
=[SumOfNormalTime]*[Net NT HR]

Hope that helps.

Damian.
 
D

david bruyntjes

Hi Damian,

First off thanks for your help. Unfortunately however, I still seem to be
having some troubles.

Previously Access prompted me for the parameter values for the query 'Full
Salary Adjustment List'. I tried your suggestion to type only the relevant
field name and then the programme prompts me for the parameter values of that
field name, 'Net NT HR'.

I wrote the expression in the expression builder, therefore I gather that
the spelling error is a result of earlier mistakes.

This leads me to the process in which the query (Full Salary Adjustment
List) was designed. The query was designed based on the data and results of
six other tables and queries. As far as I know now there are no spelling
mistakes in these tables and queries. The queries were built with the help of
the drop-down list in query design view.

I gather that the problem may either lie in

a) the grouping and sorting which you mentioned, and honestly does confuse
me a tad. If you could enlighten me upon this I would much appreciate it.

or

b) the fact that the Full Salary Adjustment List query is based on too many
tables and queries and stumps Access' computing prowess. I read somewhere
this could be the case, or am I underestimating the powers of the programme?

Cheers,
--
david bruyntjes


Damian S said:
Hi David,

Any time a query prompts you for parameters it means that it doesn't
understand a field that you have referenced, therefore it prompts you to
specify it. Go back through your query and check that you haven't
accidentally mis-typed a field name etc. Do the same on your report, and
with your sorting/grouping.

Other than that, perhaps your field should be
=[SumOfNormalTime]*[Net NT HR]

Hope that helps.

Damian.

david bruyntjes said:
Hi,

I'm designing my first database and have run into the following problem;

In a report I am designing I would like to have a calculation at the end of
the report that multiplies a sum that has been calculated in the same report
with a value that has been calculated by a specific query I have designed.

In the text box in the report I have the following expression:

=[Sum Of NormalTime]*[Full Salary Adjustment List]![Net NT HR]

When I try to view the report in the Normal View the report asks me to enter
parameter values for the Query from which I have taken specific values for
the above mentioned calculation (Full Salary Adjustment List). As far as I
know this Query is not a parameter query and I haven't set any such
parameters in any of the tables and queries that contributed to its creation.

Any help would be greatly appreciated!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top