TB20 Renewal Doc Update

2025/01/06 update

This TB20 task updates TB-renewal.docx with current membership counts for MAFCA-MARC

1. Start – Time-In, open files:
2. Determine-Update Member Counts For TB-renewal.docx:
3. Stop – Time-Out, close files:

1. Start – Time-In, open files:

open treasury.xlsx > in name-hours > enter Date > Task = TB20 > Time-In

open D:\fmaatc\MAFCA-MARC\TB-renewal.docx

open membership.accbd > open Report window

2. Determine-Update Member Counts For TB-renewal.docx:

> enter Expire-Year parameter yyyy as current fiscal-yyyy-1

> double click Members query button
> in query window use record bar total to update TB-renewal.docx “total members”
> close query (Report Window shows)

> double click MAFCA-Members query button
> in query window use record bar total to update TB-renewal.docx “MAFCA club members”
> close query (Report Window shows)

> double click MARC-Members query button
> in query window use record bar total to update TB-renewal.docx “MARC club members”
> close query (Report Window shows)

3. Stop – Time-Out, close files:

at treasury.xlsx> in name-hours > enter Time-Out > save > close
> close TB-renewal.docx > close other windows as needed.

☕ 🙂


To Office Page Links