Orchid XP v8 wrote:
> But you'd have to run the query, copy the data, paste it into Excel and 
> then fiddle about with chart options. 

This is what OLE is for, and COM.  You tell Excel to run the Access query, 
then chart the results with Excel, and skip the whole copy/paste step.


-- 
Darren New, San Diego CA, USA (PST)
   Human nature dictates that toothpaste tubes spend
   much longer being almost empty than almost full.

Post a reply to this message

>> But you'd have to run the query, copy the data, paste it into Excel 
>> and then fiddle about with chart options. 
> 
> This is what OLE is for, and COM.  You tell Excel to run the Access 
> query, then chart the results with Excel, and skip the whole copy/paste 
> step.

Is there a way that people who aren't hardcore programmers to access 
this kind of power?

-- 
http://blog.orphi.me.uk/
http://www.zazzle.com/MathematicalOrchid*

Post a reply to this message

Orchid XP v8 wrote:
> Is there a way that people who aren't hardcore programmers to access 
> this kind of power?

Yep. GIYF.


Basically, look up how to link excel and access, and then follow those 
instructions. :-)

This has a whole bunch of information I'm not going to read for you, but 
seems to give an indication of the steps.

http://www.infocaptor.com/dashboard/excel-dashboard-charts-gauges-tables-and-drills-reports


-- 
Darren New, San Diego CA, USA (PST)
   Human nature dictates that toothpaste tubes spend
   much longer being almost empty than almost full.

Post a reply to this message

Invisible wrote:
> OK, so today I confirmed that you can in fact export data from the
> Windows event log into a plain CSV file. Which is great.
> 
> (Unfortunately, sometimes event descriptions contain line breaks, which
> is not so great.)
> 
> Anyway, I wrote a small Haskell program that deletes any multi-line
> events, and then another which grabs only the events I care about and
> does some trixy parsing of the event description to pull out the data I
> actually want. The result is a big CSV file containing a list of printer
> events - date, time, user, printer and page count.

http://www.grymoire.com/Unix/Sed.html

> (There is *one* event in the log that says something like "document %4
> was printed on %6, byte count: %7, page count: %8". Which is really not
> especially helpful...)
> 
> So now I have a CSV file that contains the date, time, user, printer and
> page count. Just import that into Access and produce some stats, right?
> 
> Wrong! Access apparently can't parse any of the dates. Despite them all
> being perfectly valid dates (and it even *detects* that this column
> should be a date column), it fails to parse every single last one. >_<
> 
> So I used Haskell (which is really the wrong tool) to produce some
> statistics the hard way - by manually scanning the CSV file, reparsing
> the data and writing the results into yet *another* CSV file.

http://www.grymoire.com/Unix/Sed.html

> And now, finally, I have a chart showing me how many pages each printer
> printed on a given day. Which is all I wanted in the first place!

That one I'd do in Excel.

> Mmm, apparently that printer in the corner hasn't printed a single
> damned page since July... Yep, it's definitely spare. :-)

-Aero

PS. http://unxutils.sourceforge.net/

Post a reply to this message

Orchid XP v8 wrote:
> 
> Is there a way that people who aren't hardcore programmers to access
> this kind of power?
> 

IIRC Insert-Data-From database in Excel. You get GUI and everything.

-Aero

Post a reply to this message

Eero Ahonen wrote:

> http://www.grymoire.com/Unix/Sed.html

*shiver*

Thanks for the bad memories. :-}

Post a reply to this message

4b16d6fe$1@news.povray.org...
> But you'd have to run the query, copy the data, paste it into Excel and 
> then fiddle about with chart options. There isn't a button in Access that 
> says "please plot this as a pie chart" or something...

Actually there are two ways to create graphs directly in Access.
- When displaying a query, there's a Pivot chart icon in the Display menu 
that creates charts from the current query
- When creating a report or a form, there's a Chart wizard

G.

Post a reply to this message

Gilles Tran wrote:

> Actually there are two ways to create graphs directly in Access.
> - When displaying a query, there's a Pivot chart icon in the Display menu 
> that creates charts from the current query
> - When creating a report or a form, there's a Chart wizard

Really? I'll have to investigate...

Post a reply to this message

> Actually there are two ways to create graphs directly in Access.
> - When displaying a query, there's a Pivot chart icon in the Display menu 
> that creates charts from the current query.

This appears to work - although there doesn't seem to be a way to "keep" 
the resulting chart.

> - When creating a report or a form, there's a Chart wizard

It's not that easy to find, but it is in fact there. It even seems to 
automatically recognise the fields I want it to use! (Shame the graph 
comes out at one inch square...)

Heh, I would never have found either of these.

Post a reply to this message