J
Jessica
Hello All
This is what my table looks like...
Date Brand Flavor Number of Cases Shift
10/01/05 Barilla Marinara 3000 A1
10/02/05 Newmans Plain 1000 B1
10/19/05 Barilla Marinara 1000 B2
10/20/05 Barilla Marinara 2000 A1
10/20/05 Barilla Marinara 500 B1
I have two questions,
1)I have a form that a production person inputs throughout the day. My
question is the day after a warehouse person takes a physical count and
needs to input a total number per brand and flavor. Can someone head me into
the right direction on how this can be done. The warehouse person will go
back to when the product started without any different brands or flavor in
between. For example on 10/21/05 he would count Barilla Marinara 10/19/05 to
10/20/05.
2)I want to total cases per shift but B1 and B2 work before and after
midnight and don't know how to setup the query to do this.
Thank you,
Jess
This is what my table looks like...
Date Brand Flavor Number of Cases Shift
10/01/05 Barilla Marinara 3000 A1
10/02/05 Newmans Plain 1000 B1
10/19/05 Barilla Marinara 1000 B2
10/20/05 Barilla Marinara 2000 A1
10/20/05 Barilla Marinara 500 B1
I have two questions,
1)I have a form that a production person inputs throughout the day. My
question is the day after a warehouse person takes a physical count and
needs to input a total number per brand and flavor. Can someone head me into
the right direction on how this can be done. The warehouse person will go
back to when the product started without any different brands or flavor in
between. For example on 10/21/05 he would count Barilla Marinara 10/19/05 to
10/20/05.
2)I want to total cases per shift but B1 and B2 work before and after
midnight and don't know how to setup the query to do this.
Thank you,
Jess