Doing reports from SQL database using Access

Feb 09, 2006 2 Replies

We just upgraded to Sage Pro ERP 100. This is on an SQL server. I am able now to do customized reports using Access (in read-only).



Does anyone else do their own reports or use Sage Pro?



I am new here and was struggling to find different groups which might be helpful. If anyone has any solutions, please feel free to email me at snipped-for-privacy@cincinnatichamber.com.



I work for the Cincinnati USA Regional Chamber, the 5th largest Chamber in the USA. We use iMIS for our member database and do reporting in Access in the same way.



Thanks for any and all help !!!



Michelle Boggs CPA Accountant Cincinnati USA Regional Chamber snipped-for-privacy@cincinnatichamber.com



Hi Michelle,

In case you haven't checked yet, there are several access newsgroups that you might want to visit. They all start with "microsoft.public.access." There is a microsoft.public.access.reports group that might help.

I've found them to be pretty helpful .

Best Bill

I am pretty sure Sage has their own newgroups. At least they did back when I used MAS 90 a few years ago.

You might try and find either Sage's server if they still have one, or newsgroups for sage or the software app you use.

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required