Entering criteria into a Crosstab query

  • Thread starter Thread starter Andy Allan
  • Start date Start date
A

Andy Allan

Guest
I started out with a Select query and converted it into a Crosstab query. Unfortunately the criteria now have to be hardcoded because the crosstab query does not appear to accept user input criteria eg: [Please input account number]. It brings back a SQL jet engine error, whereas with a select query it brings up a pop up input screen which enables the user to enter criteria when they run a query. How can I enable the criteria to be input when a cross tab query is run ?
 

Users who are viewing this thread

Back
Top Bottom