Percentages help :)

[lydz]

hey there i need help

ok, so i have to work out week by week percentage uses
i have a query that already finds the bookings in the week already, that works fine, but then i need to find the % use for that week, which is the count of the number of bookings in the week / 21
ive tried doing this in an update query, but it doesnt like me
any help would be great
i have a % use field in my table that it updates to, but im flexible
thanks

 

[namliam]

hey there i need help

ok, so i have to work out week by week percentage uses
i have a query that already finds the bookings in the week already, that works fine, but then i need to find the % use for that week, which is the count of the number of bookings in the week / 21
ive tried doing this in an update query, but it doesnt like me
any help would be great

Try using a "group by" query.

i have a % use field in my table that it updates to, but im flexible
thanks

You shouldnt store calculated values in a table, thats what queries are for.

Greetz

P.S. I dont have a smiley % calculator, but I bet it is High...