janerussel
MIS
I have a table for tracking transportation mode to work for each pay period. There are five modes 1=Transit, 2=carpool, 3=bicycle, 4=walk, 5=vanpool
The pay period database fields are below. A number is entered for each day representing the mode. I would like my report to count the modes for each pay period.
Wk_1_Sun char 1 1
Wk_1_Mon char 1 1
Wk_1_Tues char 1 1
Wk_1_Wed char 1 1
Wk_1_Thurs char 1 1
Wk_1_Fri char 1 1
Wk_1_Sat char 1 1
Wk_2_Sun char 1 1
Wk_2_Mon char 1 1
Wk_2_Tues char 1 1
Wk_2_Wed char 1 1
Wk_2_Thurs char 1 1
Wk_2_Fri char 1 1
Wk_2_Sat char 1 1
The pay period database fields are below. A number is entered for each day representing the mode. I would like my report to count the modes for each pay period.
Wk_1_Sun char 1 1
Wk_1_Mon char 1 1
Wk_1_Tues char 1 1
Wk_1_Wed char 1 1
Wk_1_Thurs char 1 1
Wk_1_Fri char 1 1
Wk_1_Sat char 1 1
Wk_2_Sun char 1 1
Wk_2_Mon char 1 1
Wk_2_Tues char 1 1
Wk_2_Wed char 1 1
Wk_2_Thurs char 1 1
Wk_2_Fri char 1 1
Wk_2_Sat char 1 1