Need help with MS Access

[Charlene Clevenger]

I need to make year-end statements for the ministry I work for. I will need to take names from the mailing list, and make a list of what each one gave this year. Of course, not everyone on the mailing list gives. All this information is in MS Access. Can anyone help me?

[Doug Kitchen]

I need to make year-end statements for the ministry I work for. I will need to take names from the mailing list, and make a list of what each one gave this year. Of course, not everyone on the mailing list gives. All this information is in MS Access. Can anyone help me?

Charlene,

Depending on how the database is arranged you can make a query where the "giving" column "is not null". Usually, the mailing information is in one table and the giving is in another. So to get the "name" and the "giving" to be in the same report, you need to put both tables in the query, and drag a line (this is called a join) between the name field in the mailing table and the name field in the giving table. The two fields may be identifying number's instead of full names. Once you have the fields matched, and the giving amounts, you can make a report from that query.

There is probably a special form to put the records into the database, and that may be a good clue as to how to get the information back out.

Clear as mud?

Doug