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

How do you prevent data from splitting up in a report?

P: 2

I am currently studying A level ICT and my teacher isn't very good at explaining how to do some aspects of the course.

I was doing a question and I thought i completed it but the data split up, e.g. there would be 3 Armagh fields and maybe 5 Down fields.

How do I stop it and only have 1 field per area?

PDF = Paper January 2013, Question Task DB6
The image is my answer.

Any help would be greatly appreciated :)

Attached Images
File Type: jpg Answer.jpg (37.0 KB, 221 views)
Attached Files
File Type: pdf A2AS-AICT-Past-Papers--Mark-Schemes--Standard-January-Series-2013-12211.pdf (1.61 MB, 141 views)
May 12 '14 #1
Share this Question
Share on Google+
3 Replies

Expert Mod 5K+
P: 5,397
Well, first the image you attached of the report is in what is called report view.
This is NOT how you report will actually print out. Either go to the upper left, or lower right hand corner of your open report and select "Print Preview," this will re-run the underlying query and show you how your report will look at print time.

See if that solves your issue.

Please keep in mind that we're not a homework service; thus, we will NOT do your assignment; however, SHOW YOUR WORK and we'll nudge you in the correct direction.

Please check your Bytes.Com inbox. I'll send you my boiler plate of tutorials and usefull links.
May 12 '14 #2

P: 2
yes i do realise that you are not a homework service i am just asking a question on how to prevent the information from spliting up.

I have tried print preview but, in the image, in the original post there is only meant to be one 1 armagh area 1 down area, etc. but it is spliting up and i am unable to count the number of services and unable to sum up the total cost per area as it is split up.
May 13 '14 #3

Expert Mod 5K+
P: 5,397
NO, that is not how the report view works.
You do not always get the pagation nor other formatting you desire in the report view, yes, I know it's stupid; however, that's the way the program works.

You want page formating, then you have to view the report in print preview.
May 13 '14 #4

Post your reply

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