Help Please, it's about Access

Results 1 to 4 of 4

Thread: Help Please, it's about Access

  1. #1
    Jason Guest

    Default Help Please, it's about Access

    I&#039ve never had such a hard time finding something that is probably very simple, but I have records in my access report grouped. And I have a column that I need to do a countif, but countif doesn&#039t work in access. So lets just say i have a column named gender, and I want to count all records if gender=male. What do you type in the text box to do that? <BR>Thanks in advance<BR>Jason

  2. #2
    BeBe Guest

    Default RE: Help Please, it's about Access

    Textbox?<BR><BR>Not sure about that, but a possible query might be:<BR><BR> select count(*) from table where gender=&#039male&#039

  3. #3
    Jason Guest

    Default RE: Help Please, it's about Access

    In MS access, when you do reports, you usually put the control in a text box or the code, they have a count function, but I can&#039t find a countif function, like in MS excel. It doesn&#039t seem to like that SQL code either. Thanks for the suggestion

  4. #4
    Jason Guest

    Default Solution if anybody ever runs into same problem

    TO do a count function in access it goes as follows<BR>=sum(IIf([gender]="male",1,0)) <BR><BR>(don&#039t you love how microsoft makes things so complicated, heaven forbid they made it compatible with excel functions, countif(gender,male)

Posting Permissions

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