Hello Dear All,
I have a multi-user database where each user has its own perimeter (Team).
I am tryin to run a select statement that runs on several times based on the teams assigned for the user.
Here is the select statement:
After that, I would like to run another query based on the results found before (Which means teamname and the corresponding selected sum and type).
Here are the query parameters:
I hope you could help me guys,
Thank you in advance,
I have a multi-user database where each user has its own perimeter (Team).
I am tryin to run a select statement that runs on several times based on the teams assigned for the user.
Here is the select statement:
Code:
OpSQL = " SELECT tbl_temp.type, sum(tbl_temp.value) FROM tbl_temp WHERE tbl_temp.gFilter<=" & Me.cboOpening.Column(0) & " AND tbl_temp.teamName='" & Me.lboTeamName.Value & "' GROUP BY tbl_tempGraph.typeActual ORDER BY tbl_tempGraph.typeActual ASC "
After that, I would like to run another query based on the results found before (Which means teamname and the corresponding selected sum and type).
Here are the query parameters:
Code:
Set Qdf = db.QueryDefs("rupd_Temp")
With Qdf
.Parameters("var1") = 'Sum
.Parameters("var2") = Me.cboOpening.Column(0)
.Parameters("var3") = 'Team
.Parameters("var4") = 'This is the type
.Parameters("var5") = TempVars!struserid
.Execute
I hope you could help me guys,
Thank you in advance,
Last edited: