Count what is in a field

[Ruegen]

I have a continuous sub form on a main form - each record has a field that has seating number.



Is there a way to tally/count and then minus that tally from the number on the main form

so if the mainform has 250 seats

it counts the field from each record in the subform field seats and then subtracts it from the 250 on the mainform.

[Ruegen]

Also in the subform query I have made a field which calculates 2 different fields for seatings (teachers and students).

I'm thinking that I could have that tallied to a total for all the rows - so row 1 seats + row 2 seats

[Ruegen]

guessing dcount will do this...

[Ruegen]

any ideas? (bump)

[June7]

Why does main form have count of seats?

[Ruegen]

Why does main form have count of seats?

Each theatre has a set number of seats for the day of the booking. Each school I have join the same booking has to declare how many seats they want on the day. If 3 schools join with 30 seats each I have to minus the total (90 seats) from the theatre seats (which could be anything... say 120 seats).

The main form just displays how many seats are remaining 120 - 90

But I need to tally each total of all the schools of that booking first to be able to display how many seats are remaining.

[Ruegen]

Each theatre has a set number of seats for the day of the booking. Each school I have join the same booking has to declare how many seats they want on the day. If 3 schools join with 30 seats each I have to minus the total (90 seats) from the theatre seats (which could be anything... say 120 seats).

The main form just displays how many seats are remaining 120 - 90

But I need to tally each total of all the schools of that booking first to be able to display how many seats are remaining.

I've put =Count([CalcField])) in the header of the subform and that seems to do the job. Only I am hoping that is restricted to just that subform query and not the whole table...

[June7]

Yes, the Count() function only considers the form records, not the table. Domain Aggregate functions (DCount, DSum, DLookup, etc) pull from table directly.

[Ruegen]

I have used Sum() as it ads the records and done that on the subform then made it invisible and then done another calc on the main form to minus from the seat number. Works.

Thanks to June7 too.