Crosstab query

G

Guest

Hello all,

I have an issue with a crosstab query. I have a table that I need a count
performed on, but for only certain groups. I built a query that references a
list box control (lst_user_level) to set criteria to limit the workgroup.

I read from a previous post that all data should be first sent to a select
query where the criteria is selected, and then build the crosstab from that
source. It did not work. For some reason it is still referencing the form
control on the crosstab.

I have my form open that has the selection I need, and the query that feeds
the crosstab works perfectly. PLEASE HELP!

thank you for any and all suggestions.
 
G

Guest

It all flows through as it constructs one big SQL statement.
Open the crosstab query in design view, click on menu QUERY - Parameters.
This opens another window. Enter the reference to the listbox and TEXT 255.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is it possible to get Access to ignore not recognizing a field nameusing some sort of error handling 1
Form based on crosstab query 1
problem with crosstab query 1
Create table from a crosstab query 2
Crosstab Query Input Failure 2
Crosstab Query - Additional Data 1
Parameter question for crosstab queries 1
Loosing fields when creating a crosstab from a table 1

Top