I'm using MS Excel to display the results of a SQL Server database,
using the GET EXTERNAL DATA wizard, which then takes you to Microsoft
Query so you can set up the SQL coding.

I was having difficulty writing the SQL using MS Query, so I set up the
same scenario in MS Access to write a query, then just pasted the query
into MS Query. Unfortunately the code does not work and I get a
"Invalid column name What is the start date" error

What I'm actually trying to do is get two input boxes to appear each
time the spreadsheet is opened. The user types the FROM and TO dates
into these boxes and all values between those dates are displayed.


Here is the code I pasted from Access to MS Query anyway........

SELECT CallLogRevenues.category, CallLogRevenues.enquiryDescription,
CallLogRevenues.resolution, CallLogRevenues.startDateTime,
CallLogRevenues.endDateTime, CallLogRevenues.totalDateDiff
FROM CallLogRevenues
WHERE (((CallLogRevenues.startDateTime)=[What is the start date?]) AND
((CallLogRevenues.endDateTime)=[What is the end date?]));

So does anyone know how to display the input boxes using MS Query.

Thanks for any help

Dave


--
David494
------------------------------------------------------------------------
David494's Profile: http://www.excelforum.com/member.php...o&userid=24482
View this thread: http://www.excelforum.com/showthread...hreadid=380880