select data from table

[ersatz]

Hi,
I take data from a server and I put in my table1.
All it's ok.
After that, I want to take data from table1,make some calculus and put data in table2:
SQL0 = "SELECT * from DECEMBRE where Date=#" & d1 & "# and Time=#" & d2 & "#"
Set r0 = db1.OpenRecordset(SQL0, dbOpenDynaset)
v = r0.Fields("field1&quot

My programme stop here and I have this error:
Run-time error '3021'
No current record.
v=empty
But if I go in table1 I find this record.
Can somebody help me, please?
Regards,
ersatz

 

[kevinclark]

Hi ersatz


In your SQL you are using the pound sign which indicates to me that the fields in the database are defined as date fields ?

Are you sure that D1 and D2 are also defined as Date values

Example if maybe try something like the following

d1 = Format(CDate(d1,"MM/DD/YYY&quot)
d2 = Format(CDate(d2,"Short Time&quot)

SQL0 = "SELECT * from DECEMBRE where Date=#" & d1 & "# and Time=#" & d2 & "#"

Hope it helps