I think you need to rethink your table design. It will make things much, much easier when it comes to getting the data that you want. From what I saw, let me see if my assumptions are correct.
You are trying to track the expenses of an Employee. These expenses are generated per trip. Each trip has the following: StartDate, EndDate, MilesTravelled, OtHours, HourlyRate. Each trip can have one or more modes of travel that have a cost associated with it. Air Travel or Vehicle Travel. Based off of that, I would have the following tables:
tblEmployee
EmployeeID (Primary Key)
TeamCodeID (Foreign Key - Links to Team Data)
EmployeeName
Other Employee Data
tblTripDetails
TripID (Primary Key)
StartDate
EndDate
OtHours
tblTripParticipants
TripParticipantID (Primary Key)
TripID (Foreign Key)
EmployeeID (Foreign Key)
(This table allows it so multiple employees can be assigned to the same trip)
tblTravelDetails
TravelDetailID (Primary Key)
TripID (Foreign Key)
TravelMode (Air or Ground)
DistanceTravelled
TravelCost (Airfare Cost or Vehicle Rental)
tblExpenseDetail
ExpenseDetailID (Primary Key)
TripID (Foreign Key)
ExpenseDesc (Description of Expense - Meals, Entertainment, etc)
ExpenseCost (Cost of Expense)
Having the tables setup this way, it would be a snap to setup forms to enter data based on Employee and Trip info. Generating Expense reports would also be a snap to design.
as for this question:
How do I take two queries (QRY_Incentive Bouns Pay) and (QRY_Expense tracking) combind into one query to show only the expense. will need to to see on line for each person per travel team.
I dont see any field in the Incentive table that relates to an expense. What field are you trying to include as an expense?