Another unexpected parameter query

[Access_Novice]

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));

[June7]

I think you have to repeat the HoursPaid calculation in the WHERE clause.

[Micron]

I don't see where you're pulling in [PaidHours] from any source (such as qryUnanet) so I guess it's asking you for the alias instead of qryUnanet.PaidHours.