Yep. Thanks Graham. A deep breath helped.
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Thursday, February 19, 2015 3:55 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] RE: eyes gone bonkers
Hi Liz
Yes, that should work now. Before you were not correctly concatenating the parts of your string, so the quotes weren’t matching up.
Best wishes,
Graham
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Friday, 20 February 2015 11:46
To: 'MS_Access_Professionals@yahoogroups.com'
Subject: [MS_AccessPros] RE: eyes gone bonkers
Now I’ve got this:
strPFname = DLookup("FirstName", "LocalEmpsNSupers", "left('" & rs("FirstName") & "',4 = left('" & rs("SuperFname") & "',4) AND '" & rs("LastName") & "' = '" & rs("SuperLname") & "'")
Should I try it?
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Thursday, February 19, 2015 3:40 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] eyes gone bonkers
Help please with my dlookup with criteria from an exiting recordset. My eyes are bazonkers!
strPFname = DLookup("FirstName", "LocalEmpsNSupers", "left(rs("FirstName"),4 = left(rs("SuperFname"),4) AND rs("LastName") = rs("SuperLname")")
This is wrong, and I can’t think and see straight enough to put the quotes and parentheses in the right spots.
Anyone have clear eyes and a clear brain?
Respectfully,
Liz Ravenwood
Programmer / Analyst
B/E Aerospace | Super First Class Environments
1851 S Pantano Road | Tucson, Arizona 85710
Office +1.520.239.4808 |
beaerospace.com
Passion to Innovate. Power to Deliver
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
!
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Posted by: Liz Ravenwood <Liz_Ravenwood@beaerospace.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (4) |
Tidak ada komentar:
Posting Komentar