FindLast MUltiple Fields 1

[Trob70]

I have a recordset open (dynaset)

Dim ssql As String
ssql = "[RDate] = '" & MDate & "'"
This works---

But i need to find using multiple fields this does not work..
ssql = "[RDate] = '" & MDate & "'" & "," & "[RCard] = '" & Card & "'"

rstwo.FindLast ssql

LTT = rstwo.rtime

Appreciate any help with correcting this syntex to correct the problem

Regards Trob70

 

[Andrzejek]

How does your ssql should look like if you would just hardcode the values in there?

How about:
[tt]
ssql = "[RDate] = '" & MDate & "' AND [RCard] = '" & Card & "'"
[/tt]
If MDate and Card are variables as text/strings

Have fun.

---- Andy

 

[Trob70]

Andrzejek

Thanks for your help.... i can see that the ' must be in the correct place !!.. all ok now Thanks


Regards Trob 70