Connel Valentine

[Connel Valentine]

Hi,
i was wondering if anyone could adivse me on this. I have
two tables: 'Engines' contaning Engine Type and Budget,
and another: 'Orders' contaning Engine Type and Sale Value.

Of course these tables are linked on a one to many
relationship(Engines to Orders). The problem is, i have to
create a chart that compares the Total Sale value, to the
budget value for THAT engine.

When i try to do it normally, the chart calculates the
total sales value fine, but unfortunately creates a sum
for the budget as well. What technique should i use so
that i can compare the sum of sale value from 'Orders'
Table to the budget value of particulare engine from
the 'Engines' Table

Thanks in advance

 

[Duane Hookom]

If I understand correctly, the Budget is using Sum when it should be
Average.

Duane Hookom
MS Access MVP

 

[Larry Linson]

The best way to get your post read, and answered, is to summarize the topic
of the question in the subject line. That way, people can determine the
subject and whether it is one they are qualified to answer, or interested in
answering without actually opening the message. If a well-qualified person
is very busy, that may make the difference between your getting an answer or
not.

For other good suggestions on effective use of newsgroups, see
http://www.mvps.org/access/netiquette.htm.