Specify which record set

[trackmedic]

I have placed the following criteria in a query field

(([Total Worked]+[Total Rest])/24)

this query mixes two tables. in both tables, I have the "Total Worked" fields. How do I write the above criterial pulling "total Worked" from table two and not from table one?

Thanks in advance.

 

[boblarson]

I have placed the following criteria in a query field

(([Total Worked]+[Total Rest])/24)

this query mixes two tables. in both tables, I have the "Total Worked" fields. How do I write the above criterial pulling "total Worked" from table two and not from table one?

Thanks in advance.

[Table1].[Total Worked]...etc.