a query to obtain statistical info

[Guest]

Hi.

I want to create a query that has as it's output a chart or list that simply
shows how many artworks I created in a month by month basis
For example Jan 2006 10, Feb 2006 8, ... August 2006 4.

As I have entries in my database for each artwork including year and date
completed I am planning on somehow (unsure how) take the date in the record
and use that as the input to the query. Also I will want to be able to view
just those for drawing or cg or all (that bit is simple on a query design
screen)

I have tried to do a simple design query that sorts by date and then used
the report wizard to make a chart but that does not let me see the month by
month totals and is a bit hard to read.

Thanks in advance for your help.

 

[Duane Hookom]

You can generally create a totals query that groups by year and month while
counting artworks. This query can be used as the Row Source of a line or bar
chart.

 

[Guest]

Thanks very much !

Your reply gave me the right "keyword" = Totals" to look up in an old Acess
for Windows 95 book I have. (I know it's old but much of it is still
usefull).

What I have currently is a query with fields year, date, project (project or
title of work). That is fed into a crosstab query which does the "number
crunching" and generates the talleys.

The next step will be to filter by media (drawing, cg etc) so I can see
output for just drawings or just cg - that bit will be a piece of cake as I
allready do this kind of filtering in some of my queries.

Again - Thanks vey much.