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

vbnetcoder used Ask the Experts™
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.
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

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
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

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)



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