Here is the setup, a colleague has a mundane task of monitoring work permit status. Every month, he posts a list of personnel and relevant permits upcoming for renewal. He typically uses an access database and just organizes the expiry date for various permits to compile the list of those due for renewal. I'm more familiar with Access and setup the query to narrow results for relevant personnel, based on upcoming renewals for the end of the current month, grouped by renewal due in 30, 60, 90, or 120 days. I then duplicated that query for various other permits which are posted monthly. The queries work flawlessly in Access, it is beautiful to see hours of work every month resolved with a click of a button moving forward.
However, when exporting the queries to Excel to have it formatted in a more presentable manner when posted; one exported query imports properly, and another only imports the header information and a few blank cells below.
The only difference between the two queries are relevant permit numbers (arbitrary informational relevance that should not impact the import to Excel).
Why would two similar queries based on the same Access table, using almost identical data sets and calculation formulas, not import in the same manner?
Any help is greatly appreciated. Apologies if this is in the wrong forum for this post.