Formatting text derived from a query

[kkarren]

I have a text formatted field that reads 10.1 I need to chart the results of the query but not able to because it recognizes the 10.1 as text.  How can I format this box to read 10.1 as a number so I can chart it?

 

[DougP]

I guess your data is in a Table<br>1. Open the Table in Design view<br>2. Find the field which is &quot;Text&quot;<br>3. Click in the box and find Number (Click It)<br>4. Press &quot;F6&quot; key <br>5. In the &quot;Field size&quot; Pick &quot;Single&quot; <br>6. Click &quot;File&quot; menu<br>7. Click &quot;Save&quot;<br><br>That's it<br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.

 

[kkarren]

The 10.1 field is a result of a query using two or three fields to give me a text oriented query field.&nbsp;&nbsp;the field does not exist in the table&nbsp;&nbsp;only in the query itself.&nbsp;&nbsp;Thanks for your response.

 

[lwilly]

Place this in your query, yourfield1:CDbl([yourfield]) <br><br>This will convert your text field to a double.

 

[kkarren]

I tried the CDbl function it appears that the conversion has taken place in the query, however, I still get an error when I attempt to put the data into a chart summing the data. This is a real head scratcher.

 

[lwilly]

What is the the error you are getting? I tried this using Access97 chart wizard and it worked.

 

[kkarren]

I get a datatype mismatch in the criteria area.&nbsp;&nbsp;