I am trying ot pull information from Access into Excel using the query function. The query to pull the information from the Access database is the basis of the Excel query. The Access query pulls data in columns based on calculation fields for the 13 weeks of the quarter. When launched the query askes for the beginning date of the quarter then calculates the remaining dates based on that entry. The Access query runs fine.
However, the Excel query based on the Access query has a problem. It will not run because it needs the date paramter entered.
Does anyone know of a way to enter the date parameter from Excel?
However, the Excel query based on the Access query has a problem. It will not run because it needs the date paramter entered.
Does anyone know of a way to enter the date parameter from Excel?
