I have a database that I created some time ago in MS Access97. When I attempt to run the following query on it it gives me an error. When creating and running the same query in a NEW database - it gets no Errors. Does anyone know of a database wide setting or property that can effect the usage of str (string) conversion? The helpfile indicates that ANY numeric format can be converted by using the str function. <br><br><br>SELECT numbers.testNumLong,<br> Str([testNumlong]) AS textlong,<br> numbers.testNUmDbl,<br> Str([testNumDbl]) AS textDbl<br>FROM numbers;<br>