ratio 1:10- catering service

[natalia]

hello,

I have a database which is based on a catering system.
Attached is a scrrenshot of the different tables I have which include the different fields.

I want to do a query that will state how many staff will be needed for each event, ie if there were 100 number of guests i will need 1 member of staff to 10 guests so therefore i would need 10 members of staff!

Thankyou!!

[NTC]

A query can have a 'calculated field'. Presuming one of the fields in guest quantity - then you would create a calculated field for the employee quantity. One needs also to get to know the IIF statement in order to make a more flexible/useable formula.

Designing a database requires everyone to have a textbook, easily found at Amazon or a big book store. Examples of these tasks will be shown.

[slave138]

In your query (which should include the No_of_Guests field from the Orders table) select an empty field and enter:

No_of_Staff: -Int(-[Orders].[No_of_Guests]/10)