Help with Dlookup Function matching two criteria from table to query

[trinisteve]

Hello. I am a beginner to access. I am writing a query where I want to match two fields in the query to two fields in table (tblJobBudgetedHours) and return a different field from the table to the query. Table1 fields are JobBudgetedHoursID, JobNumber, DirectLabourCode, BudgetedHours. The query fields are JobNumber, DirectLabourCodes, DirectLabourHours (Sum), BudgetedHours. The direct labour codes have different descriptions like templating, fabricating, installing. I want to match the JobNumber & DirectLabourCodes in the query to JobNumber & DirectLabourCode in the table and return the BudgetedHours from the table to the BudgetedHours in the query. I have attempted the Dlookup function but I can't get the criteria right. I have come up with BudgetedHours: Dlookup("BudgetedHours, "tblJobBudgetedHours", XXXXXX). Can someone please assist with the criteria?

[June7]

Why don't you do a query that joins tables on the two fields in common?

[trinisteve]

Thanks. I could try to restructure the tables but is it possible to write a query for the existing situation.

[June7]

My suggestion is for the current structure.

What is the SQL of the query that you want to match to table? What table is this query based on? I wonder why you can't do this 'match' in the existing query.

[trinisteve]

Thanks, I will restructure the tables