Results 1 to 2 of 2
  1. #1
    Rich P is offline Novice
    Windows XP Access 2003
    Join Date
    Feb 2011
    Posts
    6

    Red face crosstab queries (criteria) won't work

    Why doesn't the criteria work in crosstab queries, like select queries. If I put in [enter date] I receive an error "The Microsoft Jet Database engine does not recognize [enter date] as a valid field name or expression.

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. crosstab query criteria
    By Sharron in forum Queries
    Replies: 3
    Last Post: 12-15-2011, 04:31 AM
  2. crosstab query (criteria)
    By Rich P in forum Queries
    Replies: 1
    Last Post: 02-14-2011, 08:40 PM
  3. Form's Criteria used in Crosstab
    By onechriswhite in forum Queries
    Replies: 8
    Last Post: 08-27-2010, 05:48 PM
  4. Crosstab Criteria or Parameters
    By lukewarmbeer in forum Access
    Replies: 3
    Last Post: 08-11-2010, 09:57 AM
  5. Crosstab Queries
    By albst130 in forum Queries
    Replies: 0
    Last Post: 03-07-2007, 09:32 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