Subquery?

[Doreen]

I need to get the value from another table if the field in
the current is null.

What would be the most efficient or easiest way to do this?

tblsched.payrate = null get payrate from tblrate.payrate

any help would be most appreciated

 

[Gerald Stanley]

Something along the lines of
SELECT Nz(tblsched.payrate, tblrate.payrate)
FROM etc

Hope This Helps
Gerald Stanley MCSD