I want to display a text box on our Sales Menu that tells the sales staff if todays sales rank in the top 10, 20 or 50 top sales days of all time.  (A motivation thing.)

I created 3 aggregate queries based on the Sales table using the Return parameter of 10, 20 and 50 respectively.  These queries contain the TransDate date and Sum(SalesAmt) for each date.  My plan was to open each query (on the form open or on current event) and if it contained a TransDate = to [Date] then the text box on my Sales Menu would display the appropriate text ("Top Ten Sales Day or Top 20 Sales Day, etc.)  If today's date was not contained in any of the queries, the text box would be null.

I am stuck on how best to make this work when the Sales Menu opens. I have tried a couple of methods but it's not happening.  A point in the right directed would be much appreciated.

Thanks.