--------------------
| From: (e-mail address removed) (Charles D Clayton Jr)
| Newsgroups: microsoft.public.access.reports
| Subject: Re: Report Query Quandry
| Date: 15 Jan 2004 06:15:47 -0800
| Organization:
http://groups.google.com
| Lines: 89
| Message-ID: <
[email protected]>
| References: <
[email protected]>
<
[email protected]>
| NNTP-Posting-Host: 65.209.72.178
| Content-Type: text/plain; charset=ISO-8859-1
| Content-Transfer-Encoding: 8bit
| X-Trace: posting.google.com 1074176148 11629 127.0.0.1 (15 Jan 2004
14:15:48 GMT)
| X-Complaints-To: (e-mail address removed)
| NNTP-Posting-Date: Thu, 15 Jan 2004 14:15:48 +0000 (UTC)
| Path:
cpmsftngxa07.phx.gbl!cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.su
l.t-online.de!t-online.de!diablo.theplanet.net!news.maxwell.syr.edu!postnews
1.google.com!not-for-mail
| Xref: cpmsftngxa07.phx.gbl microsoft.public.access.reports:127945
| X-Tomcat-NG: microsoft.public.access.reports
|
| I did set the CanGrow/CanShrink properties to yes but that did
| nothing. The text box is the only control in the detail section.
|
| Interesting enough, after I sent the email I figured out Fred's answer
| but it still did not work. I tried several variations to see what
| changed but the spaces were never eliminated.
|
| Here is some test data for you to play with:
| Spool Service Rack by Racked
| BDD-2-AF-K-9095-1-1-5 AF 12/13/2003 12/19/2003
| BDD-2-AF-K-9095-1-1-1 AF 12/6/2003
| BDD-2-AF-K-9094-1-1-1 AF 12/13/2003 12/12/2003
| BDD-2-AF-K-9094-1-1-2 AF 12/13/2003
| BDD-2-AF-K-9095-1-1-2 AF 12/13/2003
| BDD-2-AF-K-9095-1-1-3 AF 12/6/2003 12/12/2003
| BDD-2-AF-K-9095-1-1-4 AF 12/13/2003 12/12/2003
| BPD-4-AV-A-5040-1-1-2 AV 11/15/2003 11/5/2003
| BDD-2-AV-A-5011-1-1-1 AV 12/6/2003
| BDD-10-AV-A-5012-1-1-3 AV 11/28/2003 12/3/2003
|
|
| The query SQL look like this:
| SELECT Spools.Spool, Spools.Service, Spools.[Rack by], Spools.Racked
| FROM Spools
| WHERE (((Spools.[Rack by])<Now()));
|
| Maybe this information will help produce a solution.
|
| Thanks for your time,
|
| Charles D Clayton Jr
|
|
| (e-mail address removed) ("Petrucci2000") wrote in message
|
| > Have you considered using the "Can Grow" and "Can Shrink" properties?
| >
| > See:
| > ACC2000: Eliminating White Space in Reports with CanShrink & Code
| >
http://support.microsoft.com/default.aspx?scid=kb;en-us;210589
| >
| > ACC2000: Concatenating Fields in a Text Box to Remove Blank Lines
| >
http://support.microsoft.com/default.aspx?scid=kb;en-us;209653
| >
| > I hope this helps! If you have additional questions on this topic,
please
| > respond back to this posting.
| >
| >
| > Regards,
| >
| > Eric Butts
| > Microsoft Access Support
| >
| >
| >
| >On 14 Jan 2004 14:25:29 -0800, (e-mail address removed)
| (Charles
| >D Clayton Jr) wrote:
| >
| >I have a report that is based on a query. There are four fields:
| >Spool (string), Service (string), Racked (date), Rackby (date). Each
| >spool is grouped by Service in the report and in the detail section
| of
| >the report I want to show each spool that should have been racked but
| >was not. To accomplish this I put the criteria of Now() under Rack
| by
| >in the query. In the report I create a text box and put this as its
| >control source "IIF([Racked] is Null, [Spool],"") which will list all
| >the spools that have not been racked. This works find. However, a
| >problem arises for those spools that have been racked, the report
| will
| >leave a blank space for them. Is there some way to eliminate this?
| >There are around 60 Services that I am grouping on with 2000 spools.
| I
| >using A2K.
| >
| >Thanks,
| >
| >Charles D Clayton Jr
|
| >Charles,
| >Set the control's control source to:
| >=IIf(IsNull([Racked]),[Spool],"")
| >Set the control's CanShrink property to Yes.
| >CanShrink will only work if there is no other control on the same
| >line.
| >
| >--
| >Fred
|
I'm not quite sure I follow you. You state that there is only one textbox
control in the detail section. So is Report like the following
TextBox
ControlSource: Spool & Service & RackBy & Racked
Or do you have each field (Spool, Service, RackBy, & Racked) in separate
textbox controls?
If you results are this
Spool Service Rack by Racked
| BDD-2-AF-K-9095-1-1-5 AF 12/13/2003 12/19/2003
| BDD-2-AF-K-9095-1-1-1 AF 12/6/2003
| BDD-2-AF-K-9094-1-1-1 AF 12/13/2003 12/12/2003
| BDD-2-AF-K-9094-1-1-2 AF 12/13/2003
| BDD-2-AF-K-9095-1-1-2 AF 12/13/2003
| BDD-2-AF-K-9095-1-1-3 AF 12/6/2003 12/12/2003
And you are trying to get this
Spool Service Rack by Racked
| BDD-2-AF-K-9095-1-1-5 AF 12/13/2003 12/19/2003
| BDD-2-AF-K-9094-1-1-1 AF 12/13/2003 12/12/2003
| BDD-2-AF-K-9095-1-1-3 AF 12/6/2003 12/12/2003
Then you will need to use the Control Source Charles recommended on each
textbox control
I hope this helps! If you have additional questions on this topic, please
respond back to this posting.
Regards,
Eric Butts
Microsoft Access Support
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<
http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <
http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."
