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:
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.