Results 1 to 2 of 2
  1. #1
    wasim_sono is offline Advanced Beginner
    Windows XP Access 2013 64bit
    Join Date
    May 2005

    Criteria in Crosstab Query

    Dear All

    I've design a report based on a crosstab query.There are 3 fields using as column and row heading.
    Another field 'Billing Month' which is not a part of colum or row. As I entered the fixed value in criteria colum then the query works well but when I used value as [enter the billing month] or [forms].[summaryform].[combo0] the query doesn't works. It display the message " Microsoft Data jet database engine doesn't recognize'[...]' as field name or expression.

    I want to display particular data not all. For this purpose how can I use the criteria?



  2. #2
    Join Date
    Jun 2005
    Northampton, England
    What criteria are you using, a parameter OR a form criteria?. You can't use both. It's either a parameter formatted to take the month OR criteria from a form.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Query Criteria
    By Texaine in forum Queries
    Replies: 1
    Last Post: 01-24-2018, 02:36 PM
  2. crosstab query criteria
    By Sharron in forum Queries
    Replies: 3
    Last Post: 12-15-2011, 04:31 AM
  3. Query Criteria
    By jena in forum Access
    Replies: 1
    Last Post: 08-03-2008, 04:08 AM
  4. Query Criteria
    By jena in forum Queries
    Replies: 1
    Last Post: 04-29-2008, 11:00 AM
  5. Replies: 2
    Last Post: 11-09-2005, 02:51 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Other Forums: Microsoft Office Forums