How to print a selection of records ?

T

toyota58

Hi,

I'm quite a newbie. I've already made a table and a form. How do I
search and print a selection of records on a single page of paper ?

Example : I want to search John, David, George, Bob phone numbers and
print it. Sure ...I can use COPY and PASTE from Microsoft Access to
Microsoft Word, each record but it is quite a time consuming.


Thank You.
 
J

Jeff @ CI

If you need to select specific records you will need to learn to make a query
based on criteria you desire.

If you do not need to select specific records, then make use of the report
wizard. You can still print a report using basic controls such as sorting
alphabetically for example.

I am a "try till ya die then ask" kinda guy and so I suggest you play around
and learn from making some reports and or queries. Access is friendly enough
for that to be fun.

However, if someone has a more technical response than mine, go for it.
Just thought I would try contributing once.

Jeff
 
A

Allen Browne

To expand on Jeff's suggestion, add a Yes/No field to your table.
In the form, check the boxes for the records you want.
Create a query with criteria for the checked boxes (True.)
Make the report based on the query.
 
J

John W. Vinson

Hi,

I'm quite a newbie. I've already made a table and a form. How do I
search and print a selection of records on a single page of paper ?

Example : I want to search John, David, George, Bob phone numbers and
print it. Sure ...I can use COPY and PASTE from Microsoft Access to
Microsoft Word, each record but it is quite a time consuming.


Thank You.
Click to expand...

Create a Query. Use "parameters" as query criteria - for instance,

[Enter last name:]

if that's how you want to select records. Include the fields that you want to
see printed out.

Then create a Report based on the query. Lay out the fields any way you like -
you can open the Query in datasheet view and choose the "Auto Report" from the
toolbar to get at least a starting point.

Print the Report.


John W. Vinson [MVP]
 
Top