report
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Report

Report

resolvedResolved · Urgent Priority · Version 2007

replyReply Wed 7 Sep 2011, 16:41Delegate Claire said...

Claire has attended:
Access Advanced course

Report

Can you please tell me how to run a report of a specific record based on a value in the form. Should this be a macro? Thanks

For upcoming training course dates see: Pricing & availability

replyReply Fri 9 Sep 2011, 14:51Trainer Simon said...

RE: Report

Hi Claire,

Thank you for your question and welcome to the forum.

You would need to create a conditional macro with the condition relating to the value of an object on the from and then output the record or records relating to that condition.

Alternatively, you could create a query which displays the results needed. Then create a macro to open the form and use the Filter option to apply the criteria and then output the results to a report.

I hope this helps.

Regards

Simon

Fri 16 Sep 2011: Automatically marked as resolved.

 

Please browse our web site to find out more about
microsoft access training courses and other Microsoft training courses.

Access tip:

Add current time to a field

Press CTRL+SHIFT+ SEMICOLON

View all Access hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard