I have an Access DB that I am trying to query from Excel. What I want to do is have 3 parameters. Parameters A and B are dates, and parameter C is a simple code (1,2, or 3.)
The query returns records that are Later than date A and Earlier than Date B. I want these Dates to be input into an Excel cell and then used when the query is executed, rather than getting the silly little prompts. How can I achieve this?
The query returns records that are Later than date A and Earlier than Date B. I want these Dates to be input into an Excel cell and then used when the query is executed, rather than getting the silly little prompts. How can I achieve this?