Results 1 to 9 of 9
  1. #1
    alexc333 is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2011
    Posts
    38

    Very simple problem

    Hi,



    I simply don't know what I'm doing, please help.

    I have a database with a number of magazines. All of the mag entries have for example, name, address, email etc. However, I need the database to tell me all of the magazines that deal with for example cancer. The cancer option on the database is just a tick box.

    So what I need from the database is all 'cancer' magazine but with all other information as well i.e address.

    However, if I add address I get all fields with address. How do i stop this?

    Regards,

    Alex

  2. #2
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    In a query, make sure to add the field that has the checkbox to your grid. In the criteria for the checkbox field, type True.

    This will give you only those records which have the check box ticked.

    Alan

  3. #3
    alexc333 is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2011
    Posts
    38
    Wow, alan that is just amazing!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

    Thank you so much

  4. #4
    alexc333 is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2011
    Posts
    38
    Alan could I also ask you another question?

    If I want all mags with cancer or nursing, how would I go about this?


    Regards,

    Alex

  5. #5
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    How do you identify Magazines with Nursing in your table. Same way with a check box? If yes, then set up your QBE with both fields. In the criteria for Cancer, type true. In the criteria for nursing in one line below the true statement for cancer type true for the nursing field. They should not be on the same line as that would create an "and" criteria and not an "or" criteria.

    Alan

  6. #6
    alexc333 is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2011
    Posts
    38
    Yes, check box as well.

  7. #7
    alexc333 is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2011
    Posts
    38
    Hi Alan are you there? Anyone able to have a go at the second part of my question?

    Sorry to be impatient but I have a deadline

  8. #8
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    Reread my response in thread number 5.

    Alan

  9. #9
    alexc333 is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2011
    Posts
    38
    Alan oops so sorry. I really don't know how I didn't see that, I must have been distracted while reading it.

    I appreciate your help so much, you are very kind and knowledgeable. Will mark as resolved

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

Similar Threads

  1. Replies: 3
    Last Post: 07-18-2011, 08:03 AM
  2. Simple Problem with Validations
    By oleBucky in forum Forms
    Replies: 11
    Last Post: 04-12-2011, 05:39 PM
  3. Simple Export Not So Simple
    By jgelpi16 in forum Programming
    Replies: 11
    Last Post: 09-01-2010, 07:23 AM
  4. Simple query problem
    By rajnag in forum Access
    Replies: 4
    Last Post: 08-19-2010, 05:09 AM
  5. simple form problem
    By kcsun in forum Forms
    Replies: 0
    Last Post: 08-12-2010, 12:28 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