[AccessD] brain farts

Sorry about my last post.  I thought I was still scanning the Access-
SQL list messages :-(

Try  a CINT([MsysForms]![frm_GroupOpen] ) to force it to an integer. 

On 29 Oct 2003 at 14:11, John Colby wrote:

> Folks,
> 
> I'm trying to do boolean operations in a query.  I have a table with bit
> mapped fields such that the long integer has bits "on" or 1 in specific
> circumstances.  Now I want to OR in other numbers in SQL.  I have a SQL
> statement that looks like:
> 
> SELECT MsysForms.FRM_GroupOpen, ([MsysForms]![frm_GroupOpen] Or 1) AS NewVal
> FROM MsysForms;
> 
> regardless of the value contained in the field frm_GroupOpen, the NewVal is
> always -1 for an OR or an AND of any other value, and 0 for an XOR.
> 
> If I have a 4 in the field, 4 OR 1 should give me 5, but it is giving me -1.
> I believe it is "interpreting" it and saying it is true.  But why?
> 
> John W. Colby
> www.colbyconsulting.com
> 
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com

 
-- 
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software Development,System Support.