Mike- Not Like "*[*]*"
John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" http://www.viescas.com/ -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Monday, January 16, 2006 2:32 PM To: [email protected] Subject: [ms_access] Using * as a literal in a query Hi All, I have a table which contains * as a literal character. I am trying to query against this table for a combo box, but I don't want the * to show up in the combobox lists (at least not for this application). I've tried entering my criteria in the query as follows: Not like ""*"" Not Like ''*'' All I'm getting is an error message stating the query is too complex or it is not formatted properly. As usual, any help would be greatly appreciated! ================================== Mike Bisson Manager of IT & Logistics Carthuplas, Inc. V: 207-985-4972 x658 F: 207-985-2105 [EMAIL PROTECTED] http://www.carthuplas.com Yahoo! Groups Links Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
