I've successfully upsized an access 2000 db to SQL Server 6.5 using SQL Server 7.0 import export wizard, but when I output the data now the integer fields are now of the format: 1.00 2.00 2,345.00 instead of: 1 2 2345 Any integer fields is like this now including index's and primary keys. So this really screws up some relationships because 1 isn't 1 anymore it's 1.00. I realize I could use val() but I'd have to go through alot of code to do that. Anyone have any ideas what I did wrong or how I could fix what I've got. Thanks. Ric Smith h_o_l_o_g_r_a_p_h_i_c 103 Meridian St. Tallahassee, Florida 32301 www.holographic.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
