calculate fields in different tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have various tables in one form. I want to calcuate the currency fields.
But not all fields have a number. One table has the final cost to the
customer, one table has the handling fee, one table has my fees and credits
from invoices. I want to be able to add the profit numbers and subtract the
subtract the fees to me and add the credits to me.
Should this be done in a query instead?
I tried doing this in the form design, but I am only able to choose from the
list of that particular table. I need to be able to choose all lists in all
tables.
 
Lisa said:
I have various tables in one form. I want to calcuate the currency
fields. But not all fields have a number. One table has the final
cost to the customer, one table has the handling fee, one table has
my fees and credits from invoices. I want to be able to add the
profit numbers and subtract the subtract the fees to me and add the
credits to me.
Should this be done in a query instead?
I tried doing this in the form design, but I am only able to choose
from the list of that particular table. I need to be able to choose
all lists in all tables.
Click to expand...

I would likely do it in a query because I find it more intuitive to do
it that way. You should be able to do it either way.
 
I found your reply. It did not stand out. I thought your reply was dia duit,
whatever that is.
If I can do it either way, then how is it done in the form?
--
Lisa F


Lisa F said:
What does "dia duit" mean?
Click to expand...
 
Lisa said:
I found your reply. It did not stand out. I thought your reply was dia
duit, whatever that is.
If I can do it either way, then how is it done in the form?
Click to expand...

Dia duit, is Irish Gaelic. It is an all purpose greeting, meaning "May
God be with you"

How about some more information.

I would like to know what data you need from what tables? What is the
relationship between the tables? Give me some names (real or made up) for
the fields and tables. Also provide a sample calculation showing what
fields/tables each of the numbers came from. It might also be helpful to
know exactly what data type each field is.

It is not necessary to include field names that do not enter into this
calculation.
 
You must log in or register to reply here.

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

VBA - retrieve data on last create named range from previous inserted named range 0
Copy a result of calculated control to another field 5
ADDING VALUES IN A FIELD THAT SHOW UP IN THE TABLE AND THE FORMS 1
Access How to calculate the balance carried forward of individual student when payment of fee is made in ms access 2013 1
report 1
Updating tables when you input new data 0
Function in Table 2
Complex Query Problem 1

Back
Top