You can get the highlighted rows using the following script:
FirstSortedValue([Date Quote Created],-[Date Quote Created]) as [Last Quote Date],
FirstSortedValue([Quote #],-[Date Quote Created]) as [Last Quote],
FirstSortedValue([Dollar Amount],-[Date Quote Created]) as [Last Dollar Amount]
Resident [Table 2 Sales Quotes]
Group By [Sales#];
Thank you so much for the help!
I do have one issue that occurs when doing what you have listed above.
It appears as though I am still retrieving the other Quote #'s that I do not want included in my data set. What your listed change has done when I add it in my script is simply take the [Quote #] that is the most recently created based on [Date Quote Created], and append the [Dollar Amount] for that quote to every single quote linking to that [Sales Deal #] field.
So, in effect, if a single [Sales Deal #] has 4 quotes with different dates and dollar amounts, that change above is just pulling and changing the data of the other quotes that I don't want pulled to match the quote I want to pull. Instead, I want to remove all of the other [Quote #] and pull in only the single, most updated Quote #.
Help is very appreciated!!