Multiple Customized Reports Based on Database

B

Bevan

I'm running Access 2000 and have a large database table imported from another
source.

The information in the database varies and depending on these variations of
data I want to be able to print out a specific paragraph / bit of information
etc.
E.g. person X is 20 and has one leg so Print out Blue and White for instance
I was thinking along the lines of some sort of nested Ifs but my programming
skills have far deteriorated from what little they were before

I was just wondering if there was a way that Access could read the
information from the table and depending on what information is there under
each row, would return the respective paragraph or response associated to
that data in a report. I was hoping to have in the end, pages of reports for
each row, customized according to what information was contained in the
columns of those rows.

Thanks.
 
M

Mike Painter

Bevan said:
I'm running Access 2000 and have a large database table imported from
another source.

The information in the database varies and depending on these
variations of data I want to be able to print out a specific
paragraph / bit of information etc.
E.g. person X is 20 and has one leg so Print out Blue and White for
instance I was thinking along the lines of some sort of nested Ifs
but my programming skills have far deteriorated from what little they
were before

I was just wondering if there was a way that Access could read the
information from the table and depending on what information is there
under each row, would return the respective paragraph or response
associated to that data in a report. I was hoping to have in the end,
pages of reports for each row, customized according to what
information was contained in the columns of those rows.
Click to expand...

If you have fields for age and number of legs and any other thing you want
then it is almost completely a matter of building queries.

We would need a lot more information about the structure of the database to
give any more information.
 
B

Bevan

Thanks for the quick response

Well that was just an example before. The actual data is in regards to
clients and their information. What kind of entity are they, e.g. Company,
Partnership etc. If they are a company for example I wanted to print out a
specific response to that and if they are a partnership, something different.

The database consists of a client list with such fields as name, type, and
other specific information relating to their circumstances.

I was hoping to get a totally customized report based on the client's
information to send out to them so that they can fill out those details which
relate to them rather than a whole bunch of irrelevant information.

In using queries, would I be able to sort through that information from the
table and then print out in a report a specific response to that?
I would also like to get the information in the report in a specific format
and would that compromise such formatting?

Thanks.
 
Top