Using Access 2000:
I have created a pivot table based on a pretty basic select query. However, I need to filter the query by certain dates. Now, if I hardcode the dates into the query, for example, 'Between 01/01/2004 and 01/01/2005' then the pivot will run fine. However, if, as I would like, I place a parameter in the query - 'Between [Enter beginning date] and [Enter end date] - then the pivot table will not open and cannot obtain the data?
Any ideas how to resolve this?
Help, as always, is much appreciated.
Thanks,
Adrian
I have created a pivot table based on a pretty basic select query. However, I need to filter the query by certain dates. Now, if I hardcode the dates into the query, for example, 'Between 01/01/2004 and 01/01/2005' then the pivot will run fine. However, if, as I would like, I place a parameter in the query - 'Between [Enter beginning date] and [Enter end date] - then the pivot table will not open and cannot obtain the data?
Any ideas how to resolve this?
Help, as always, is much appreciated.
Thanks,
Adrian