Hello,
I'm trying to figure out the best solution to this problem. I'm trying to find the total count of emails, oldest date in folder, and number of emails with the oldest date per folder that I have linked from Microsoft Outlook. I have about 20 folder I have linked to in Microsoft Access. I have figured out how to get the oldest date and the count of total emails per folder. But I need to get the number of emails with the oldest date per folder. I don't know if I can do this with all one query since I would have 2 count functions. And I can't think of the best way for a subquery with this many tables. I would have so many queries. Your help would be much appreciated.
Thanks