How to set a custom fields data type

[TheAceMan1]

Howdy All!

Have a custom field in a query that uses a function to return a number. I Wish to convert to currency.[blue] How do I set the data type[/blue] (can't find it in my library)?

I know I can use the type conversion function [blue]CCur[/blue], however, I expect faster running of the query if I can [blue]set the data type[/blue] . . .

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[softhemc]

I don't know what version of Access you are using, but in 2007, you can set the format on the fields property page in the query.

 

[TheAceMan1]

How are ya softhemc . . .

Formatting that way doesn't work in A2k that way. I'm looking for something thats [blue]Jet[/blue] specific.

Thanks for the input though!

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]