Hi, I need some help. Sorry for my english.
* What I need: get the sum totals of my tables and be able to edit them after in a form for my small bussiness.
* What I have:
-Different Tables related for choosing countries, travel agencies, employes
-All the data entry is trough Forms because I have different employes
-For every table of the incomings ($) I have 3 different currencies to sum (Euro, Dollars and Shekels)
TABLES:
*Incomings
Agency
ID
AgencyID
Date
NIS (Israel currency)
Dollars
Euro
Notes
Singles
ID
FirsName
LastName
Adress(divided in adress, city, country, etc.)
NIS
Dollars
Euro
Notes
Another tables like this ones with more or less the same fields, but all of them with this 3 fields of different currencies.
*Outgoings
Library
ID
Date
Employee
NIS
Dollars
Euro
Notes
Food
ID
Date
Employee
NIS
Dollars
Euro
Notes
Another tables like this ones with more or less the same fields, but all of them with this 3 fields of different currencies.
So once again, I need to sum all the incomings, all the outgoings, for every month and for every year.
Am new using Access so maybe am violating all the Access rules making this design, and that's why am not able to do what I need. Thank you for your help.
Silvio