Format Field in SQL

[jsic1210]

This question is rather trivial, as it can be done in design view. If I'm working strictly from SQL, is there a way to format a field as currency, standard number, etc. without using the format() function? Basically the equivalent of setting the format in the property sheet in design view, without going to design view.

Thanks!

 

[plog]

Your requirements are kind of disjointed: You want to do it just in SQL, without the Format function but you want to set the format property. In short, no.

SQL can only act on your data, it can't set a format property, that would be VBA's job. SQL however, can use the Format() function. So, I'm a little lost.

What's wrong with this SQL:

SELECT Format([NumberField], "Currency") AS CurrencyAmount FROM YourTableName;

Design View is to SQL as Dreamweaver is to HTML--its just a GUI to help people write underlying code.