Link to home
Start Free TrialLog in
Avatar of tmaususer
tmaususerFlag for United States of America

asked on

Access 2003 Help with a Graph

I have a report called Test_RPT that is based on a table called test_tbl. The table is created via a query called calculation_qry. The query has criteria of  Between [start date] And [end date].
I thought I could originally tie this query as a select but my chart bombs which is why I went with the create table route as I don't know how to create a graph based on a query with criteria. If there is a better way please let me know as I am a novice at this (also attached) db.
The test_rpt runs correctly however I cannot seem to get the date included on the graph. Can someone help me as to how I can include the dates on my graph.
Safety-new-2x.mdb
Avatar of DJNafey
DJNafey
Flag of United Kingdom of Great Britain and Northern Ireland image

Hi,

I have just had a quick look at your database but it's a very long time since I've made reports in Access and I couldn't quickly re-create the chart in the same layout as you have it.  However, I could make it run from a SELECT query and get it to prompt me to enter the dates.  To do this, I ran the query builder, select your Test_tbl, dragged in all of the fields and then used a "Group By" on the Date field.  In the 'Criteria', I entered

Between [Start Date] And [End Date]

Does that help at all?
Avatar of tmaususer

ASKER

Not sure I follow since I am a novice at this. Sorry....
I guess the best way I can put it is I have a report called report2 in my db that works great. I basically need something like that but in graph format. Does that make sense?
Sorry forgot to mention if you launch report2 you can use start and end dates of 3/1/12 and 3/31/12.
Oh OK - I think I was only looking at Test_RPT but, if you're already getting date filters working in Report2, then it sounds like you're most of the way there.

I'm no in front of my PC at the moment but can probably get another look at it later if no-one else helps before then.

How are you trying to make the report with the chart? I did it by creating a report in design view, adding a chart, then going into the Properties of the chart, going to the RecordSource value, clicking the 'build' button to run the query builder wizard, then creating a a query based on your table (and with the date filtering statement typed into the Criteria field) to use as the 'source' for the chart. Actually, it wasn't exactly like that because I'm on Access 2010 but that's what I think you should be doing in Access 2003.

If you did it a different way, try following my steps and see how far you get :-)
I used the report/chart wizard but when I added my query in which I have set criteria it gives me an error which is why I created a make table and based my graph on the new table. The problem I am having is I cannot create a graph based on dates. Sorry if my explaination is not that great but I think once you can look at my db you will see my issue.
Sorry, I've just read your original post again and the very first thing that you said that you did was what I was suggesting.  You might have done it a different way to me, being on Access 2003 instead of 2010, but it sounds like it should have worked.

I'm going to have another look at it now.
I've just been looking at it for another hour but I can't see how to get a date filter working directly from the report either.

Report2 doesn't run when I try it here in Access 2010.  

Is there anyone else out there who could assist?
I'm increasing the points in the hopes someone can help. Basically I want to create a chart based on date parameters from a query. Similiar to report2 in my sample db but representing that data in chart format.
Avatar of Jeffrey Coachman
What is a typical start and end date range?
Post a graphic of the *EXACT* chart you want based on that date range...
Don't describe what you want, ....post a Picture of exactly what you want...
A typical date range would be weekly and monthly. I have attached an example per your request.
Would-result-in.doc
ASKER CERTIFIED SOLUTION
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
When I hit the view button I receive an error (see attached).
error.png
In Access 2003 this may need to be:
acPrintPreview