Edit Existing Query Parameters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Using Excel97 in MS Office97.
I have created an Excel query to extract data from an Access db. I now want to change the parameters but the Edit button is greyed out. If I re-run the query the button is available but I can't get to the screen which shows the fields with the criteria.
Help is appreciated.
 
If you run the query again, when you get to the last step of the Query
wizard, choose 'View data or edit query in MS Query', and click Finish

The criteria fields should appear in the centre of the Query window. If
not, choose view criteria.
 
Back
Top