Search results

  1. G

    Dcount query

    i want to calculate the number of males that are currently working at my company. i am currently using this code to work out the percentage of males. Public Function getPercentageOfMales() Dim males As Integer Dim totalem As Integer Dim per As Integer males = DCount("[SEX]", "ALL...
  2. G

    Percentage Of Males And Females

    how would i work out the percentage of males and females in my database? i have done three queries.. one to count everyone, one to count males and one to count females. is there an expression that could calculate this? something like [Query:Count Males]/[QUERY:TOTALCOUNT]*100
  3. G

    calculating years employees have worked for

    hi, i want to calculate how long each person has worked at a company. i am using access 97. would i be able to enter something in the criteria that would work this out for me? something like year([START DATE]) - year(Now()) this does not work but i want to find out the number of years a...
Back
Top Bottom