Welcome to VBForums

At the moment we haven't got enough information to be able to help - the kind of thing we need are the first 2 bullet points of Before you post..., the SQL statement you are running, and the data type of the field(s) that are returned by it (especially the one that is giving you problems).