"dutty" wrote ...

I tried editing the sql to reflect this, and I receive the error:
"Parameters are not allowed in queries that can't be displayed graphically."

What has a LEFT JOIN got to do with parameters?!

Is there any other way to view a selected date range in this type of setup?

Yes. In the database, create a procedure which accepts parameters and
call the procedure from MS Query e.g. (a simpler query):

CREATE PROCEDURE
MyStoredProc (
start_date DATETIME,
end_date DATETIME
)
AS
SELECT
RefID,
DateEffective,
Earnings
FROM
EarningsHistory
WHERE
DateEffective
BETWEEN start_date AND end_date;

This can be called from MS Query using e.g.

EXEC MyStoredProc '01 JUL 2004', '31 JUL 2004'

Subject to permissions, you may even get away with running the CREATE
PROCEDURE from within MS Query!

Jamie.

--