SQL Statement

[jimb0ne]

Hi Folks,
I'm just having a little problem with a recordset object I'm trying to create. I have the following code.

Set TempRS = TempDB.OpenRecordset("SELECT EmployeeApp.* FROM EmployeeApp WHERE EmployeeApp." & WhereString, dbOpenSnapshot)

my problem is that the recordset which is returned from this only contains 1 record. Even if the WhereString used int he statement is true for many records, only once record shows up in the TempRS object. Any ideas would be much appreciated.

Thanks,
James

Better off dead, a smile on my lips and a hole in my head.

 

[PaulBricker]

What the WhereString look like?

Paul

 

[jimb0ne]

something to the effect of "JobType = "Term""

 

[PaulBricker]

Well, if I was trying to debug this, I would send the SQL string to the debug window and look at what it returns.

Dim strSQL
strSQL = ("SELECT EmployeeApp.* FROM EmployeeApp WHERE EmployeeApp." & WhereString

Debug.Print strSQL

See if that tells you anything.

Paul