Event Database - Calculate remaining seating

[Guest]

When I upgraded to Access 2003 the functionality of the "spaces remaining"
(#NAME? appears in the form box) for each event was lost and susequently the
calculation of the remaining seats in the for registration. How do I reset
this function or relationship so it will do the calculation?

 

[UpRider]

Quick to try, but type carefully:
=NZ([AvailableSpaces],0)-IIf([Events
Subform].Form.RecordsetClone.RecordCount=0,0,NZ([Events
Subform].Form![Total
Attendees],0))

UpRider

don't know how to debug. This is the formula that appears in the design
view
box

=[AvailableSpaces]-IIf([Events
Subform].Form.RecordsetClone.RecordCount=0,0,[Events Subform].Form![Total
Attendees])

Thanks

Hi Ginette

Are you using dates for the events - according to Mr Gates the whole
world
runs on american time so check the date format (18/08/2007 - 08/16/2007).

Do you have any field names with spaces - check the they are enlclosed.

Open the code and debug (on a copy of the database - just in case)

All worth a try