Access Statement Error

[abdullahsikandar]

Hi,



I am trying to match two columns in this statement:

Set Rs1 = CurrentDb.OpenRecordset("select * from [Tracker] where [Fname] and [Lname] = '" & Rs.Fields("first name") & "'" & Rs.Fields("last name") & dbOpenDynaset)

But it always gives me an error i don`t know where i am lacking right now. Can you all please help me out and let me know what i did wrong in it?

or if it can be written in any other way....

I want my Fname= first name
Lname=Last Name

Please help me.

[June7]

Try:

Set Rs1 = CurrentDb.OpenRecordset("select * from [Tracker] where [Fname] & [Lname] = '" & Rs.Fields("first name") & Rs.Fields("last name") & "';", dbOpenDynaset)

[abdullahsikandar]

Hi,

Its working but not completely what i wanted the data which i am matching is already in the database i mean Fname and Lname but when i ran this query it said:

Run-Time Error '3625'

Item cannot be found in the collection corresponding to the requested name or ordinal

Thanks for your reply... please help me.

[June7]

I don't know your data, can only use what you provide.

What table is Rs set to? Where are the fields "first name" and "last name"?

[abdullahsikandar]

Well, actually i got it your query works : Thanks a lot June7 .... u r the best