Change field values after using an append query

[chellebell1689]

Hello,

I have a form that I use to track our Sunday School Attendance. I have it set up with two "temp" fields in my main table (Members), then use an append query to save all the data (date, class, name, present, & on roster) in another table (SSAttendance).

I'm wondering if there's a way to change my two "temp" fields back to blank? The fields are "classAttended" & "present" (y/n field). I would like to reset them so that the next time I record attendance, I don't have to worry about making sure I don't count people who were here last week, but not this week.

Thanks in advance for any and all help! And let me know if I need to provide more info. Also, I would prefer NOT to use code (since I'm still learning that), but if need be I will use it. Thanks!

 

[GohDiamond]

Use an Update Query on the two fields in the table and Set your UPDATE value to NULL for the "classAttended" and FALSE for "Present" if it's a Yes/No checkbox field.

Run the Update Query just before the next class.

This will accomplish what you've asked, but your description of your database structure raises some questions. As long as it works for you, I won't go there.

Cheers!
Goh

 

[chellebell1689]

Thank you so much!!