Formula Help

[gregtank]

i have a list of check boxes which state whether a ticket has been sold or not. what formula can i use to find the percentage of tickets that have been sold (by counting the number of checked boxes). also how can i implement that onto a report to display it next to a pie chart of the information. if it cannot be put on a report how can i put it onto a form?

thanks in advance

 

[ColinEssex]

If you click on Forms >>>>New. There's a chart wizard that does this for you.

Col

 

[gregtank]

thanks very much.
out of interest where is it that you can find formulas, as ive used formulas alot on excel before but never in access

 

[gregtank]

where are formulas created? other than sum, min, max, average

 

[ColinEssex]

Formulae are usually mathmatical. Not necessarily Access orientated. Working out percentages for example is the same as we were taught at school.

There are however in Access, built in functions that can do many things for you. It basically depends on what you want to do as to the most apropriate method.

It comes back to the same answer, do a search on these forums and you'll generally find something that will guide you.

Col

 

[gregtank]

i just need to use a formula in my database other than sum, min, max, average. could anyone give me an exmaple of a formula which could be used