John Colby
jcolby at colbyconsulting.com
Wed Oct 29 19:43:08 CST 2003
>In Access, try using a CINT(Frm_GroupVisible) etc to force it to an Int before doing the "OR" comparison. Tried that, no joy. John W. Colby www.colbyconsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Stuart McLachlan Sent: Wednesday, October 29, 2003 8:24 PM To: John Colby; accessd at databaseadvisors.com Subject: RE: [AccessD] brain farts On 29 Oct 2003 at 17:48, John Colby wrote: > I tried this and it's giving me errors. This is the actual built up SQL > statement. > > UPDATE MsysForms SET [FRM_GroupOpen] = [FRM_GroupOpen] ~ 4, > [FRM_GroupVisible] = [FRM_GroupVisible] ~ 4, [FRM_GroupEdit] = > [FRM_GroupEdit] ~ 4, [FRM_GroupAddRec] = [FRM_GroupAddRec] ~ 4, > [FRM_GroupDelRec] = [FRM_GroupDelRec] ~ 4 WHERE (((MsysForms.FRM_ID) In > (28,34,33,35,32,29,31,30))); > > Is that as you understand it to be used? Likewise it didn't like the > vertical bar. > I posted a second one, a couple of seconds later which for some reason didn't make it to the list. In that I said "Sorry, I thought I was still scanning the dba-SQL list". In Access, try using a CINT(Frm_GroupVisible) etc to force it to an Int before doing the "OR" comparison. -- Stuart McLachlan Lexacorp Ltd Application Development, IT Consultancy http://www.lexacorp.com.pg _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com