troubleshooting Question

FrontPage 2003 / Access '97 Query to show all records in a month from hyperlink

Avatar of dougsouders1
dougsouders1 asked on
DatabasesASPWeb Development Software
15 Comments1 Solution566 ViewsLast Modified:
I have two pages: Page 1 shows the Year and Month with a count of sales. I have the Year and Month as a hyperlink to another page that should show the specific month and year selected from the prior page and therefore show all sales for that month.

For my life I can't get the page to display the month range selected. I can hardcode any year and month into the query and it works- so I know the problem is in passing or transferring the parameter from the prior page into the query.

Here is the query:

SELECT *
FROM orders
WHERE Year([OrderDate])=#::Year::# and  Month([OrderDate]) =#::Month::#

I have spent 15 - 20 hours on this and am at my wits end. Been doing FrontPage and Access for 10 years now but I am stumped.
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 15 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 15 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros