Parameter Value Query in Report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

david bruyntjes - 28 Mar 2007 00:18 GMT

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!

Signature

david bruyntjes

Reply to this Message

Allen Browne - 28 Mar 2007 11:50 GMT

The report is not able to read the value from the query like that.

You might be able to do it with a DLookup() like this:
=[Sum Of NormalTime] *
DLookup("[NetNT HR]", "[Full Salary Adjustment List]")

More help on DLookup():
http://allenbrowne.com/casu-07.html

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Hi,
>
[quoted text clipped - 19 lines]
>
> Any help would be greatly appreciated!

Reply to this Message