Arithmetic in reports

[Speedy]

Hi there,

I have a simple report where a group is defined and in that group I have a
computed field which is qty*price=value. This works fine so far.

Now I have more than one line per group and would like to calculate total
qty and total value per group. Now total qty works fine with =SUM([qty]) but
when I try to do the same things with value (a computed field) at run time it
requests input (pop up "Enter Parameter Value"). I do not understand this.
Any suggestions?

Also is there a good reference article that explains Access maths in reports
and forms to which I could be directed?

Cheers
Speedy

What am I doing wrong?

 

[Allen Browne]

Try repeating the expression, e.g.:
=Sum([qty] * [price])

In a group footer on your report, you can sum a field, but not a control.

 

[Speedy]

Dear Allen,

Yes that works fine thanks. I also understand why too.

Thanks

Speedy

Try repeating the expression, e.g.:
=Sum([qty] * [price])

In a group footer on your report, you can sum a field, but not a control.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Hi there,

I have a simple report where a group is defined and in that group I have a
computed field which is qty*price=value. This works fine so far.

Now I have more than one line per group and would like to calculate total
qty and total value per group. Now total qty works fine with =SUM([qty])
but
when I try to do the same things with value (a computed field) at run time
it
requests input (pop up "Enter Parameter Value"). I do not understand
this.
Any suggestions?

Also is there a good reference article that explains Access maths in
reports
and forms to which I could be directed?

Cheers
Speedy

What am I doing wrong?