graphing

[Conor]

whenever i try to insert a chart into my access report, i can never get
access to get the right data! is there a way to specify where/what data i
want access to get? like in a query, i am using this:
[SOB]![Salary]+[SOB]![Bonuses]
to get the persons gross income. i want to be able to add data in that
format to my chart. i am using access 2002. can anyone help me?

 

[Duane Hookom]

Graphs have a Row Source property which is basic SQL. You can set this
property to any SQL statement or query.

 

[Conor]

how do i set this property?

Graphs have a Row Source property which is basic SQL. You can set this
property to any SQL statement or query.

--
Duane Hookom
MS Access MVP

whenever i try to insert a chart into my access report, i can never get
access to get the right data! is there a way to specify where/what data i
want access to get? like in a query, i am using this:
[SOB]![Salary]+[SOB]![Bonuses]
to get the persons gross income. i want to be able to add data in that
format to my chart. i am using access 2002. can anyone help me?

 

[Duane Hookom]

View the design view of the report and select the graph control. View the
properties and you should find it in the Data properties.

--
Duane Hookom
Microsoft Access MVP

how do i set this property?

Graphs have a Row Source property which is basic SQL. You can set this
property to any SQL statement or query.

data

i

want access to get? like in a query, i am using this:
[SOB]![Salary]+[SOB]![Bonuses]
to get the persons gross income. i want to be able to add data in that
format to my chart. i am using access 2002. can anyone help me?

 

[Conor]

ok, i have gotten that far. however, i am still given the default data
(east,west,north-1st,2nd,3rd,4th etc..) and when i try to put my sql
statement in there, that "slice" of my pie graph is erased, and i don't
think the statement is being evaluated! what am i doing wrong?

thanks for your help so far duane

View the design view of the report and select the graph control. View the
properties and you should find it in the Data properties.

--
Duane Hookom
Microsoft Access MVP

how do i set this property?

Graphs have a Row Source property which is basic SQL. You can set this
property to any SQL statement or query.

--
Duane Hookom
MS Access MVP


whenever i try to insert a chart into my access report, i can never get
access to get the right data! is there a way to specify where/what

data

i
want access to get? like in a query, i am using this:
[SOB]![Salary]+[SOB]![Bonuses]
to get the persons gross income. i want to be able to add data in that
format to my chart. i am using access 2002. can anyone help me?

 

[Duane Hookom]

When working with graphs in Access 2000 and beyond, I generally create a new
blank form and paste the graph control onto the form for editing. Set the
control properties to Locked: No; Enabled: Yes. This allows you to view the
form view, double-click the graph, and do some formatting etc. This will
also update the control with your data.

You should always be able to edit the Row Source property so the graph
displays the correct values when the form or report is open.

Once you have your graph looking good on the form, copy and paste it into
your report.

--
Duane Hookom
Microsoft Access MVP

ok, i have gotten that far. however, i am still given the default data
(east,west,north-1st,2nd,3rd,4th etc..) and when i try to put my sql
statement in there, that "slice" of my pie graph is erased, and i don't
think the statement is being evaluated! what am i doing wrong?

thanks for your help so far duane

View the design view of the report and select the graph control. View the
properties and you should find it in the Data properties.

--
Duane Hookom
Microsoft Access MVP

how do i set this property?

Graphs have a Row Source property which is basic SQL. You can set this
property to any SQL statement or query.

--
Duane Hookom
MS Access MVP


whenever i try to insert a chart into my access report, i can

never
get

access to get the right data! is there a way to specify where/what data
i
want access to get? like in a query, i am using this:
[SOB]![Salary]+[SOB]![Bonuses]
to get the persons gross income. i want to be able to add data in that
format to my chart. i am using access 2002. can anyone help me?

 

[Conor]

hmm.. maybe i am mis-stating my question. when i try to enter sql statements
into the datasheet for a chart of mine, inside an access report, they are
not accepted/evaluated. where am i going wrong?

(thanks for your help so far duane)

conor

When working with graphs in Access 2000 and beyond, I generally create a new
blank form and paste the graph control onto the form for editing. Set the
control properties to Locked: No; Enabled: Yes. This allows you to view the
form view, double-click the graph, and do some formatting etc. This will
also update the control with your data.

You should always be able to edit the Row Source property so the graph
displays the correct values when the form or report is open.

Once you have your graph looking good on the form, copy and paste it into
your report.

--
Duane Hookom
Microsoft Access MVP

ok, i have gotten that far. however, i am still given the default data
(east,west,north-1st,2nd,3rd,4th etc..) and when i try to put my sql
statement in there, that "slice" of my pie graph is erased, and i don't
think the statement is being evaluated! what am i doing wrong?

thanks for your help so far duane

View the design view of the report and select the graph control. View the
properties and you should find it in the Data properties.

