Somewhat complex graph making.

[TrulyVisceral]

Cool cool. Last thing I require for this thing is a somewhat complex graph I need to make, but I don't know enough about Access for it.

Here's the context: There are several providers, in this case I just need 3, all phone companies: CANTV, Movistar and Digitel. The field name is "Provider".
There are several affected services, in this case I just need 2: POS (point of sale) and Communications. The field name is "AffectedService"
Normally in counts I tend to use the ID of the incidents, just called "IncidentID".
The table in which everything is located, is simply called "TableMonth"

The thing I get confused by is that, for making the graph, I would need a query (or queries) that'd show how many POS and Communication failures there where for CANTV, and then for Movistar, and lastly for Digitel. So the end result would be something like:



It's probably easier than I'd think and I'm asking something quite dumb.
Though I'm pretty sure the next thing I need (Average of duration of all failures for POS and Comm for all 3 providers) in fact more difficult. But this first.
Also, none I've said is confidential, just clarifying 'cause I feel someone would say that or something.

[ranman256]

make the query, then use it to make the base base graph.
design the graph,
dbl-click the chart,
paste data from the query into the datasheet.
tweek the graph how you need.
save.

Access is limited with graphs, but you can always export the data to excel and use the more robust excel graphs.

[TrulyVisceral]

make the query
make the query

Ok but, how? That's what I'm asking. make one for each Provider?

NVM, I got it. I forget the Data Sheet Exists

[TrulyVisceral]

Is it possible to change the location of the numbers? Like, Ok I can move it manually, but it always resets to the top whenever there is a change in the source.

[TrulyVisceral]

make the query, then use it to make the base base graph.
design the graph,
dbl-click the chart,
paste data from the query into the datasheet.
tweek the graph how you need.
save.

Access is limited with graphs, but you can always export the data to excel and use the more robust excel graphs.

Hey, wanna hear something funny? I just got told this isn't necessary

FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF FFFFFFFFFFF... x10^999999

[ranman256]

but if you DID want to do it,
youd make a form, with a listbox of providers,
the query would look at the list box, get the 1 provider,
the graph would use that query.
export it, then next provider.