I am posting a new thread because this is a new problem, but the end result is the same as my previous thread. Notice the filter in the WHERE clause where I have require that two calculated fields <>0. With this filter in place, I am prompted to enter a value for HoursPaid, a calculated field.
But if I remove this filter my query runs fine.
SELECT qryUnanet.[Person Employee Type Name], qryUnanet.[Person Company], qryUnanet.[Person Exostar Billing Account No], qryUnanet.[Person First Name], qryUnanet.[Person Last Name], qryUnanet.[Timesheet Cell Task QB Project Name], qryUnanet.[Timesheet Cell Task QuickBooks Service Item], qryUnanet.[VIP No], qryUnanet.[Lockheed Week Ending], qryUnanet.UnanetHours, qryUnanet.[Person Billing Rate], qryUnanet.UnanetBillable, IIf(IsNull([PaidHours]),0,[PaidHours]) AS HoursPaid, qryLockheedPaid.[Exostar Billing Rate], IIf(IsNull([PaidAmount]),0,[PaidAmount]) AS AmountPaid, [UnanetHours]-[HoursPaid] AS HoursBalance, [UnanetBillable]-[AmountPaid] AS AmtBalance
FROM qryUnanet LEFT JOIN qryLockheedPaid ON (qryUnanet.[VIP No] = qryLockheedPaid.[VIP Charge]) AND (qryUnanet.[Lockheed Week Ending] = qryLockheedPaid.[Lockheed WE]) AND (qryUnanet.[Person Exostar Billing Account No] = qryLockheedPaid.[Billing Acct])
WHERE ((([UnanetHours]-[HoursPaid])<>0) AND (([UnanetBillable]-[AmountPaid])<>0));