getting a total from different sources.

M

Michael

I used to have a subform where the user inserted each the data for every
field and I had an equation to get the total weight [EsigenzainKG] as
follows

=[Colli x Pedana]*[N° Pedane]*[Desc]*[netto]/1000

then I created a query for one of the other fields called [confezione] that
has a list of the packaging and the weights and how many fit on a pallet and
so on and they query is called "confezionequery".

When the user chooses a type of package in [confezione], the [Desc]and
[netto] are displayed via =txtconfezione.Column(3) and
=txtconfezione.Column(1).

I need those values to get my [EsigenzainKG] . I tried the sql below and
that does not work,


=[Colli x Pedana]*[N°
Pedane]*[confezionequery].[Desc]*[confezionequery].[netto]/1000

any advice would be greatly appreciated.
Michael
 

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

Need to search by date, but do not want the date reflected in results 6
More of a math question,but I am stuck getting a correct figure. 6
Running Total 1
Suggest technique for a totals control based on subform 1
How do I have a listbox in a form update a query 2
calculating other fields based on a formula in a report 16
Pull a random number more often 0
Update one field from one table to another field in another table. 2

Top