So I have a table full of data. I am trying to create a query that will give me a summary. So here is an example of what the data looks like: * symbolizes unique fields
ID* Status Team_name Team ID Persons_Name Persons_ID CC Role Proposed
1 Pending Team 1 1 Name 1 1234 PA L 1000
2 Pending Team 1 1 Name 2 1235 PA C 800
3 Pending Team 1 1 Name 6 1239 PA P 500
4 Pending Team 2 2 Name 3 1236 SA L 1000
5 Pending Team 2 2 Name 4 1237 PA P 500
6 Pending Name 5 1238 L1 L 1000
So if you look at the team 1 there are three different roles and three different amounts. within a team there will only be at max 3 amounts. So I can get the max using max(proposed) and the min using min(proposed). I am trying to get it to look like this 1000/800/500. So far i have the 1000 and the 500 using PROPOSED(L/P): Max([proposed_amt]) & "/" & Min([proposed_amt]). I need to get the value in the middle. Ive tried everything. That is my first step.
I am trying to get results like this:
Team_Name Team_ID Proposed(L/C/P)
Team 1 1 1000/800/500
Thank you for the help guys.