I've occasionally had weirdness like that on just one record when someone has done a little copy and paste from an excel file or something. The form shows a little square at the end but the table doesn't. The data is funky and I couldn't ever seem to manipulate it other than just delete that particular record.
Liz Ravenwood
Database Developer / Programmer
Super First Class Products
B/E Aerospace
O: 1.520.239.4808
www.beaerospace.com
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of glcass58
Sent: Wednesday, February 29, 2012 2:17 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] leading or trailing spaces/characters??
I can't figure this out.
select id from table where id = "mc63" does not work
select id from table where id like "*mc63*" does
I tried Trim([id]) and Replace([id]," ","") but they did not help.
Any assistance would be greatly appreciated!
------------------------------------
Yahoo! Groups Links
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.
Tidak ada komentar:
Posting Komentar