I have a program in Access that handles reservations for our firm. I have a query/report that displays 3 fields (Tour Date, Tour Time, and Party Size). I want this query to display a field titled Available Seats. I want it to calculate the remaining seats from the field Party Size -40. 40 is the maximum seats allowed. It displays all of the info such as the date, time, and party size but it only returns from one Party Size entry. I may have up to 3 separate entries on one particular date at 10:00 AM. I want to be able to see all seats available so that if I want to fill a vacancy I'll know how many vacancies I have left. This will enable me to manage my seats more closely. I have tried several formula's but none work. Ex.; Available Seats: =Sum -40([Party Size]) If I have 25 seats filled on the first entry, then 3 on the next and 5 on the last, I'm only seeing 15. I'm not seeing the other entries. I should see a total of 7 seats remaining. I keep getting an error about amalgamated information on Tour Date or something along that line. Is there another formula that will capture that information?