already tried that.. figured it out.. there was a record that was imported where wuc was null
----- Original Message ----- From: "Ben Braver" <[EMAIL PROTECTED]> To: "CF-Community" <[EMAIL PROTECTED]> Sent: Tuesday, February 11, 2003 5:47 PM Subject: any Access Knowledge out there? > if you have a data type mismatch, it may be that the function is operating on a numeric field, and "1" in quotes specifies a string literal. > > Try substituting just =1 without the quotes. > HTH. > -Ben > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=5 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=5 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
