+ Reply to Thread
Results 1 to 2 of 2

Im in trouble!!! Please Help!! JS

  1. #1
    JimmyS
    Guest

    Im in trouble!!! Please Help!! JS

    Hello,

    Ive bitten off a bit more than I can chew and said I would do a database for
    my mum but have become stuck. Here is problem in a nut shell. its a data base
    of employees but need a multi-criteria query but can't work out how to:

    Set criteria so when seraching for gender, you can not only do male or
    female but also search for both. Any ideas???

    Also how do I set criteria for tick boxes?? What to serach for all people
    who ticked/didn't tick the box.


    Thanks so much for your help. I will be forever in your debt!!!

  2. #2
    Ragdyer
    Guest

    Re: Im in trouble!!! Please Help!! JS

    If I understand what you're asking, say gender is in Column D, denoted by a
    "F" and a "M".
    Gender search criteria is entered in E1 - either M or F or MF or FM.
    *No Quotes* should be used in either the gender column (D1:D100) or the
    criteria cell (E1).

    =LEFT(E1)&" Count = "&COUNTIF(D1:D100,LEFT(E1))&IF(LEN(E1)=2," &
    "&RIGHT(E1)&" Count = "&COUNTIF(D1:D100,RIGHT(E1)),"")

    As to your second question, how are these "ticks" being entered?
    What form are they in?

    --
    HTH,

    RD

    ---------------------------------------------------------------------------
    Please keep all correspondence within the NewsGroup, so all may benefit !
    ---------------------------------------------------------------------------

    "JimmyS" <JimmyS@discussions.microsoft.com> wrote in message
    news:F18B84F8-96FC-4AC1-B63B-1D0E5B7A971D@microsoft.com...
    > Hello,
    >
    > Ive bitten off a bit more than I can chew and said I would do a database

    for
    > my mum but have become stuck. Here is problem in a nut shell. its a data

    base
    > of employees but need a multi-criteria query but can't work out how to:
    >
    > Set criteria so when seraching for gender, you can not only do male or
    > female but also search for both. Any ideas???
    >
    > Also how do I set criteria for tick boxes?? What to serach for all people
    > who ticked/didn't tick the box.
    >
    >
    > Thanks so much for your help. I will be forever in your debt!!!



+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1