Hello,

I have imported external data from an Access database by creating a query.
When creating the query I put in filters for the dates in order to be able to
only look at postings made for example in January 2006. This is the filter I
created:

Column to filter: 'Date'
Only include rows whe
1) Date is greater than or equal to 2006-01-01
2) Date is less than or equal to 2006-01-31

No problems occur at this stage, however should I want to edit the month to
February I right click in the gathered information and select 'Edit query'.
This generates an error message from Microsoft Query informing me that 'This
query cannot be edited by the Query Wizard'. After that I get transferred
into Microsoft Query where I can manually edit the dates in the filter.

Because this report is meant for users with less experience wth Excel it
would be great if the query can be edited in the wizard instead and
apparently the filter can be created in there but not edited??? Is there any
way of constructing this so the filters can be changed in the wizard?

For your information, if I only use one of the two filters desribed above I
can edit it in the wizard but if I use them both I get the error message.