create a report based on an example report i have in microsoft word?

vbnetcoder
vbnetcoder used Ask the Experts™
on
New to Access reports. How would easily create an Access report based on an example report I have in Word format?  Is there an easy way to do this or do I have to put in text boxes for each line on the report.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Daniel PineaultPresident / Owner CARDA Consultants Inc.
Distinguished Expert 2018

Commented:
No easy way.  You have to manually recreate it or look to using Mail Merge to push the data from Access to Word.
Distinguished Expert 2017
Commented:
The wizards can give you some help.  Create a query that selects the rows and columns you want on the report and save it.  Then use the report wizard to create a report of that query.  I do this to get all the fields on the report and then move everything around to make it pretty since the wizard doesn't build pretty reports.
John TsioumprisSoftware & Systems Engineer

Commented:
If you have a "perfectly" looking report in Word you have 2 options...
1. design a report on Access that resembles the Word report (easy)
2. use Word Automation (control Word from Access) to populate fields on Word with values from Access (hard)

Author

Commented:
ty

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial