String Query works in one database but not in other 1

[PJ2000]

I have a database that I created some time ago in MS Access97.&nbsp;&nbsp;When I attempt to run the following query on it it gives me an error.&nbsp;&nbsp;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?&nbsp;&nbsp;The helpfile indicates that ANY numeric format can be converted by using the str function. <br><br><br>SELECT numbers.testNumLong,<br>&nbsp;Str([testNumlong]) AS textlong,<br>&nbsp;numbers.testNUmDbl,<br>&nbsp;Str([testNumDbl]) AS textDbl<br>FROM numbers;<br>

 

[Guest_imported]

in the old database you need to refresh your references. open a module under tools references click on a box that was not selected hit the OK button select tools,references again and uncheck the box you just checked hit ok. Should do the trick

 

[PJ2000]

mmmmKay...&nbsp;&nbsp;it worked, but why?<br>What do the module references have to do with STR fucntionality?

 

[Guest_imported]

There is a FAQ on this Forum that explains it a little<br><br><A HREF="

http://www.tek-tips.com/gfaq.cfm/lev2/4/lev3/27/spid/181#107"

TARGET="_new">

http://www.tek-tips.com/gfaq.cfm/lev2/4/lev3/27/spid/181#107</A><br><br>There

is also more detailed info on MS Knowledge base but I don't have the reference readily avaliable to give you right now.