View Full Version : Access Database


Pudda66
08-31-2001, 07:40 PM
Can anyone help me? I am trying to build a database where Form letters the basis for it. I mean I would like to have a database that will mailmerge information to a report on 1 person selection from a simple database of a lot of information. Can this be done? How hard is it to do? Help!!!!

EX.
database of people on a trip.
name ssn address
person 1
person 2

I want this database to be able to produce 3 to 4 different letters by choosing which letters to print with a click of a radio button from a switchboard.

jwindon
08-31-2001, 08:08 PM
How much Access do you know?
It's not that tough.
First you are going to need to make tables.

tblTrips
needs to have a tripID and a tripDescription

tblBookings

needs to have the tripID (datatype lookup from tblTrips) and Name, ssn, etc.

You will end up running queries you can base off of individual trip, i.e. Atlanta, France, etc.

You can use your mailmerge to drawn in only those names and fields you need off of those queries.

If you don't know a whole lot of Access, you will need to progress slowly, so I hope you are not in a hurry.

Keep posting. You will get lots of help here.