Formating a querie

  • Thread starter Thread starter Rodolfo Fontes
  • Start date Start date
R

Rodolfo Fontes

Hi group,

Why does sometimes a querie return a formated value?
I have 2 fields on 2 tables and this fields are formated as numbers, but,
while making a querie, it's returned as currency.
How can i avoid doing it?

Thanks,
Rodolfo Fontes
 
Hi group,

Why does sometimes a querie return a formated value?
I have 2 fields on 2 tables and this fields are formated as numbers, but,
while making a querie, it's returned as currency.
How can i avoid doing it?

Thanks,
Rodolfo Fontes
Click to expand...

Please post the SQL view of the query. You usually need to do an extra
step to get a format - I'm not sure why it should be doing so!

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top