Add-in for advanced, canned reporting

[skbohler]

Hi,

I'm relatively new to Access and available add-ins.

We're looking for the ability to write an Access VBA application for a client that includes canned, advanced reports.

That is, the user would be able to choose a list of different reports from a menu, maybe type in a timeframe, and the report is generated. Graphs would be nice too.

The reports would be sort of advanced. For instance, if one table had historical sales data and another table had present sales data, we would want a report that would display average sales for NJ; sales of one state versus another. Basically, the ability to create canned, advanced reports using functions like average, median, correlations).

Does such an add-in exist?

Thanks in advance,
Steve

 

[llkhoutx]

Steve, that's what Access programmers do in native Access, not as an add-in.

 

[skbohler]

Response

Thanks for your response.

I was under the impression that Access did basic reporting and graphing of tables or queries. I went through the Report wizard and found that I did not have a lot of control over where data appeared either.

Steve

 

[llkhoutx]

The report and form wizards are ok, but not great formatting tools. You have to edit their appearance and add appropriate functionality.