Sum

  • Thread starter Thread starter John
  • Start date Start date
J

John

Hi
I have a bound field in the details section on my form which shows the price
of items in stock.
nect to this field I have an unbound field with the following inserted.
=sum([Price])
I am trying to get a sum of the price field. The textbox [sumprice] just
shows me "error"

Any Ideas

Regards

John
 
Hi
I have a bound field in the details section on my form which shows the price
of items in stock.
nect to this field I have an unbound field with the following inserted.
=sum([Price])
I am trying to get a sum of the price field. The textbox [sumprice] just
shows me "error"
Click to expand...

The Sum control must be in the form's Footer - not in the detail section.

John W. Vinson [MVP]
 
Many Thanks John
Kind Regards

John

John W. Vinson said:
Hi
I have a bound field in the details section on my form which shows the
price
of items in stock.
nect to this field I have an unbound field with the following inserted.
=sum([Price])
I am trying to get a sum of the price field. The textbox [sumprice] just
shows me "error"
Click to expand...

The Sum control must be in the form's Footer - not in the detail section.

John W. Vinson [MVP]
Click to expand...
 

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

Similar Threads

Calculated Fields 4
how to set the Default Value of a Control Box to a Lookup Table 0
Sum If function in textbox 0
Sum Calculated Field Question 1
Record sum from subform 1
Running Total from a Subform 1
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Calculated Field 3

Back
Top