Report Layout & Front End Form...

[Matt800]

Two little problems that are annoying me!;

1) I have created a report in access (based on a parameter query) which contains 18 fields (mainly dates - dd/mm/yyyy). There are too many fields to fit all the information accross one page, portrait OR landscape. I've tried cramming the fields in and reducing the text to size 7 but its still not working.
Is there any way i can create a portrait, vertical report so the field names are listed on the left (top to bottom) and all the records go from left to right across pages rather than top-to-bottom as usual?

2) If i create an opening screen form to navigate to all the areas of the database, how do I set this form to open automatically when the database is opened (at the moment an earlier form i created opens)?

I'm using Access 2003.
Help much appreciated. (I used to be good with access 5 years ago but i've now forgotten everything!)

Matt - Manchester - UK

[Matt800]

P.S. When I say 'opening screen form/front end form' i think i mean a main Switchboard.

[JConsulting]

P.S. When I say 'opening screen form/front end form' i think i mean a main Switchboard.

Turning data like you're talking about is usually done by creating a crosstab query. You can use your Parm Query as the source for this. It may take some playing around some, but basically the idea is to use your "dated" fields as the left side and any other criteria across the top.

There is some irony in this...in the fact that most people that design reports actually want the dates across the top. sometimes you just gotta say hmmmm.

J