Chart Form

[Andy]

I have a chart ( graph ) built from a query into a form.
When I try to save the format for the datasheet i.e.
number - example 12,345,123 it continues to show as
12345123.1 The output of the query is formated as a number
decmial equals 0. How do I get the same formating to save
in my chart form. I am trying to display the data table
along with the bars in the graph

 

[Colin Halliday]

You may have to force the required formatting by using the Format Function
on the field in the column in your query. The chart will not pick up the
formatting from the format properties of the query column.

So if you look at the column in your query that is causing the problem, say
the field is called Amount.

Change the first row of the column to say:
FormattedAmount:Format([Amount],"Currency")

The word Amount inside of the square brackets is the name of the field from
the table. You are using the Format() function to force this field to
formatted as Currency (in this example). You are then giving the column a
new name, FormattedAmount.

Look up the Format() function in help for more information about what can be
the second argument of the function.

Hope this helps.

Colin.

 

[Andy]

Colin - this worked Great - Thanks
Andy

-----Original Message-----
You may have to force the required formatting by using the Format Function
on the field in the column in your query. The chart will not pick up the
formatting from the format properties of the query column.

So if you look at the column in your query that is causing the problem, say
the field is called Amount.

Change the first row of the column to say:
FormattedAmount:Format([Amount],"Currency")

The word Amount inside of the square brackets is the name of the field from
the table. You are using the Format() function to force this field to
formatted as Currency (in this example). You are then giving the column a
new name, FormattedAmount.

Look up the Format() function in help for more information about what can be
the second argument of the function.

Hope this helps.

Colin.

I have a chart ( graph ) built from a query into a form.
When I try to save the format for the datasheet i.e.
number - example 12,345,123 it continues to show as
12345123.1 The output of the query is formated as a number
decmial equals 0. How do I get the same formating to save
in my chart form. I am trying to display the data table
along with the bars in the graph

.