Please help with data base!

  • Thread starter Thread starter Nate
  • Start date Start date
N

Nate

I am a total klutz when it comes to programming queries, functions, or what
have you. I can do the simple part of setting up a basic DB, tables, reports
etc..

The DB that I have is for a volunteer group and have had wonderful responses
for help in the past with other DB's for this group,but I just seem to be
unable to catch on to how to do the queries, functions, etc..

What I want to have in a report is two things, the first showing each
volunteer the total # of shares, and the total $ amount The second is a
compilation of all of the data from all of the volunteers. As I said, most
of that I can figure out okay but it's just setting up the functions or
whatever.

For those of you who are real wizards at this, it should hopefully be real
simple to do. I've tried this programming stuff and just can't get it. If
someone could figure this out and modify the DB I would be very greatful,
not only for getting it done, but it might finally be a window to learning
how to do it myself. If you would be willing to edit the DB I would be glad
to e-mail the basic DB file to you
 
you can do a whole lot in Access without using functions, or VBA at all, for
that matter. but you can't get very far at all in obtaining valuable
information from your data, unless you use queries.
suggest you learn the basics of queries to get started; it's not as hard as
you think. one good text that will introduce you to the power of queries,
but gently, is the Access <specific version> Bible by Prague and Irwin,
published by IDG Books. it's an excellent book for beginning to intermediate
users and well worth the investment. once you have a solid understanding of
how queries work, you'll find it much easier to attempt more complex queries
as the need arises.

good luck!
 
Thanks Tina, I have two other books which I've found to be difficult to
understand. I'm wondering if it's me, or just poorly written books. Are you
familiar with with the Microsoft "Running Access 2000" or "Access 2000
Programming Weekend Crash Course" by C.Prague, J. Reardon, L. Kasevich, D.
Reid, & P. Phan? I did take a quick look in the Microsoft book and may have
found a solution in the report wizard that will do what I want. I'm curious
now to see if the Access (x) Bible would be any better. Thanks.
 
i don't have either of the books you mention, so i'm not in a position to
compare. it's my *guess* that those two are written somewhat above the
beginner level. i've used the Access Bible, in fact it was the required text
for a beginning Access course i took several years ago. so i recommend it
with confidence to anyone who needs a solid grounding in the basics to
prepare for tackling more complex issues.

hth
 
Back
Top