How to calculate how many pick up units do I need?

How to calculate how many pickup units I need?

I have a table called “Sales Details” and I want to create a view called “Pickup Unit”.

In the “Receive Units” view, I want to show how many units I need to claim.

condition:
[day of sale]=today()
[Packing person]=empty

thank you guys to answer

0 1 118
1 REPLY 1

Steve
Platinum 4
Platinum 4

I don’t understand.

Top Labels in this Space