UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Blank lines in reports    
 
   
Gordon
post May 30 2004, 05:19 AM
Post#1



Posts: 9
Joined: 28-May 04
From: Edinburgh, Scotland


I have a question I hope you can answer. I have produced a invoice report which incorporated the customers names and addresses. However some of the data in the fields on the table are empty and this of course is coming out as a blank line in my report
The fields I have at present in m report read like this:-
=[First name] &" " & [Last name]
Address 1
Address 2
Address 3
Town
Postal code
I hope you can help
Regards
Gordon
Go to the top of the page
 
-Scott-
post May 30 2004, 05:35 AM
Post#2


UA Quasi Admoderuser
Posts: 2,256
Joined: 30-January 00
From: Windsor, ON, Canada


Hello Gordon, and welcome to UtterAccess!
The report is getting its data from either the a table, or, a query based on a table (or mulitple tables). In order to get rid of these blank records, you will need to set some criteria in the reports "recordsource" query. If you have any experience with working with queries you should have no problems, otherwise, there is a wealth of knowledge here at the site and inside the access help files. An alternate approach would be set the Filter property of the report, but may be more complicated depending on your skill level.
A good place to start would be in our "Access FAQA's" board - (reached via the Quick Jump box on the left column of this page)
HTH
Go to the top of the page
 
Gordon
post May 30 2004, 06:07 AM
Post#3



Posts: 9
Joined: 28-May 04
From: Edinburgh, Scotland


Hello Scott,
Thank you for replying....but I am just a novice at Access.....so I am struggling with some of the replies I am getting from others.
Is there a simple method, just like in MS word, where Access filters out the empty data lines?
Thanks once again.
Gordon
Go to the top of the page
 
-Scott-
post May 30 2004, 06:17 AM
Post#4


UA Quasi Admoderuser
Posts: 2,256
Joined: 30-January 00
From: Windsor, ON, Canada


Gordon,
If you right click on a blank spot in the reports Detail section, then go to properties, in the Format tab there is a property called "can shrink"... try setting this to yes and see if it works. I'm pretty sure that this will only work so long as you have only fields in the detail section (this means, no rectangles or anything to force the sizing).
Ocan't believe i didn't even think of that.. LOL
Go to the top of the page
 
Gordon
post May 30 2004, 07:05 AM
Post#5



Posts: 9
Joined: 28-May 04
From: Edinburgh, Scotland


Hello again,
The data is contained within the report header section. Does that make a difference.
It getting the information from a query, that each time it run creates 1- many lines....It then groups the address details together to give the customer invoice details. The lists what is sold to them in the details section of the report.
Regards
Gordon
Go to the top of the page
 
Gordon
post May 30 2004, 10:37 AM
Post#6



Posts: 9
Joined: 28-May 04
From: Edinburgh, Scotland


This is still what I am getting.
[First name] & " " & [Last name] (John Smith)
Address 1 (1 Anyway)
Address 2
Address 3
Town (Biggtown)
Postal code (AB1 2CD)
How do I stop the blank spaces appearing, when I have records like this.
I hope you can help
Go to the top of the page
 
R. Hicks
post May 30 2004, 10:56 AM
Post#7


UA Forum Administrator
Posts: 40,467
Joined: 8-February 00
From: Birmingham, Alabama USA


Just concatenate the field values together using the "+" (plus) operator to create a string value to be displayed in a single textbox.
Set this textbox to be able to grow and shrink ...
Here is the expression that should do what you need ...
This is all one long single line expression .....
CODE
=([First name] & " " & [Last name] & Chr(13) & Chr(10)) & ([Address 1]+Chr(13)+Chr(10)) & ([Address 2]+Chr(13)+Chr(10)) & ([Address 3]+Chr(13)+Chr(10)) & ([Town]+Chr(13)+Chr(10)) & [Postal code]

RDH
Go to the top of the page
 
Gordon
post May 30 2004, 11:14 AM
Post#8



Posts: 9
Joined: 28-May 04
From: Edinburgh, Scotland


Thank you, Ricky....that worked perfectly.....
ind Regards
Gordon
Go to the top of the page
 
R. Hicks
post May 30 2004, 11:16 AM
Post#9


UA Forum Administrator
Posts: 40,467
Joined: 8-February 00
From: Birmingham, Alabama USA


Great ... You are Welcome ... smile.gif
DH
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    13th December 2017 - 02:12 AM