sums

[agorman]

Hi,

I have a sum to show the total number of people who are attending a banquet on a summary report which works great - tells me for example that 170 people have booked to attend the dinner.

" & (Count([ID])+(Sum([SatBanquetGUESTS])))


However, the banquet has a maximum seating capacity of 720 persons.

Is there a formula I can use to subtract the total number of persons generated by the sum above, from 720 so that I can see at a glance, the number of places left to sell?

I have played about with it but cannot get a correct formula.

I would be grateful for any help

Thanks

Adrian

 

[KenHigg]

(720 - Count([ID])+(Sum([SatBanquetGUESTS])))

???

 

[agorman]

Thanks KenHigg,

I tried that and it doesn't seem to work.

I have used

=(Count([ID])+(Sum([SatBanquetGUESTS])))-720 which works fine - but do you know how to stop the minus sign (in front of the 720) from being visable ?

Thanks again

 

[KenHigg]

=abs((Count([ID])+(Sum([SatBanquetGUESTS])))-720)

???

 

[agorman]

That works perfectly - Thanks Ken

 

[KenHigg]

Glad to help -

 

[MSAccessRookie]

(720 - Count([ID])+(Sum([SatBanquetGUESTS])))

???

I think this needs to be

(720 - (Count([ID])+(Sum([SatBanquetGUESTS]))))
OR
(720 - Count([ID]) - (Sum([SatBanquetGUESTS])))

to account for the associative rules that determine the order of mathematical processing on a computer

 

[KenHigg]

I was going to look at that myself and try to see what is should be... Using asb() should have been the last resort huh? - Thanks Rookie.

 

[MSAccessRookie]

The pleasure was mine. I may still be an Access Rookie, but I have been using SQL for many years, and I have discovered that mismatched parenthesis are a very common cause of data errors.