By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,499 Members | 829 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,499 IT Pros & Developers. It's quick & easy.

basic report/subreport ?

P: n/a
caveat: I am learning access and this is my first usenet post ever. if
there is a more appropriate place for my questions, please let me
know.

I have created a grants management database and am now trying to
create reports. The report starts with general info such as the grant
name, accounting code etc. This part is done.

Now I am trying to list the names and contact information for all
grant officials. These are stored in a table "person" which is joined
(1 to many) to "grantcontactdetails" which is joined (many to 1) to
"grantid"

I need the report to list all the names that pertain to a specific
grant.

My questions?

How do I set up the record source to accomplish this?
Does this need to be done in a sub report? if so why?
Any other tips for a newbie.

Any advice on online reports tutorials, articles or books would be
great. I have read a intro to db development book and am working from
"how to do everything with ms acccess 2003" by V. Anderson.

Thanks,

Jean-Paul
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
I've heard of a number of databases for grant-tracking, either here in the
newsgroup or in conversation over the years. You may be expending
unnecessary time and energy reinventing something that already exists. You
might search the archives of this newsgroup at http://groups.google.com
Advanced Search on the word "grant" or "grants".

In fact, you might search at http://www.google.com for "grant database" or
"grants database" or search at some of the shareware/freeware software
repositories.

Larry Linson
Microsoft Access MVP
Larry Linson
Microsoft Access MVP
"Jean-Paul" <je******@sacnas.org> wrote in message
news:10**************************@posting.google.c om...
caveat: I am learning access and this is my first usenet post ever. if
there is a more appropriate place for my questions, please let me
know.

I have created a grants management database and am now trying to
create reports. The report starts with general info such as the grant
name, accounting code etc. This part is done.

Now I am trying to list the names and contact information for all
grant officials. These are stored in a table "person" which is joined
(1 to many) to "grantcontactdetails" which is joined (many to 1) to
"grantid"

I need the report to list all the names that pertain to a specific
grant.

My questions?

How do I set up the record source to accomplish this?
Does this need to be done in a sub report? if so why?
Any other tips for a newbie.

Any advice on online reports tutorials, articles or books would be
great. I have read a intro to db development book and am working from
"how to do everything with ms acccess 2003" by V. Anderson.

Thanks,

Jean-Paul

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.