Query

S

Swansie

hello
I have a form that calculates a total price given a product price per
quantity and amount needed. This total price is not stored in a table but can
always be referenced to in the form. How can I query this? I tried putting
Expr1: [Forms]![adhesive]![Total$] in the query under a field name...doesnt
work

Thanks
 
F

FSt1

hi,
don't reference the form in the query. re-do the calculation.

in the query header for the total put something like this

Total$:[Price]*[quantity]

regards

FSt1
 

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

Query doesn't recalculate 2
Error when calculating form fields 2
Create multiple reports on the one form 2
Append Crosstab Query to Existing Table 0
Calculation Question 13
Display Report Total in Form 1
Calculating a value in a form that fills in the original table 1
Data Validation 1

Top