Calculations in Access

[William E]

Hi
Since this is my first attempt at creating a database and I must admit I am needing a wee bit of help with doing a calculation

I have created a database and need to create a Query I think, to calculate the number of places available the maximum places in each group would be 20 and obviously a count of the people going onto each group would be subtracted from the Max places available this would then need to update the available places . I just cant think how to do this any idea would be a great help.

 

[burrcm]

Query or text box on a form. Field "Places_Taken". Calculation as the control source of a text box called say Places_Available = 20 - Places_Taken or as a column in a query Places_Available:20 - Places_Taken. Of course NEVER store the results of a calculation in a table, as a change to one value may render the calculation invalid, rather recalculate as required.

Chris B

 

[William E]

thanks I will give that a try I think it makes sense.
William