create an monthly entry based on weekly results

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

is there a way to create a monthly "yes / No" entry based on comparing 4
weekly entries.

Example (weekly entry table)
employee # Date Entry
0001 10/1 Yes
0001 10/8 Yes
0001 10/15 Yes
0001 10/22 Yes

(Monthy Entry table)
employee # Month Entry
0001 October Yes (yes is based on >= four weekly entries is
=yes)

can this be done?

Any help would be greatly appreciated
 
well, probably i wouldn't do it at all. storing calculated values is a
violation of normalization rules. you have the raw data (weekly records), so
just calculate the monthly findings at runtime as needed for forms and/or
reports.

hth
 
Back
Top