S
SuzyQ77
I have only been working in Access a short time, so bear with me. I created
a database table with fields for a person's name, address, phone, etc. I
have fields for Monday, Tuesday, Wednesday, Thursday, Friday using Yes/No for
their scheduled days. I'm now working from a form made from this table.
I'm using check boxes for the Monday through Friday fields and enter checks
on the days that they are regularly scheduled. Among others I need one
report for each day of the week and who is scheduled (no problem there). I
also need a report showing each day of the week (across the top) and under
those day headings, each person that is scheduled for each day of that week.
Since schedules change constantly, I'm looking to change things in one spot
(thus the Yes/No checkbox on the form) without having to change it anywhere
else. I have tried every grouping and sorting, but I must be missing
something (probably VERY simple and a big DUH). I just can't figure out what
I'm doing or not doing to get this weekly report to work.
a database table with fields for a person's name, address, phone, etc. I
have fields for Monday, Tuesday, Wednesday, Thursday, Friday using Yes/No for
their scheduled days. I'm now working from a form made from this table.
I'm using check boxes for the Monday through Friday fields and enter checks
on the days that they are regularly scheduled. Among others I need one
report for each day of the week and who is scheduled (no problem there). I
also need a report showing each day of the week (across the top) and under
those day headings, each person that is scheduled for each day of that week.
Since schedules change constantly, I'm looking to change things in one spot
(thus the Yes/No checkbox on the form) without having to change it anywhere
else. I have tried every grouping and sorting, but I must be missing
something (probably VERY simple and a big DUH). I just can't figure out what
I'm doing or not doing to get this weekly report to work.