I have a database which has a number of functions but i have been asked to add a function to show how many desks are in each room and more particularly which desks are unoccupied. I have a spreadsheet showing me the number of desks per room but i am unsure how to display the unoccupied desk count in a form. i would imagine i need to add a field to my desk table(say a checkbox to indicate if allocated or not), but if i use a checkbox i am unsure of the code to display on a form this information. Any help greatly appreciated