Hi Nate,

I don't mind your asking, at all.
Frankly I am more comfortable with Excel (not VBA or Access).
The reason I made the comment (I just want to run the Macro, not do a
query.) is that I had already created a simple Access query, follow on report
and Macro.
The Macro is just 2 steps, "Outputto" and "Quit". It outputs the report data
to an Excel file.
Since you asked, the only reason I go to Access is to use the report feature
"hide repeating data". The report sort is by Day and Date and shows scheduled
events in our church. The first event of each day shows the Day and Date and
doesn't repeat for the other events of each day. The new Day and Date are
much easier to identify.

You can see the results at: http://www.firstchristianstow.org/ and select
"Monthly Calendar" (Left side of screen).

If you tell me this could be done in Excel, that would be the greatest. I
would not go to Access at all.
Logically, I believe it could, but I am not sure if there are formulas
and/or functions capability in Excel, that would allow doing it.
If you know it can be done and point me in the direction of what can be used
to do it, I am definitly open to try it.

Thanks once more for your help,
Don


"Nate Oliver" wrote:

Hello again Don,

Do you mind my asking what your macro does? I can see what it doesn't do:

I just want to run the Macro, not do a query.

The reason I ask is that your App might be more stable and maintainable if
you keep your process in-house, in Excel. You can automate Access from Excel.

Regards,
Nate Oliver