How do I create a single page report of each customer

J

jonathanlcampbell

I haven't used access for a very long time, and my work with it previously
was minimal.

I have a customer database, and now I want to create a simple, 1-page sheet
containing just one customer's information and some text. (I suppose you
could call it a form, but it is for manual use, not to be entered into the
database).

How do I do this?
 
A

Arvin Meyer [MVP]

I'm not sure I understand, but I'll take a stab at it. I'll have to assume
that you want to add handwritten remarks on an Access report.

First create a query which has all the information from the database that
you want to see. Create an Access report using the query as a record source.
There are wizards for both of these functions.

I also assume that you want only 1 customer on the report at a time, so go
into your query, find the customer name column and add this exactly as you
see it:

[Please Enter a Customer Name] & "*"

Now open your report and type in enough letters to identify your customer,
at the prompt.

You can fancy it up as you wish.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Top