Got an access database that a client uses to run reports from. We take the data from a MySQL database.. well we updated it this month and now one of the queries is failing for "data type mismatch in query expression".
It seems to fail on this: where (((nwuc(wuc)) = "1")) I just inherited this db and don't know access, but the n function is some type of eval function? I only have two tables that have the column wuc and they are exactly the same. No db changes were made so I don't know why it fails. Can anyone explain this n worksheet function to me, or give me the sql equivalent? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=5 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=5 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
