Access Corss-Tab Quey Error

Posted on 2011-10-07
Last Modified: 2012-05-12
 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.
Question by:fitaliano
    LVL 77

    Accepted Solution

    If your parameters are datetime then you must define them in the Query>Parameters dialog as datetime.
    LVL 61

    Expert Comment

    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.

    Author Comment

    Hi Mbizup, yes the query works fine if I change it into a select query...
    LVL 31

    Expert Comment

    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?

    Author Comment

    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.
    LVL 77

    Expert Comment

    So have you defined the parameters as I said in my first reply?

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Join & Write a Comment

    Suggested Solutions

    Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
    Composite queries are used to retrieve the results from joining multiple queries after applying any filters. UNION, INTERSECT, MINUS, and UNION ALL are some of the operators used to get certain desired results.​
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now