I'm using Access 2002 to read data from SQL Server. I
have a basic query that works fine:
SELECT Count(*) From Orders WHERE SALE_DATE='6/20/2004'

Now I need the user to be able to change the date, but
cannot get the query to read a cell vaule. I think it
should work something like:

SELECT Count(*) From ORders WHERE SALE_DATE='Sheet1'!B5

Does anyone have an example of how this should be done?

THANK YOU