Ok, I need some help with getting a count of a field called Batch# and I need that field put in a text box. I need to have it filtered out by Shipper.
For example. We received 5 UPS packages at 10am and they were entered with a batch # of 1. Then at 1pm, UPS drops off 7 more packages, this time entered as batch # 2.
On they entery screen want to show how many packages they have recieved so far for this particular batch, which is selected on the main form. So, the "total packages" for when they are scanning in batch one should increment every time they enter a new package, but reset after they exit the form and change the batch number to two. I wrote a query but it gives me a total for 1 type and I can't figure out how to restrict the information given back by Shipper and date. Fedex will come like 3 times a day and have batch 1,2 and 3...
Perhaps I am going about this the wrong way. If anyone can help or has any ideas I would very much appriciate them.
Thanks
-Ben
For example. We received 5 UPS packages at 10am and they were entered with a batch # of 1. Then at 1pm, UPS drops off 7 more packages, this time entered as batch # 2.
On they entery screen want to show how many packages they have recieved so far for this particular batch, which is selected on the main form. So, the "total packages" for when they are scanning in batch one should increment every time they enter a new package, but reset after they exit the form and change the batch number to two. I wrote a query but it gives me a total for 1 type and I can't figure out how to restrict the information given back by Shipper and date. Fedex will come like 3 times a day and have batch 1,2 and 3...
Perhaps I am going about this the wrong way. If anyone can help or has any ideas I would very much appriciate them.
Thanks
-Ben
