Pivot Chart help.

[lorenambrose]

First I would like to say hi. I am an Access newbie and this is my very first database ever.



My database tracks and documents production rework.

In my database I have this example.

1. "DR" Table ( this is the one and only table in the database)

2. "Rework Manhours" Query (data from the "DR" table)

3. "Rework Manhours" Form (data from the "Rework Manhours" Query)
a. This form is a pivot chart which seems odd to me that a "form" would be a chart.

I have a command button that opens this "Rework Manhours" Form / Pivot Chart from a "dashboard" type of Form that opens when you open the database.

The issue is that as time goes on the data in the Pivot Chart will keep populating and will be useless. It would be great if I could choose start and end dates and only display that specific data.

I found a way to do it for reports here: http://allenbrowne.com/casu-08.html but unfortunately I don't think you can display a report as a pivot chart. I have no idea how to apply this to my needs but the concept does seem to be right in the ballpark.

The Pivot Chart is a MUST HAVE.

I am really trying to create a slick user interface as the entire management will use this database to gather information and I want to make it presentable to the VP.

Can someone help me with this? As this is my very first database, I am not sure I will understand everything you say so please be patient.

[ajetrumpet]

how about creating one from a query? you can use criteria there. and no, reports don't have pivots. simply charts. also, don't be fooled by the name 'pivot', as they are nothing special. like you said, just a slick interface look.

[lorenambrose]

how about creating one from a query? you can use criteria there. and no, reports don't have pivots. simply charts. also, don't be fooled by the name 'pivot', as they are nothing special. like you said, just a slick interface look.

I am not understanding you. It is me, I'm new to this.

I have the Pivot chart created already from a Query of the same name. The Query shows all entries. How would I filter it for a specific date range?

[ajetrumpet]

I am not understanding you. It is me, I'm new to this.

I have the Pivot chart created already from a Query of the same name. The Query shows all entries. How would I filter it for a specific date range?

add:

WHERE datefield BETWEEN #date# AND #date#

[lorenambrose]

add:

WHERE datefield BETWEEN #date# AND #date#

I assume this code goes in the Query table somewhere.

[lorenambrose]

add:

WHERE datefield BETWEEN #date# AND #date#

Where would this go and how do I get it there. Sorry for the ignorance...

[alansidman]

You put BETWEEN #date# AND #date#

in the criteria for the datefield in your QBE

ajetrumpet gave you the sql portion. Once you put it in the QBE and open the SQL statement you will see the where clause.

Alan

[lorenambrose]

You put BETWEEN #date# AND #date#

in the criteria for the datefield in your QBE

ajetrumpet gave you the sql portion. Once you put it in the QBE and open the SQL statement you will see the where clause.

Alan

I put this in the date criteris:

BETWEEN #date# AND #date#

I get an invalid date entry error. What is an SQL statement and where is it.

[alansidman]

SQL is best described here

http://en.wikipedia.org/wiki/SQL

and how to get the statement is here

http://www.techonthenet.com/access/q...ew_sql2007.php

and a tutorial is here

http://www.w3schools.com/sql/default.asp

As to your error---what is the format of the date fields in your table. Date or Text? This may be your issue.

Alan