Get value of Session in Record Selection

[Alison Givens]

Hi,

I want two Session values in my record selection query. The come out of an
other webform.
When I do it hardcoded, it works.
How dow I do this with the Session values?

Hardcoded:
Dim strSQL As String
strSQL = "ToText({AlleProductieveProjectUrenVerdeeldOverFilialen.Periode})

= '200409'"

strSQL = strSQL & " AND
ToText({AlleProductieveProjectUrenVerdeeldOverFilialen.Periode}) <= '200510'
myReport.RecordSelectionFormula = strSQL

What I want:
the values '200409' should be the Session.Item("BeginPeriode")
the value '200510' should be the Session.Item("EindPeriode")

Kind regards,
Alison

 

[S.M. Altaf [MVP]]

--------------------------------------------------------------------------------
All that glitters has a high refractive index.
www.mendhak.com

 

[S.M. Altaf [MVP]]

strSQL = "ToText({AlleProductieveProjectUrenVerdeeldOverFilialen.Periode})

 

[Alison Givens]

Thanks very much. That did the trick.

strSQL = "ToText({AlleProductieveProjectUrenVerdeeldOverFilialen.Periode})