Percentages

AuroX7

Registered User.
Local time
Today, 10:10
Joined
Feb 22, 2006
Messages
44
Simple question: how do you convert vlaues into percentages?
I have a boolean expression so when it's ticked the bookings are regular, and if they're false they are occasional bookings. I have used 10 bookings as test data (5 regular - true, 5 occasional - false). How would I convert these into percentages? For example, I've used the "Count" total to fint the number of regular and occasional booknigs, which are both 5. This is 50%, but how would I do that? Thanks for your help guys. :)
 
You can use the DCount() function to get the total number of records from the table for percentage calculations.

See query in attachment.
.
 

Attachments

Undefined fucntion

Undefined function 'Format' in expression - huh?
 

Users who are viewing this thread

Back
Top Bottom