I have two tables name tblAMKCC71 and tblAMKCGP:
In tblAMKCC71 fields are: overnight, dayshift, eveningshift
In tblAMKCGP fields are: overnigh, dayshift, eveningshift
There is a third table name tblrptPharmacy
In tblrptPharmacy field is: generatedOrders
I want to total tblAMKCC71 and tblAMKCGP fields together and put in tblrptPharmacy field name generatedOrders.
How do i go about doing this.
I know to create a query but i know how to sum single field but not the multiple fields of different table.
I am very beginner programmer in access. Help greatly appreciated.