Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2008
    Posts
    4

    crosstab query criteria


    I have created a crosstab query and wish to be able to limit it so that only one staff member is shown. I dont mind the criteria being [enter staff member] or any other way. But just need to be able to use some kind of criteria to do this as the staff member changes. Any ideas?

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

    Unhappy crosstab query (criteria)

    I'm having an issue with the criteria. When I try to insert [Enter Date]
    into one of my field's, it gives me the error (The Microsoft Jet Database engine does not recognize [Enter Date] as a valid field name or expression. When I use a select query, I have no problem.

  3. #3
    westmedtim is offline Novice
    Windows XP Access 2007
    Join Date
    Dec 2011
    Posts
    1

    Likewise

    I am experiencing the same issue.....

  4. #4
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,513
    Post your SQL statement and explain what is happening, ie. what results you are getting. What results you were expecting. Provide us with details. Your posting is too vague for an answer.

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. Query Criteria
    By jena in forum Access
    Replies: 1
    Last Post: 08-03-2008, 04:08 AM
  3. Query Criteria
    By jena in forum Queries
    Replies: 1
    Last Post: 04-29-2008, 11:00 AM
  4. Criteria in Crosstab Query
    By wasim_sono in forum Queries
    Replies: 1
    Last Post: 12-12-2006, 05:14 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