Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old April 28th, 2014, 02:23 AM
Registered User
 
Join Date: Apr 2014
Posts: 4
Thanks: 1
Thanked 0 Times in 0 Posts
Smile access 2010 report - data alignment in vertical

Hi gurus!

I have created a report in Access2010 and seems like the data alignment in report view is not what I want. My current view is like the pix in the following URL. Is it possible to have those tasks shown just below the headers (months)?

I tried to merge those cells for display or even those criteria like Does Not Equal blank but both are not what I want. Or should I better modify my query? Thanks in advance!!!



http://i.stack.imgur.com/XEM3u.jpg

<table border=1 witdh=500>
<tr>
<td width=100>Oct-2013</td>
<td width=100>Nov-2013</td>
<td width=100>Dec-2013</td>
<td width=100>Jan-2014</td>
<td width=100>Feb-2014</td>
</tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>01-BR/SR</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>02-URS</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>03-URS Signoff</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>06-FRS</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>07-Sys DEV</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>

<td>&nbsp;</td>
<td>08-PreTest</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>

<td>&nbsp;</td>
<td>09-UAT</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>12-Implementation</td>
</tr>
</table>

Last edited by knvbhk; April 28th, 2014 at 02:27 AM.. Reason: add html codes
 
Old May 7th, 2014, 02:10 PM
Authorized User
 
Join Date: Oct 2010
Posts: 64
Thanks: 0
Thanked 16 Times in 16 Posts
Default

Hi,

Is this the sort of layout you envisage:

Code:
Oct-2013		Nov-2013	Dec-2013	Jan-2014	Feb-2014
01-BR/SR	 			08-PreTest	 		12-Implementation
02-URS		 			09-UAT	 	 
03-URS Signoff	 	 	 	 
06-FRS	 	 	 	 
07-Sys DEV	 
I'm sure it's possible but I'd need an understanding of your table structure in order to guide with the SQL to extract the data correctly. You'll need to use a crosstab query that I'm sure of, as well as a key of the task number within that month. For example all first tasks are reported on first line etc. So, you'll need a query to generate this task position for each task. Once you let me know your table structures, I'll try to replicate what you're trying to achieve. HTH.
The Following User Says Thank You to malcolmdixon For This Useful Post:
knvbhk (May 9th, 2014)
 
Old May 9th, 2014, 04:43 AM
Registered User
 
Join Date: Apr 2014
Posts: 4
Thanks: 1
Thanked 0 Times in 0 Posts
Default

Hi Malcolm,

The layout is really what I want. There are two tables for such layout.

tables involved:
Tasks: TaskTitle, ProjectID, StartDate, DueDate
Projects: ProjectName, ProjectID
key: ProjectID (number)

For the query I am using, it is a bit "weird" and I wonder that is the main reason I can't get those tasks aligned to top. However, some of the tasks may have StartDate and/or DueDate empty.

Quote:
TRANSFORM [Tasks].[TaskTitle] AS 值
SELECT [Projects].[ProjectName]
FROM Projects LEFT JOIN Tasks ON [Projects].[ID] =[Tasks].[ProjectID]
WHERE [Projects].[ProjectName] = 'CTI Phase 2'
GROUP BY [Projects].[ProjectName], [Tasks].[TaskTitle]
ORDER BY [Projects].[ProjectName]
PIVOT Format ([Tasks].[StartDate], "MMM-YYYY");
Note: 值 is the character for value as I am using a Chinese version.

A big thank you in advance for your help since I seldom work with MS Access!!!!!

Last edited by knvbhk; May 9th, 2014 at 04:57 AM..





Similar Threads
Thread Thread Starter Forum Replies Last Post
transfer excel data in a range to Access 2010 smaNavg Excel VBA 0 May 3rd, 2013 09:47 AM
Populating data from MS Access 2010 to VB.net 2010 treeview nodes jayqdomingo .NET 4 and Visual Studio 2010 General Discussions 0 March 19th, 2013 12:12 PM
VB 2010 data from txtbox to Access 2007 table ByteWorker BOOK: Visual Basic 2010 Programmer's Reference 1 November 30th, 2011 11:33 AM
css table vertical alignment/positioning tkidsol CSS Cascading Style Sheets 1 October 30th, 2010 01:38 AM
Vertical alignment for a formula Slon Crystal Reports 1 April 16th, 2006 01:46 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.