I have inherited an Access database, I know very little about Access. The db was built to handle the data for one individual working an incident. Occasionally more then one person works an incident. The main form used to create a report (invoice) has an area that allows for a second individual to be added. When the report is run it calculates the fees (meals, travel, lodging) for one individual and his/her equipment fees, it also adds in the equipment fees for the second individual (which is correct) it does not add the fees (meals, travel, lodging) for the second individual. I have checked the tables to make sure all the data has been captured correctly, and it is.
After looking at the form closely I noticed that all the fields for the second (added) individual are all text boxes where as every thing else is a list box or combo box. All the list / combo boxes have Row Source and Row Source Type attributes. How can I give the text boxes Row Source and Row Source Type attributes? I think this will solve the issue.
THANKS IN ADVANCE!!!

The short version is you can't. I'm having trouble visualizing the data, but can you change the text boxes to combo or list boxes to achieve your goal?

I have uploaded 2 images that show the form and the report.
I circled the area of the main form where a second individual responding to an incident can be added. The report has circled "Total Assist Cost" and the formula, the fees section (meals, lodging, OT hours, etc) and "Supply/Equip Item Used" ( =[Charge]). The issue that has been discovered is that is a second person is added on the main form his/her fees (lodging, etc) appears on the report but is not calculated in the "Total Assist Cost".

Correct Example:

Joe Person
Lodging $100
Miles $50
Supply
camera $25
computer $25

Jack Person
Lodging $100
Miles $50
Supply
Camera $25
computer $25

Total Assist Cost: $400

What the report is doing:

Joe Person
Lodging $100
Miles $50
Supply
camera $25
computer $25

Jack Person
Lodging $100
Miles $50
Supply
Camera $25
computer $25

Total Assist Cost: $250

It does not include Joe's lodging and Miles, but does calculates Joe's camera and computer in the Total.

P.S

pbaldy,

Thank you very much for your quick response to my first post!!

Offhand it looks like the formula with the 2 Sum()'s in it should work. I don't suppose you can post the db itself, can you? We obviously don't want any private info posted.