Search found 5 matches

by DonHD
Tue May 08, 2012 7:06 pm
Forum: Custom Reports
Topic: Anyone regularly using Access .mdbs for reporting?
Replies: 1
Views: 1640

Re: Anyone regularly using Access .mdbs for reporting?

Anybody ever "split the database" so the relationships and queries are in one database and the "backend" could be the PC exported one?

http://office.microsoft.com/en-us/acces ... 42026.aspx
by DonHD
Tue May 08, 2012 6:52 pm
Forum: Custom Reports
Topic: Anyone regularly using Access .mdbs for reporting?
Replies: 1
Views: 1640

Anyone regularly using Access .mdbs for reporting?

I wished to make a report on a table join not included included in the package. [See thread in Membership on "Offices Served"] I have made an Access export and built relationships and a query. When I re-export later with updated data the relationships and query previously built are gone. I have no w...
by DonHD
Tue May 08, 2012 11:13 am
Forum: Membership
Topic: custom officer reports
Replies: 10
Views: 4995

Re: custom officer reports

In many cases here, former officers and committee leaders are no longer active members but are friends or ex-members still in the community. In addition I am interested in the proximity of their serving in (the stressful) president's position and their resignation dates. A report in committee/role o...
by DonHD
Mon May 07, 2012 6:52 pm
Forum: Membership
Topic: custom officer reports
Replies: 10
Views: 4995

Re: custom officer reports

Ok, I waited till our office admin went home and exported the Membership and Skills stuff to an Access MDB. After the export I needed to input the relationships between ME, SKSERV, SKREF and SKCODES. Before I spent time polishing my query, I went back and imagined it was days later and time for upda...
by DonHD
Mon May 07, 2012 11:23 am
Forum: Membership
Topic: custom officer reports
Replies: 10
Views: 4995

Re: custom officer reports

Re reports on Offices Served tabla SKSERV Its hard to understand how a need raised by BrianShoe in 2004 and 2005 is still unmet many revs later. You only really need to allow an entry point to run a query that joins tables....then we can export at will! :) Both formatted reports ONLY report on curre...