Hi all,
I'm trying to use a WHERE condition that holds two conditions
I succeeded to execute the first condition (teamName) but when I add the second one it doesn't work.
What I want to do is to add this condition to the same code :
The main code :
Thanks in advance
I'm trying to use a WHERE condition that holds two conditions
I succeeded to execute the first condition (teamName) but when I add the second one it doesn't work.
What I want to do is to add this condition to the same code :
Code:
[rsel_frm_viewInitiatives].monthActual='" & Me.cboFilterPeriod.Column(0)
The main code :
Code:
fsql = "SELECT [rsel_frm_viewInitiatives].[idInitiative] AS ID, [rsel_frm_viewInitiatives].[initiativeName] AS Name, [rsel_frm_viewInitiatives].[initiativeType] AS Type, [rsel_frm_viewInitiatives].[teamName] AS Team, [rsel_frm_viewInitiatives].[yearInitialVal] AS [Year], [rsel_frm_viewInitiatives].[initialValInt] AS [INT], [rsel_frm_viewInitiatives].[initialValExt] AS EXT, [rsel_frm_viewInitiatives].[initialValOth] AS OTH, [rsel_frm_viewInitiatives].[monthActual] AS Period, [rsel_frm_viewInitiatives].[typeActual] AS [FTE Type], [rsel_frm_viewInitiatives].[actualFTE] AS Actual, [rsel_frm_viewInitiatives].[remainFTE] AS Remain, [rsel_frm_viewInitiatives].[startMonth] AS [Start Month], [rsel_frm_viewInitiatives].[endMonth] AS [End Month]" & vbCrLf & _
" FROM [rsel_frm_viewInitiatives]" & vbCrLf & _
" WHERE [rsel_frm_viewInitiatives].teamName='" & Me.cboFilterTeam.Column(0) & "'" & vbCrLf & _
" ORDER BY [rsel_frm_viewInitiatives].[monthActual];"
Thanks in advance