Originally Posted by
Bloom
Hello
I have a database with information about clubs for older people and I am trying to create a list of lunch clubs, cost of meals, transport options and details of the organisers. I have set-up the query but the report options are driving me mad. I get a wizard that gives me a report too wide to be any use and I can't move the fields underneath each other to make everything fit.
Can you set the printer options to print in Landscape view?
Option two: export to pdf doesn't give me any control over how it looks and records alternate in layout and there's no option to stop records from being split across pages.
You shouldn't have to go there.
Option three: create a linked word document and add fields. It's years since I did this and I can't even find a merge option from Access to Word of from Word linking back to my database.
Nor here.
Option four: create a report from scratch but the two tables I need are nowhere to be seen in the list of tables and I can't access my query with all the fields I need.
This strongly suggests that you haven't considered creating a query which makes
simplifies the creation of the report. In other words, one query extracting the information you need from multiple tables can greatly simplify the creation of a report.
There isn't enough information to definitively say whether or not grouping could help with your problem, but IMHO you should check it out.
I just want to get as many records as I can onto each page of A4.
Can anyone help me?