Hi!
I am not sure if this goes here or not so please tell me if it doesn't. I need to make a query run automatically to mark classes full as people register for them. My though was to just make a form that refreshes and executes the query but the query always asks for OK, etc. Any suggestions on how I could accomplish this? The SQL view of the query is below.
UPDATE (qryqrybaseforanalysis LEFT JOIN Classes ON qryqrybaseforanalysis.BadgeID = Classes.BadgeID) LEFT JOIN CampSessions ON qryqrybaseforanalysis.SessionID = CampSessions.SessionID SET Classes.[Full] = 1
WHERE (((Classes.Full)<>1) AND (([maxscouts]-[ScoutsRegistered])<=([maxscouts]*0.2)));
Thanks in advance!
Joe