Access Corss-Tab Quey Error

 I am trying to design a Cross-Tab query with a dynamic field populated by users but no matter waht I try I always get that microfsoft jet database does not recognize the field.  I also tried to do the dynamic selection in another query and then call the new query intead of the table (2 SF committee) but I still got the same error.  Please find the query structure and the error in the screnshot attached.
Query-Error.bmp
fitalianoAsked:
Who is Participating?
 
peter57rCommented:
If your parameters are datetime then you must define them in the Query>Parameters dialog as datetime.
0
 
mbizupCommented:
Your syntax for the control references looks okay.

Make sure thet the actual form and control names are correct, and that the form you are referring to is open at the time you run the query.
0
 
fitalianoAuthor Commented:
Hi Mbizup, yes the query works fine if I change it into a select query...
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
Helen FeddemaCommented:
Do you mean that the field name is created by the users, or just the data in the field?  Can you post the database so we can look at it?
0
 
fitalianoAuthor Commented:
Unfortunately I cannot post the DB.  What I meant is that users select a reference value from a drop down in a form and those value are used in the query.
0
 
peter57rCommented:
So have you defined the parameters as I said in my first reply?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.