Use a report to print out a single entry in a table?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to use Access' report feature to print out a one-page summary of a
single record within a table. Instead, every time I try to print the report,
it prints once per entry in the table. For example ... if my table has five
entries in it, and I only want to print out a summary of record #3, I'm only
able to print out a summary for each record and throw the printouts for #s
1,2,4 and 5 in the trash can. Not how I'd hoped it would work out.

Ideally, I'd like to be able to print out a one-page summary of the data
contained within a single record. I can sort of do this ... but I'm getting
this summary for every single record in the table, every time I want to
print.

Anyone know how I can accomplish this? Is the 'report' feature not the
proper feature to be using?

(If I haven't been clear enough, please e-mail me for clarification at [
derrich at gmail dot com ].
 
Derrich,

You need to base your report on a query not directly on
the table. If you already have the report based on a query
there are several ways of achieving what you want. In the
query design view enter "[Please enter record number you
want printed]" (without the quotes) in the criteria for
you record number field. This will prompt the user to
enter the record number to print. The query will then only
present one record to the report for printing.
If you are calling your report from a form displaying the
record you wish to print the query criteria can point at
the form. eg. forms![yourformname].[recordnumberfield]

HTH,

Terry
 
Back
Top