S
Sam
Ok I will try to explain what am I doing and why. I have device
specifications from Access database. I devices from different categories so
there has to be multiple tables, one for each category. Each device has
"amount" field (counted) which is multiplied with "power consumption" field.
This is because value has to be shown to user. This value (field=amount*power
consumption) has to be summed from every device because total consumptions
has to be shown for user also. So I first sum this value in each table
(field2=sum("field")). Then I have to sum field2 from every table to get the
total power consumption. I use similar way when summing the price fields
(three different price values). Of course form gets pretty "heavy" and
waiting times are pretty long, but the biggest problem is that the form
doesn't complete all calculations and it's pretty unsafe to use for customer.
So any kind of proposals to ease the countings or the structure of the form
are welcome.
Thanks
specifications from Access database. I devices from different categories so
there has to be multiple tables, one for each category. Each device has
"amount" field (counted) which is multiplied with "power consumption" field.
This is because value has to be shown to user. This value (field=amount*power
consumption) has to be summed from every device because total consumptions
has to be shown for user also. So I first sum this value in each table
(field2=sum("field")). Then I have to sum field2 from every table to get the
total power consumption. I use similar way when summing the price fields
(three different price values). Of course form gets pretty "heavy" and
waiting times are pretty long, but the biggest problem is that the form
doesn't complete all calculations and it's pretty unsafe to use for customer.
So any kind of proposals to ease the countings or the structure of the form
are welcome.
Thanks