creating a report from the data presented by an individual record

[joe.deacon999]

I have 1000+ records in my database (2003) and I would like to print a
single page report using some of the fields off the data input page.
HOw do I do this please I am a self taught newbie and try to avoid the
VBA code input where I can.

Any help would be greatly appreciated.

 

[KARL DEWEY]

Create a query and use it as source for the report.

 

[chriske911]

(e-mail address removed) explained on 4/21/2009 :

I have 1000+ records in my database (2003) and I would like to print a
single page report using some of the fields off the data input page.
HOw do I do this please I am a self taught newbie and try to avoid the
VBA code input where I can.

Any help would be greatly appreciated.

create the report as you like, base it on a query where you add
controls from the form as criteria

then add a button to your form and use the wizard for the print report
action and follow the steps thru

VBA code is hard to avoid when designing access application so get used
to it

the code generated by the built in wizards are a very nice way to get
to know VBA

grtz