Creating Charts From Querys

Feb 4, 2008

Hi, I have done a search before posting but cannot find what I am looking for.

At work I use a database to record incidents (work that I do). I have written a query for incidents for 2007 and 2008 and I can do a line graph for each year showing the monthly incidents by doing Insert, Form, Chart Wizard

What I am trying to do is a line graph for 2007 and 2008 together to compare performance but i can only ever choose one query for my graph, either 2007 or 2008.

Is there a way I can get both years on one graph so as i can compare performance.

Any help/guidance appreciated.

View Replies


ADVERTISEMENT

Creating Word 2010 Charts Using Access Database

May 23, 2014

I am using an Access 2003 database to create a Word report that contains Graphs. We have since moved to Office 2010, and now the vba code will not select the graph and populate the data, i presume this is because the data is no longer in a datasheet but Excel itself.

View 2 Replies View Related

Querys

Sep 24, 2007

I have created a cbo box that I am using to selects locations (citys) in a field. I have used "Distinct" to elimate the duplicates but I also want to elimate three locations. They are Verdun, Lasalle, and Montreal. In my query I have tried the following statement in the Critera location. Not "Verdun" Or "Lasalle" Or "Montreal". The query returns the following statement: <>"Verdun" Or "Lasalle" Or "Montreal" this statement does take out the first location "Verdun" but the two others still remain in the field. How do I solve this problem?

View 3 Replies View Related

Forms And Querys

Aug 2, 2006

I have a form which has a subform on it and this performs a query and displays a list of courses only done by a particualr provider which changes when you change the record i now have buttons beside each course and want to be able to get it to open up another form and then display dates for that particualr course and whos attending whats the easiest and best way to do this as im really stuck and need to get this finished.

View 4 Replies View Related

Currency Querys???

Dec 7, 2005

Hello All,

I'm only fairly basic when it comes to Access, and I need some help with a query. Im running Access 2003 on XP Pro, and my current database is in a one to many relationship with Staff and Activities. A part of the Activites field involves the expenses of that particular activity. I have a field in my Activities table saying total expenses. The expense formats are in currency (including total). When I go to make a query, I'm using the following critera for the TotalExpenses field. "FoodExpenses"+"OtherExpenses". However, when I go to run the query, it tells me that there is a data type mismatch in the criteron expression. I changed the field formats to text and it will run. Can access 2003 support currency based querys and if so how? It would be really handy to know.

View 5 Replies View Related

Querys And Switchbords....

Jun 19, 2006

I have to do a query that uses as condition a row from a switchbord.... Is that possible?? Can u help. (I created my switch bord with the Access tool).
Thanks.:cool:

View 2 Replies View Related

Querys With Subforms

Sep 7, 2006

Hi guys
The question i am looking for help with is.....

i have a database with a form(form1) and a subform(sub1), when i query this it will only desplay information that has all boxes filled in. i want it so that if there is info in form 1 but no info in sub1 i will still display the info from form 1. At the moment it just ignores the whole thing and does not give certain records from form 1.

any ideas?

James

View 2 Replies View Related

Disable Ctrl + C In Querys Or The Whole Db

Apr 24, 2007

Hey, I have a database and a login panel and I need to stop some users from using ctrl + c in query's or through out the database. The way I have set the db up is if a user logs in correct then they get directed to the appropriate switchboard. I have already disable all toolbars therefore disabling right click and on my forms I have vba to stop ctrl + c but can't figure out how to do it on queries, I have tried search and searching Google but if I have missed a post please include a link, any help would be appreciated THANKS :)

View 3 Replies View Related

Convert Querys To Views

Nov 2, 2007

Is there a tool that converts Access querys (jet syntax) to sql views and procedures (sql server syntx)?

Thanks

View 3 Replies View Related

Current Date Querys

Jun 2, 2005

Hello,

I have about 1500 records in a table. We use a form to search through the records to find info on certain accounts. We now want to only search through accounts that are current, so I made a query to see only current accounts. I switched the search form from going off data right from the table to the new current date query. Now when you load the form it says "running query" and the application stops responding. The query seems to load up quick in raw format.. how come the application freezes when searching using the query instead??

thanks,
Matt

View 1 Replies View Related

Expressions In Cross Tab Querys

Mar 6, 2006

i'm struggling here

i have a simple cross tab query. i'd like to put a parameter value as criteria. lets say i hard code the criteria with 2006 it works fine. but when i reference it to the value in a form e.g forms!frm_navmaster!txtyeardate then i start having problems. i don't know to start. i've tried using the expression and where values in design view....uuggghhh.

any ideas are appreciated

View 3 Replies View Related

Can't Show Tables And Querys

Jan 15, 2008

Hi to all

I have a .mdb Files. If i doubleclick this file the database opened but i can't see the tables and Querys. It's a program that start automatically.
I can only see the source code if i enter Alt + F11.

What i must do for see the Querys and the Tables?

regards
cobra

View 4 Replies View Related

Hardcoded Parameters In Querys--can I Find All?

Jun 21, 2005

We have a tbldepartments. At this point (has been a few years)...many dept. have merged or changed names. We want to 'change' the names of some and delete or add others.

Ok on the delete/add.

However, in many of our queries, we have the dept. name/number hardcoded in. And trust me, there are tons and tons of them...this is a big database.

Short of going through each query, is there a way to 'search/replace' either in each query or in all? To update these easily?

suggestions?

View 2 Replies View Related

Charts

Jan 6, 2005

Hi all,

I want to create a 100% stacked column chart (as can be used in Excel) into a report in my database, however I cannot find it anywhere to use.

Does anyone know if it is possible to use this type of chart in Access and if so, how to do this?

Again, help would be greatly appreciated.


Thanks

View 4 Replies View Related

Cusum Charts And SPC Add-ins

Aug 7, 2006

Hi everyone

I would like to create a statistical cusum chart in my db, I can do it in Excel but it's quite difficult to do in Access. Does anyone know how to do one, or know of any SPC add ons for Access (there are loads for Excel)?

Thanks
Matt

View 1 Replies View Related

Charts In A Report

Jan 4, 2008

I would like to create a report from one of my existing queries. I would like this report to have a pie chart on it showing results from a field called concerns in the querie.

I would like the chart to break down the amount of each concern listed i.e. 4 of this 3 of that 5 of those etc.

i use the chart wizard to pull in the field data and when I click finish, it gives me basically nothing. Any ideas?

thanks in advance.

View 2 Replies View Related

Filtering Charts

Aug 25, 2006

I solved one problem only to hit another.
I have several charts that work off of a query.
The several charts all compare various variables to year.
I created the charts and they all work great. However, the user now wants to be able to select or compare various years as opposed to seeing them all in every chart. I made the year an integer. I then tested the query that all the charts are based on to see if it filters properly.

In the query's date filed I have the criteria Like [Enter the desired year]
This works fine if I am just looking at the query.
However, if I pull up the chart that the query is based on I get the error message, "The microsoft jet database engine does not recognize '[Enter the desired year]'as a valid field name or expression."

I have wasted an enormous amount of time simply trying to filter my charts by year. A single field in my table that is an integer with 0 decimal places. All the dates are entered as a 4 digit number. Ex 2006.

Any help / suggestions would be greatly appreciated.

My end desire is to have a form with two text boxed named "start" and "end" in addition to a number of butons each corresponding to one of the charts. My user will enter two dates, one in each of the text boxes "start" and "end"
When he/she presses one of the chart butons, the corresponding chart will open up showing only the two (or) one selected years' data. This would be filtered by the query that all of the charts are based on that has a set criteria, "Like [forms].[charts].[start] or like [forms].[charts].[end]"

As I mentioned earlier, I already have this all set up. The query works fine based on all of the above. However, if I click the butons or try to open a chart I get the message stated above.

Thanks again to all here at the forum for your invaluable help.

View 2 Replies View Related

Best Practice For Charts?

Jan 3, 2007

Deal All

I've got some simple charts to do in Access. They are working fine - except for the Legends.

The problem is that my table (on which the charts are based) is fed by Combo boxes which populate the table with codes, rather than a descriptor.

For example, the combo box on the input form displays two columns

5 | Excellent
4 | Very Good
3 | Average
2 | Not good
1 | Poor
0 | Don't know

..but populates the table only with the numbers 5, 4, 3, 2, 1, or 0.

Consequently, the legend in my graph only displays the numbers - when I would really like the Words.

What's the best way round this?

NoVoice

View 1 Replies View Related

Anyone Try Tracking Org Charts In Access???

Jul 6, 2006

I'm trying to set up a database to track a huge group of corporations. There is the parent company, then a bunch of subsidiaries below it. Some subsidiaries have another layer of multiple subsidiaries below it, some have none. Any thoughts as to how to do it???

View 1 Replies View Related

Charts In Switchboard? Any Issues?

Jan 24, 2007

Hello,

I am adding a chart to my switchboard page which comes from a query...does anyone know if this is ok to do or if its not recommended. The Chart takes the database and summarizes its contents..

Didnt know if performance issues would come into play...

Thanks for any opinions.

View 1 Replies View Related

Charts With Filters From A Form

Nov 13, 2007

thought this might have been easy, but no....

i want to have a form with a [DateFrom] and [DateTo] text box

you click a button, it goes to a chart and the chart is filtered between those dates (the chart has week along the x axis)

problem is, the recordsource of a chart in a report is a crosstab query and you can't put form filters into a cross tab query

have tried to ram the parameters in before opening it with


CurrentDb.QueryDefs("qry_Reporting_Charts").Parameters("DateFrom").Value = [txtFrom]
CurrentDb.QueryDefs("qry_Reporting_Charts").Parameters("DateFrom").Value = [txtTo]
DoCmd.OpenReport [cmbReports].Value, acViewPreview


but it looks like the parameters are read only or something :confused:

any ideas anyone?

thanx in advance

View 2 Replies View Related

Charts From Queries - 6 Fields!!!!!???? Is That It!!!!???

Oct 17, 2007

I am infuriated with MS Access now!!!!!

I am building a nice little system and now I am developing the reporting features. I want the results of a query to populate a chart.

Basically it is a monthly chart, so would have 12 months along the x axis and a quantity on the Y. A simple line chart!

I want 4 different lines each representing a form of occurrence. However Access limits you to using a maximum of 6 fields! Are you serious!!! I need 12 just for the months!!!!

Is this a serious feature of Access or am I being stupid?

I know many people who export a lot of stuff to Excel for charting, and now I know why. Is this my only option? I wanted to avoid multiple applications, but if I have to, will have to learn how to automate to an excel template, some thing I am not aware of how to do currently and am limited in my VB programming abilities.

I cannot believe that a powerful tool such as Access could be sooooo limiting in it's reporting capabilities!

View 1 Replies View Related

Pie Charts - Why Aren't They Simple?!

Feb 25, 2008

Hi guys,

i have built a query to find the sums of various fields from various tables. i want to make ONE piechart from all these the sum values... i.e.

Cars - 500
Planes - 300
Those digger things i always wanted as a kid - 200

But the stupid MSchart activex thingy in Access 2007 always wants to Sum/max/be an idiot to the data. All i want is a damn pie chart!

Any ideas?

If it can be done in VB by saying "split the piechart into 3 pieces. One = Cars, two = Planes, three = diggers" - that would be ace

View 5 Replies View Related

Charts Driving Me Crazy

Jul 19, 2005

I am trying to create a chart on a Form. In Excel I have no problems arranging my data. This is my first try for charts in Access. I have a table. I created a query summing two fields of this table:

Total Workers
Total Workers: DCount("[WorkerNameLast]","1-StationVerifyTbl","[ClockNbr]<>'*'")
Total Workers = 120

Total Verified
Verified Workers: DCount("[WorkerNameLast]","1-StationVerifyTbl","[StaPrimary]=True")
Total Verified = 43

So far so good. That is the correct information. What I want in a Chart is two bars side by side. One bar at 120 and the other bar at 43. I have tried everything and cannot get this to work. I am getting confused on the Axis, Data, & Series. I think I need another Field somehow. The totals I would call Monthly Totals

Could someone please help me get this thing started. I have wasted a week and feel like I have learned nothing except how to count in the Query.

After this I would like to be able to show a percentage of those verified. I have 120 workers and 43 are verified. That would be approx 35%. Anyway I am assuming that there is a solution and that I am just floundering for nothing. Thanks in advance.

View 8 Replies View Related

Getting Pivot Charts Out Of Access

Nov 24, 2004

a co-worker set up several pivot charts in queries, that we now need to get into a distributable format. I had envisioned having these in a report, but access doesn't agree. Is there any way of getting the chart out of access, intact, to place in a word or power point file, or into a report? My attempts to get the chart into a report have all ended with the table-like grid coming up. Surely there's a way...
thanks!

View 3 Replies View Related

Week No's On Pivot Charts

Feb 1, 2005

CAN THE FORMAT OFF THE WEEK NO USED IN PIVOT CHARTS BE CHANGED THE DEFAULT WEEK NUMBERING SYSTEM IS NOT COMPATIBLE WITH THE ENGLISH WEEK NUMBERING SYSTEM. I CAN WORK AROUND THE PROBLEM IN VBA CODE BY USING DATEPART("WW",DATE,VBMONDAY,vbFIRSTFOURDAYS) WHICH RETURNS WEEK NO IN LINE WITH THOSE USED IN ENGLAND BUT THE PIVOT CHART DOSEN'T SEEM TO OFFER THE OPTION OF WHICH WEEK NUMBERING SYSTEM TO BE USED ANY IDEAS!

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved