Thanks in advance for your replies, this is a 2-part question.
The Database would be called: "Production" The Table would be called: "FruitHistory"
Is there a way to query this data such that it will only return results that have at least 3 day's worth of data (as an example).
Ex: The query returns Tony's, David's and Aaron's records but not Bern's
Building on Part1's rule but now only returning 3 days worth of data at all
Ex: The query returns 11/3-11/5 for Tony and Aaron and all of David's data but still not Bern's.