Results 1 to 2 of 2
  1. #1
    switters is offline Novice
    Windows XP Access 2007
    Join Date
    Apr 2011
    Posts
    1

    querying Multi-valued fields


    Hi everyone,

    I have a simple database but some of the fields are multi-valued and I need some help creating queries that will return the number of records in the database where >=n, (where n is an integer) check boxes in the combo box have been checked. Probably a piece of cake for someone in the know. Would appreciate any help.

    Thanks

  2. #2
    orange's Avatar
    orange is online now Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,726
    I have acc2003 so I don't have multivalued fields.
    Have you seen this link
    http://office.microsoft.com/en-us/ac...010149297.aspx

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

Similar Threads

  1. Querying Multi Line Text Box in MS Access Forms
    By spindlebeakin10 in forum Queries
    Replies: 5
    Last Post: 12-09-2010, 05:50 PM
  2. Querying a Subform
    By jonillson in forum Forms
    Replies: 9
    Last Post: 11-19-2010, 12:04 PM
  3. Append Query - Multi-Valued Field
    By catat in forum Queries
    Replies: 0
    Last Post: 05-11-2010, 01:52 PM
  4. Multiple valued field locking tables
    By Jamy in forum Programming
    Replies: 6
    Last Post: 02-19-2010, 11:24 AM
  5. Help Querying series
    By ktmchugh in forum Queries
    Replies: 20
    Last Post: 05-05-2009, 04:31 PM

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