statements in a filter

[Afrosheen]

Thanks for reading this.
I have a filter I'm trying to build. Then end results have to be with the
[status] field = 'working'. This is the way I have it set up.

strwhere = "[shift] = 'a-days' or [shift] = 'b-days' or [shift] ='day shift'
or [status] = 'working'"

Then I put in in the docmd.reportname and so on.

I want the report to print out everyone working that is on the a-days
rotation [shift].

My job requires will say 4 people to run things. If there's not enough then
someone from another shift IE: b-days to come in and work. So when the A-day
shift report is printed out it needs to look like this.

Joe A-days Working
Ted A-Days Working
Pete B-Days Working
James Day Shift Working. And so on.

This is all the same people working on the A-day report.

There are three other reports, but if I can get one report "A-days" working
then I can change the code for: B-Days, A-Nights, and B-Nights.

Thanks

 

[bhicks11 via AccessMonster.com]

Hi Afrosheen,

Why not just create a report that groups on the Shift and under that on the
Status field and show all your workers by what shift they are on and if they
are working or not. Or you can use a query for your datasource that filters
only the status = working and create the report with the Group on Shift.

Bonnie

http://www.dataplus-svc.com

Thanks for reading this.
I have a filter I'm trying to build. Then end results have to be with the
[status] field = 'working'. This is the way I have it set up.

strwhere = "[shift] = 'a-days' or [shift] = 'b-days' or [shift] ='day shift'
or [status] = 'working'"

Then I put in in the docmd.reportname and so on.

I want the report to print out everyone working that is on the a-days
rotation [shift].

My job requires will say 4 people to run things. If there's not enough then
someone from another shift IE: b-days to come in and work. So when the A-day
shift report is printed out it needs to look like this.

Joe A-days Working
Ted A-Days Working
Pete B-Days Working
James Day Shift Working. And so on.

This is all the same people working on the A-day report.

There are three other reports, but if I can get one report "A-days" working
then I can change the code for: B-Days, A-Nights, and B-Nights.

Thanks