Recent content by Ginty

thanks it works, i understand it now. i was using 2 queries to work this out before now. :eek:

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...

noted. thanks again

your right it is. i have linked the function to a report now, thanks a lot for all your help. :)

yeah i could use that. i have coded this, Public Function getPercentageOfMales() Dim males As Integer Dim total As Integer Dim per As Integer males = DCount("[SEX]", "ALL DETAILS", "[SEX] = 'M'") total = DCount("[SEX]", "ALL DETAILS") per = males / total * 100 getPercentageOfMales =...

so int males = Dcount("[SEX]", "TBDETAILS", "[SEX] = 'M' ") would work out the number of males. Dcount("[SEX]", "TBDETAILS") this would calculate everyone. how would i work out the percentage from here? would this work? int percentageofmales = males / total * 100

No i haven't used that function before. i dont think the it would go over 750.

I want it for a graph so the data would be fine anywhere, in another field row within a query, or in a report. as long as it automatically updates when data is changed...

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

sorry for being such a pain, i created a module and added the code, it is working fine now.

Is it because i have not writen the vb function in my database? i dont have vb on this machine... would i need to install it? or is there another way of getting the information i require?

yeah i realised this when i used the code for working out date of births. That is what the rest of the code is for. i cant seem to get this time elapsed function to work. i entered this Elapsed Time: getTimeElapsed([START DATE]) and got an error saying "undefined function 'getTimeElapsed'...

I have got that working now... so by changing the setting i can work out days, months, seconds etc... LENGTH OF SERVICE: DateDiff("m",[START DATE],Date()) works out months but would i able to work out the years, months and days?

the field row in the table ? i tired to change the totals to expression in the query but i got the error "You tired to execute a query that doesn't include the specified expression 'LENGTH OF SERVICE' as part of an aggregate function" Have you got any example databases of this expression...

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...