Crosstab Query Report

[Xarkath]

Before getting into this I want to clarify that I am already using the VBA for dynamic reporting but I have a few issues with it so I am really looking for something that is not so heavy handed.



I have a crosstab query that has 6 static fields including the totals and variable fields numbers from 1 to 12 fields depending on the number of services rendered. I am simply looking for a way to create the reports on the fly. Don't need to format them or save them as ultimately they will be exported to Excel and all formatting will be done there. Ideally I would like a macro or VBA that just points to the correct query and initiates the native create report feature but opens it in report view versus design view. This way nothing needs to be done with column labels or deleting unused columns or any of that.

Initially I thought it would be easy to setup a macro for this but I cannot find the command to trigger the create report event. Is this even possible? Compared to other that can be done this seems like it should be simple if not straightforward.

Any advice is appreciated.

Thanks

[June7]

If you only want to export to Excel, why a report - just export query.

Review:

http://allenbrowne.com/ser-67.html

http://www.access-programmers.co.uk/...ad.php?t=78952

[Xarkath]

That is a possibility but sometimes there may be no data to export so my thought was that a report would give the user the opportunity to cancel the process prior to export but I suppose I could just let them view the query directly.

Based on the second link you posted I will assume that there is not a simple command to run the native create report function.


Thanks for the response.