st3ady
04-18-2007, 02:52 PM
Ok I have a query setup in MS Access, and when you double click it, it pops up a "Enter Parameter Value" Window for the variable of EndDate. I fill in a date and wallah, the data comes up.
Now I am making a webpage to show this data. I want to show the contents of this data by simply doing a select * SQL statement. How do I pass the value of EndDate through?
I tried testing out
SELECT *
FROM Sum10andAll WHERE EndDate = #04/17/07#;
But this did not work. What is the correct way? :confused: Or is this not possible? Thanks :)
Now I am making a webpage to show this data. I want to show the contents of this data by simply doing a select * SQL statement. How do I pass the value of EndDate through?
I tried testing out
SELECT *
FROM Sum10andAll WHERE EndDate = #04/17/07#;
But this did not work. What is the correct way? :confused: Or is this not possible? Thanks :)