Geoff,
Use an Access form as the user interface to enter the variables, not an Excel spreadsheet. The query then can reference the fields on the form, like
WHERE Readings.Palace=Forms!Myform!f_palace and Readings.Star = Forms!Myform!f_star
This is much easier (seen from the Access side at least) then peeking around in a spreadsheet with OLE. I think it should become something like
WHERE Reading.Palace = LookInExcel("My spreadsheet","My worksheet","A7") where you have to write the function LookInExcel.
The whole setup, using three MS Office programs, seems rather complicated. You might like to tell why you think it's needed or optimal.
Kees
Hi, I am trying to retrieve data from an access 2003 database into a Word 2003 document based on the value in a cell in an Excel spreadsheet.
The following SQL statement retrieves the text in the 'Reading' field of my chinese horoscope Readings database but I want the values of 'Reading.Palace', 'Reading.Star' and 'Reading.OtherStars' to equal text in cells in an Excel 2003 spreadsheet rather than manually typed in. The values of the Excel cells are text and they change based on an individuals date of birth.
SELECT DISTINCT Readings.Reading
FROM Readings Readings
WHERE (Readings.Palace='Brothers & Sisters') AND (Readings.Star='Chi Sha') AND (Readings.OtherStars='Any')
Any ideas? all help gratefully received. Geoff.

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic