By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,930 Members | 1,269 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,930 IT Pros & Developers. It's quick & easy.

Report Layout & Front End Form...

P: 2
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
Sep 13 '07 #1
Share this Question
Share on Google+
2 Replies

P: 2
P.S. When I say 'opening screen form/front end form' i think i mean a main Switchboard.
Sep 13 '07 #2

Expert 100+
P: 603
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 the fact that most people that design reports actually want the dates across the top. sometimes you just gotta say hmmmm.

Sep 15 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.