J
Jeff
Sorry for the repost but once someone answers a post most
people stop looking at it. Even if the answer is wrong...
I should have prefaced my post by stating my applicaiton
is an ADP with a SQL 2000 back end.
-- ORIGIONAL POST ----------------------
I have a report that is called from a form. On the open
event of the report I set the report's data source as
follows:
Dim stSQL As String
stSQL = Forms![frmMyForm].[txtSQL]
Me.RecordSource = stSQL
The SQL string looks like:
SELECT * FROM vOOWList WHERE GroupID='S100' AND
(('8/6/2004' BETWEEN StartDt and EndDt)
OR ('8/6/2004' > StartDt AND EndDt IS NULL))
The wierd thing is, my report displays records as if
the "OR ('8/6/2004' > StartDt AND EndDt IS NULL))" in the
SQL string wasn't there.
To make matters even more strange, if I were to switch the
report to design view and then back to print preview all
the data would be displayed.
Any ideas as to what the problem might be would be greatly
appreciated.
people stop looking at it. Even if the answer is wrong...
I should have prefaced my post by stating my applicaiton
is an ADP with a SQL 2000 back end.
-- ORIGIONAL POST ----------------------
I have a report that is called from a form. On the open
event of the report I set the report's data source as
follows:
Dim stSQL As String
stSQL = Forms![frmMyForm].[txtSQL]
Me.RecordSource = stSQL
The SQL string looks like:
SELECT * FROM vOOWList WHERE GroupID='S100' AND
(('8/6/2004' BETWEEN StartDt and EndDt)
OR ('8/6/2004' > StartDt AND EndDt IS NULL))
The wierd thing is, my report displays records as if
the "OR ('8/6/2004' > StartDt AND EndDt IS NULL))" in the
SQL string wasn't there.
To make matters even more strange, if I were to switch the
report to design view and then back to print preview all
the data would be displayed.
Any ideas as to what the problem might be would be greatly
appreciated.