Hello.
I have a db which shows the following columns -
Machine Number | Shift Date | Shift Name | Product
I want to add another column which will show "1" for the first record when each machine produces a certain product wildcard name (named "Box*") per shift (AM or PM). Therefore, it's not the first time it produces Box* on that day, but rather that shift on that day.
I've had a look at the First function in my query as well as DCount but I'm at an absolute loss.
Thanks.
I have a db which shows the following columns -
Machine Number | Shift Date | Shift Name | Product
I want to add another column which will show "1" for the first record when each machine produces a certain product wildcard name (named "Box*") per shift (AM or PM). Therefore, it's not the first time it produces Box* on that day, but rather that shift on that day.
I've had a look at the First function in my query as well as DCount but I'm at an absolute loss.
Thanks.