Results 1 to 3 of 3
  1. #1
    jruizmesa is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2012

    Retrieving records according to criteria

    Hi everyone, I am fairly new to access. I am busy creating a database for a class were the pupils have a choice of 7 different subjects from a lits of 12. I thought of using YES/NO fields for the subjects and then sort them out using queries. Now the problem is that I have to enter feedback comments for every pupil in every one of the selected 7 subject so I thought I could used a form to display the pupils that do one particular subject and then enter all the comments for this subject but I can't get a form to display the records as I wanted. Can anyone help please. Much appreciated.

  2. #2
    orange's Avatar
    orange is online now Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Ottawa, Ontario, Canada; West Palm Beach FL
    Have you looked at the problem in general terms and designed tables to support the issues involved?
    Getting the tables designed is usually a good first step.

  3. #3
    jruizmesa is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2012
    Hi orange, thank very much for your reply. After i posted the question that's exactly what i did. I redesigned my tables and decided to use queries instead to filter the subject. It was right in front of my eyes!! Thank you su much for your advice.

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

Similar Threads

  1. Replies: 7
    Last Post: 05-23-2012, 02:19 PM
  2. Query Criteria not returning any records
    By SgtSaunders69 in forum Access
    Replies: 2
    Last Post: 12-19-2011, 07:45 PM
  3. Exclude records within same criteria
    By brooke48 in forum Queries
    Replies: 14
    Last Post: 05-15-2010, 02:15 PM
  4. Replies: 2
    Last Post: 03-31-2009, 11:15 AM
  5. Counting records based on specified criteria
    By GrnISSO in forum Queries
    Replies: 2
    Last Post: 10-04-2007, 03:07 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