So far I haven't had the need for adding multiple fields together from various tables but the time has come and I'm not getting the answer required.
Here's the example:
alHours] & [Leave]![TotalHours] & [ShiftHours]![TotalHours] where the Timecard ID is the lookup for the tables Allow, Leave and ShiftHours
I beleive I need to put the expression in the Row Source of [TimeCard]![TotalHours] so the field will auto sum when a TimecardID is entered.
These tables are part of a timecard import process that will eventually turn into an XML import. I have attached the XML output in case I am going about this the wrong way.
Your help would be greatly appreciated...