Pestomania
Active Member
- Joined
- May 30, 2018
- Messages
- 332
- Office Version
- 365
- Platform
- Windows
Hey everyone. I have been working two days on trying to figure this out and have made no progress. I've read the multiple posts and numerous other websites, but cannot get it to work. So below I will explain what I have.
Dim lastFriday, Sunday, Monday as date
6 columns: actual release, actual cut, pipe, electrical, outfit, vent
Different quantities of rows but are all dates under Actual Rls and Cut.
The Pipe Electric, Outfit, Vent are all Value fields with a count value.
Are the bottom of the table is a "Grand Total" line.
I will provide a few scenarios below:
Scenario 1:
I need to find the number of Pipe parts that were actual released on lastFriday.
Scenario 2:
I need to find the number of Outfit parts that were actual cut between lastFriday and Sunday.
Scenario 3: I need to find the number of Vent parts that were actual cut yesterday.
Can anyone please help?
Thank you
Dim lastFriday, Sunday, Monday as date
6 columns: actual release, actual cut, pipe, electrical, outfit, vent
Different quantities of rows but are all dates under Actual Rls and Cut.
The Pipe Electric, Outfit, Vent are all Value fields with a count value.
Are the bottom of the table is a "Grand Total" line.
I will provide a few scenarios below:
Scenario 1:
I need to find the number of Pipe parts that were actual released on lastFriday.
Scenario 2:
I need to find the number of Outfit parts that were actual cut between lastFriday and Sunday.
Scenario 3: I need to find the number of Vent parts that were actual cut yesterday.
Can anyone please help?
Thank you