A alfred67 Registered User. Local time Today, 07:19 Joined Jan 26, 2010 Messages 65 Feb 9, 2010 #1 total hold back: [construction hold back amount]+[guarantee hold back amount]?? Construction hold back amount =10 Guarantee hold back amount =3 Should give me 13 but it gives me 103 Help?? Alfred67
total hold back: [construction hold back amount]+[guarantee hold back amount]?? Construction hold back amount =10 Guarantee hold back amount =3 Should give me 13 but it gives me 103 Help?? Alfred67
rainman89 I cant find the any key.. Local time Today, 07:19 Joined Feb 12, 2007 Messages 3,013 Feb 9, 2010 #2 you are doing a text concatination.. you need to convert them to numbers first try val( [construction hold back amount]) +val ([guarantee hold back amount])
you are doing a text concatination.. you need to convert them to numbers first try val( [construction hold back amount]) +val ([guarantee hold back amount])
A alfred67 Registered User. Local time Today, 07:19 Joined Jan 26, 2010 Messages 65 Feb 9, 2010 #3 Thank you for the fast reply and it worked like a charm. You saved alot of grey hair Alfred67
rainman89 I cant find the any key.. Local time Today, 07:19 Joined Feb 12, 2007 Messages 3,013 Feb 9, 2010 #4 Glad you got it sorted out
SOS Registered Lunatic Local time Today, 04:19 Joined Aug 27, 2008 Messages 3,512 Feb 9, 2010 #5 A good reason to NOT store numerical values as text in the table.