--
Duane Hookom
Microsoft Access MVP


how do i set this property?

Graphs have a Row Source property which is basic SQL. You can set this
property to any SQL statement or query.

--
Duane Hookom
MS Access MVP


whenever i try to insert a chart into my access report, i can never
get
access to get the right data! is there a way to specify where/what
data
i
want access to get? like in a query, i am using this:
[SOB]![Salary]+[SOB]![Bonuses]
to get the persons gross income. i want to be able to add data

in
that

format to my chart. i am using access 2002. can anyone help me?

 

[Conor]

ok, i think we're getting on the same page. i have the row source type set
as "table/query" and the row source as the query i want to pull my data
from. now what i want to do is define the "slices" of the pie graph as
elements of that query. how can i do that? i've been trying to enter the sql
statements into the datasheet, but that must be incorrect.

as always, thanks again
conor

While in the design view of the report, view the properties of the chart.
Don't open the chart. There will be a Row Source property. You should only
see the datasheet if you double-click the chart control which I don't want
you to do until after you have set the Row Source.

--
Duane Hookom
MS Access MVP

hmm.. maybe i am mis-stating my question. when i try to enter sql statements
into the datasheet for a chart of mine, inside an access report, they are
not accepted/evaluated. where am i going wrong?

(thanks for your help so far duane)

conor

When working with graphs in Access 2000 and beyond, I generally create

a
new

blank form and paste the graph control onto the form for editing. Set the
control properties to Locked: No; Enabled: Yes. This allows you to

view
the

form view, double-click the graph, and do some formatting etc. This will
also update the control with your data.

You should always be able to edit the Row Source property so the graph
displays the correct values when the form or report is open.

Once you have your graph looking good on the form, copy and paste it into
your report.

--
Duane Hookom
Microsoft Access MVP


ok, i have gotten that far. however, i am still given the default data
(east,west,north-1st,2nd,3rd,4th etc..) and when i try to put my sql
statement in there, that "slice" of my pie graph is erased, and i don't
think the statement is being evaluated! what am i doing wrong?

thanks for your help so far duane


View the design view of the report and select the graph control. View
the
properties and you should find it in the Data properties.

--
Duane Hookom
Microsoft Access MVP


how do i set this property?

Graphs have a Row Source property which is basic SQL. You can set
this
property to any SQL statement or query.

--
Duane Hookom
MS Access MVP


whenever i try to insert a chart into my access report, i can
never
get
access to get the right data! is there a way to specify where/what
data
i
want access to get? like in a query, i am using this:
[SOB]![Salary]+[SOB]![Bonuses]
to get the persons gross income. i want to be able to add

data
in

that
format to my chart. i am using access 2002. can anyone help me?

 

[Duane Hookom]

Build a query in the Row Source that returns something like

Cherry 45
Apple 32
Banana 12
Cow -4

Once your Row Source returns something like this, your "pie" will be tastee.

--
Duane Hookom
Microsoft Access MVP

ok, i think we're getting on the same page. i have the row source type set
as "table/query" and the row source as the query i want to pull my data
from. now what i want to do is define the "slices" of the pie graph as
elements of that query. how can i do that? i've been trying to enter the sql
statements into the datasheet, but that must be incorrect.

as always, thanks again
conor

While in the design view of the report, view the properties of the chart.
Don't open the chart. There will be a Row Source property. You should only
see the datasheet if you double-click the chart control which I don't want
you to do until after you have set the Row Source.

create

a

new
blank form and paste the graph control onto the form for editing.

Set
the

control properties to Locked: No; Enabled: Yes. This allows you to view
the
form view, double-click the graph, and do some formatting etc. This will
also update the control with your data.

You should always be able to edit the Row Source property so the graph
displays the correct values when the form or report is open.

Once you have your graph looking good on the form, copy and paste it into
your report.

--
Duane Hookom
Microsoft Access MVP


ok, i have gotten that far. however, i am still given the default data
(east,west,north-1st,2nd,3rd,4th etc..) and when i try to put my sql
statement in there, that "slice" of my pie graph is erased, and i don't
think the statement is being evaluated! what am i doing wrong?

thanks for your help so far duane


View the design view of the report and select the graph control. View
the
properties and you should find it in the Data properties.

--
Duane Hookom
Microsoft Access MVP


how do i set this property?

Graphs have a Row Source property which is basic SQL. You

can
set

this
property to any SQL statement or query.

--
Duane Hookom
MS Access MVP


whenever i try to insert a chart into my access report, i can
never
get
access to get the right data! is there a way to specify
where/what
data
i
want access to get? like in a query, i am using this:
[SOB]![Salary]+[SOB]![Bonuses]
to get the persons gross income. i want to be able to add data
in
that
format to my chart. i am using access 2002. can anyone

help
me?