Converting Scientific notation in a Query

[wuhsean22]

Hi all, I imported a table which contains a column of numbers in scientific notation.

Is there a formula i can create in query design that will convert the number into either a number or text?

[Robeen]

Check this page out:
http://office.microsoft.com/en-us/ac...001229018.aspx

What you might try is to Create a new field in your Query Design and type in something like this [to convert it to a string]:

NewFieldName: CStr(YourFieldName)
OR
NewFieldName: CDbl(YourFieldName)

OR . . .
Try clicking in the field in Design Mode - and then open the Property Sheet for the field - and click in the Format row and drop the arrow down and pick one of the options there [Currency, Percent . . .].

Hope this helps!

[wuhsean22]

awesome, this should work. Thanks Robeen!