[AccessD] A2K: Not Adding up

Andrew you da man
many thanks

Darren

----- Original Message ----- 
From: "Haslett, Andrew" <andrew.haslett at ilc.gov.au>
To: "'Access Developers discussion and problem solving'" <accessd at databaseadvisors.com>
Sent: Thursday, August 14, 2003 3:51 PM
Subject: RE: [AccessD] A2K: Not Adding up


> Darren, try
> 
> CInt(MyCombo.Column(0)) + CInt(MyCombo.Column(1))
> 
> Cheers,
> Andrew
> 
> -----Original Message-----
> From: Darren DICK [mailto:d.dick at uws.edu.au]
> Sent: Thursday, 14 August 2003 2:45 PM
> To: AccessD List
> Subject: [AccessD] A2K: Not Adding up
> 
> 
> Hello all
> I have a table (tblAwards) that has 2 fields
> 1st called ElectiveHours data type = number/Long Integer (Say it has a value
> of 5)
> 2nd called CompulsoryHours data type = number/Long Integer (Say it has a
> value of 100)
> 
> I have a form with a combo bound to tblAwards
> So MyCombo.Column(0) is bound to ElectiveHours and MyCombo.Column(1) is
> bound to CompulsoryHours.
> 
> I have a control on the form that has the following as its ControSource
> MyCombo.Column(0) + MyCombo.Column(1). So 5 + 100 should = 105
> 
> But I keep getting the concatenated answer version 5100
> 
> What am I doing wrong?
> 
> Many thanks in advance
> 
> Darren
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> IMPORTANT - PLEASE READ ******************** 
> This email and any files transmitted with it are confidential and may 
> contain information protected by law from disclosure. 
> If you have received this message in error, please notify the sender 
> immediately and delete this email from your system. 
> No warranty is given that this email or files, if attached to this 
> email, are free from computer viruses or other defects. They 
> are provided on the basis the user assumes all responsibility for 
> loss, damage or consequence resulting directly or indirectly from 
> their use, whether caused by the negligence of the sender or not.
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com