Click here to Skip to main content
15,120,459 members
Home / Discussions / Database
   

Database

 
GeneralRe: SQL Server 2012 Agent Job & stored procedure issue URGENT Pin
Seuss28-May-14 0:01
MemberSeuss28-May-14 0:01 
QuestionHow to select the records who are completed exactly years comparing with joining date and todays date Pin
ven75326-May-14 7:09
Memberven75326-May-14 7:09 
AnswerRe: How to select the records who are completed exactly years comparing with joining date and todays date Pin
jschell26-May-14 9:11
Memberjschell26-May-14 9:11 
GeneralRe: How to select the records who are completed exactly years comparing with joining date and todays date Pin
ven75326-May-14 22:27
Memberven75326-May-14 22:27 
AnswerRe: How to select the records who are completed exactly years comparing with joining date and todays date Pin
Mycroft Holmes26-May-14 13:52
professionalMycroft Holmes26-May-14 13:52 
GeneralRe: How to select the records who are completed exactly years comparing with joining date and todays date Pin
Sunasara Imdadhusen26-May-14 22:30
professionalSunasara Imdadhusen26-May-14 22:30 
AnswerRe: How to select the records who are completed exactly years comparing with joining date and todays date Pin
NitinDhapte16-Jun-14 3:18
MemberNitinDhapte16-Jun-14 3:18 
Questionaccess2010 pivot table Pin
hakata21-May-14 6:59
Memberhakata21-May-14 6:59 
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? 


my current tabular view

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. A big thank you in advance for your help since I seldom work with MS Access. Thanks in advance!!!

SQL
TRANSFORM [Tasks].[TaskTitle] AS [the value]
SELECT [Projects].[ProjectName]
FROM Projects LEFT JOIN Tasks ON [Projects].[ID] =[Tasks].[ProjectID]
GROUP BY [Projects].[ProjectName], [Tasks].[TaskTitle]
ORDER BY [Projects].[ProjectName]
PIVOT Format ([Tasks].[StartDate], "MMM-YYYY"); 

QuestionAbnormal Behavior of SQL Server 2008 Enterprise Store Procedure Pin
jugnu_ad20-May-14 21:52
Memberjugnu_ad20-May-14 21:52 
AnswerRe: Abnormal Behavior of SQL Server 2008 Enterprise Store Procedure Pin
Richard MacCutchan20-May-14 22:45
mveRichard MacCutchan20-May-14 22:45 
GeneralRe: Abnormal Behavior of SQL Server 2008 Enterprise Store Procedure Pin
jugnu_ad20-May-14 22:47
Memberjugnu_ad20-May-14 22:47 
GeneralRe: Abnormal Behavior of SQL Server 2008 Enterprise Store Procedure Pin
Richard MacCutchan20-May-14 23:26
mveRichard MacCutchan20-May-14 23:26 
AnswerRe: Abnormal Behavior of SQL Server 2008 Enterprise Store Procedure Pin
Tim Carmichael21-May-14 2:35
MemberTim Carmichael21-May-14 2:35 
GeneralRe: Abnormal Behavior of SQL Server 2008 Enterprise Store Procedure Pin
jugnu_ad21-May-14 2:45
Memberjugnu_ad21-May-14 2:45 
GeneralRe: Abnormal Behavior of SQL Server 2008 Enterprise Store Procedure Pin
Simon_Whale21-May-14 2:50
professionalSimon_Whale21-May-14 2:50 
GeneralRe: Abnormal Behavior of SQL Server 2008 Enterprise Store Procedure Pin
jugnu_ad21-May-14 2:56
Memberjugnu_ad21-May-14 2:56 
AnswerRe: Abnormal Behavior of SQL Server 2008 Enterprise Store Procedure Pin
Eddy Vluggen21-May-14 8:52
professionalEddy Vluggen21-May-14 8:52 
GeneralRe: Abnormal Behavior of SQL Server 2008 Enterprise Store Procedure Pin
Mycroft Holmes21-May-14 13:51
professionalMycroft Holmes21-May-14 13:51 
GeneralRe: Abnormal Behavior of SQL Server 2008 Enterprise Store Procedure Pin
Tim Carmichael22-May-14 4:41
MemberTim Carmichael22-May-14 4:41 
GeneralRe: Abnormal Behavior of SQL Server 2008 Enterprise Store Procedure Pin
Eddy Vluggen22-May-14 6:10
professionalEddy Vluggen22-May-14 6:10 
AnswerRe: Abnormal Behavior of SQL Server 2008 Enterprise Store Procedure Pin
Shameel22-May-14 4:05
professionalShameel22-May-14 4:05 
Questionhow to updat a column from start point Pin
mhd.sbt20-May-14 1:59
Membermhd.sbt20-May-14 1:59 
AnswerRe: how to updat a column from start point Pin
Shameel20-May-14 2:19
professionalShameel20-May-14 2:19 
GeneralRe: how to updat a column from start point Pin
mhd.sbt20-May-14 2:35
Membermhd.sbt20-May-14 2:35 
GeneralRe: how to updat a column from start point Pin
thatraja20-May-14 3:14
professionalthatraja20-May-14 3:14 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.