Data Type

[MTSPEER]

Hello,



just a quick dumb question guys, I have a data type that is a Number in my one table which is called Table1 and the format is 0.00. The field is called Num1. I want to update this field onto Table2 field Num2. But this data type of Num2 is Text. When i create an update query and update the Num2 field, the result shows just 0, not 0.00. I thought the text data type should just copy whatever the number field is?

[June7]

Displaying the .00 is a format setting in the table. It is not actually in the data. If you want to save the .00 then use Format() function on the data. Why save number data to text field? Why duplicate data?

[ItsMe]

It is a formatting thing. Apparently, zeros are not displayed by default. Maybe the format function will give you what you need. If you include your number type the result of the format function will be text and the formatting will be retained.

[MTSPEER]

Okay so make it Format([Num1],0.00)?

[ItsMe]

That looks about right

You can add a comma for 1000 separator, etc
Format([Num1], #,000.00)

[June7]

Almost. Need quote marks.

Format([Num1], "0.00")

[MTSPEER]

Thanks guys!

[MTSPEER]

I didn't get to try it last night but I tried it today and it still doesn't work..it still shows it at 0

[MTSPEER]

Am I supposed to have the format for that field set to 0.00 also? but then when I try to update the other table and it's a text data type it shows it as 0

[ItsMe]

If Table2 field Num2 is of Data type Number it will convert a string to number type. If it is possible to do so, the text string will be cast to a number. Perhaps what you want to do is format your second table's Num2 field. I suggest putting the formatting in a query or, better yet, in a form. This way the formatting is employed only when absolutely necessary.

[MTSPEER]

I just made the query to update the text data type..it works. I just don't understand why it wouldn't transfer over to show it at 0.00

[ItsMe]

I am having difficulty understanding what you have tried and what is working for you. Why don't you explain what you did that is creating a question and post the relative code.