General :: How To Create A Graph From Query Results

Feb 23, 2013

I have a query that pulls up the sum of records that holkd a date value between two dates, and groups them by the person that created them.

How can I show these results in a graph? that will update every time a user clicks a buttons (as they may wish to change the two dates to search between)...

View Replies


ADVERTISEMENT

Queries :: Store Results Of Counts And Create A Graph / Chart

Feb 9, 2014

I have a a table 'Orders' with fields (Order Number, Order Date, CD Number, Card Number).

I would like to produce a query in access 2010 that would allow me to count how many times the CD Number 'Diab190617' has been purchased.

I would like to store the results of this count and counts on other cds numbers somewhere so that I can produce a graph/chart of these counts. How can I do this?

View 4 Replies View Related

Reports :: Create A Graph (report) Based On A Query With Form Filters

Apr 25, 2014

I am trying to generate a report that is based off of a query. The query has a form filter that it needs to filter the data. I keep getting a jet engine error and couple others.

The form has year, start week, and end week on it. I can get the query to work fine. When I try to open the report, Access says it doesn't recognize the " [Forms]![frmUptimeFilter]![StartWeek] " as a valid field name or expression.

View 2 Replies View Related

Using The Chart Wizard To Create A Graph

Jun 20, 2005

When I use the Chart Wizard to create a chart it looks fine in the preview but when i change it to form design - to alter the fonts etc- it gives me a graph which looks as if it comes from the Northwest database. What on earth is going on???

PS Am i best using graphs in reports or Pivot charts

View 1 Replies View Related

Modifying Access Graph To Create Bins

Nov 22, 2013

I have been struggling with modifying a graph that I have made into a counting graph, I have wasted over 4 hours trying to do this modification unsuccessfully.

I am attaching 4 pictures, The Depth_Ranges Table Visual is the query which creates graph 1 you can also see in the additional attached picture of the design view the code that creates this graph 1.

Now I need to add a field in the Design view of that query in order to have a result of the graph 2 that you see in the picture.

Basically, creating counter that will count how many values are in each bin labels that you can see on the picture of graph 2.

View 5 Replies View Related

Modules & VBA :: How To Create And See Results Of SELECT Query

Mar 22, 2015

I was beginning to think I had got the hang of creating queries on the fly in VBA. After several hours I have just learned that docmd.runSQL does not work for simple SELECT statements. I'm not going to worry about why that would be. I'm sure there's a jolly good reason.

So... I am able to dynamically create the SQL string for the SELECT statement that I need.

How do I run it? It just needs to return results as a datasheet so I can see them. I'm running Access 2013. I've been searching on this subject for quite a while and found many references to DAO, ADO, ADODAOD, YODELAEYYOUDELAYIO! and other things I don't yet understand ...

View 8 Replies View Related

Reports :: How To Take Two Separate Queries To Create 2 Line Graph

Nov 21, 2014

I want to be able to take two separate queries to create a 2 line graph. Also to be able to spice the graphs up some. The ones I have done, single line, even seems dull.

View 7 Replies View Related

Queries :: Create A Query That Can Run On Weekly Basis And Save Results To Excel Spreadsheet

Feb 18, 2014

I have a database of around 15,000 users and I'd like to create a query that I can run on a weekly basis and save the results to an Excel spreadsheet. The results need to be logical and understandable by my coworkers.

Unfortunately, the actual results of the query are not (in their raw form) logical or easy to interpret.

Let's say I have a table called "users" and within that I have:

Surname
Forename
FieldA
FieldB
FieldC

FieldA has a value of either NULL or a 12-digit number
FieldB has the values are "ENABLED", "DISABLED" and "N/A"
FieldC contains a value of either "1" or NULL

This means nothing to my coworkers who want each user to be sorted into a "category". As I'm running this on a weekly basis, I'd like this query to do the work for me, so I don't have to manually assign everyone to a category in Excel. Plus, of course, there is no chance of human error if the query does this for me.

Sooo... I'd like my query to categorise for me as follows:

Category1 = FieldA IS NOT NULL and FieldB="ENABLED"
Category2 = FieldA IS NOT NULL and FieldB="N/A"
Category3 = FieldA IS NULL and FieldB="ENABLED"
Category4 = FieldA IS NULL and FieldB="N/A"
Category5 = FieldA IS NOT NULL and FieldC = 1
... etc.

I'd like the final column in the query results to simply list the category name, so I can simply copy and paste the data into an Excel spreadsheet and be done with it, safe in the knowledge that it makes sense to all.

View 14 Replies View Related

General :: Graph Not Displaying Any Data?

Jul 23, 2012

I Have this graph that needs to be run from a combo box selection. it doesnt seem to want to display any information at all. i have attached my database.

View 2 Replies View Related

General :: Graph Not Displaying Bars

Jul 24, 2012

i have managed to retrieve information to my graph but i am unable to see the bars.

View 2 Replies View Related

General :: MS Access 2007 - Graph 2 Fields

Aug 2, 2013

I think the answer will be very simple but I can only seem to graph one field using the Graph wizard. I have a table that have running totals:

Date-----Sales ---- Budget
1/8/2013 0 2000
2/8/2013 2500 4000
3/8/2013 2500 6000
4/8/2013 4000 8000

I can only seem to chart the first column after the date.

View 2 Replies View Related

General Question - Uneditable Query Results

Jun 4, 2007

This is a very general question, but a problem that I hit repeatedly in my low level database work - I am not trained in databases at all, but have to use them to get on.

I find that when basing forms on select queries that are stacked on each other - (ie one query shows the results of two tables, that query then is joined to another table in another query and so on) that at some stage the query results become uneditable.

I cannot see why this happens. Is there a simple database rule that I am not adhering to here? Is there a maximum number of tables that can be joined in queries and form the basis of editable datasets in form view.

Sorry for vagueness!

Matt

View 2 Replies View Related

General :: How To Get A Text Box To Display Query Results

Feb 24, 2013

I have a text box, I have pasted this into the control source:

=[qryIndividualFaultVolumes]

then on a button I have this code:

me.qryIndividualFaultVolumes.requery

However, I get a Method or data member not found error when i click the button?

View 3 Replies View Related

General :: Report That Displays Results Of A Query

Mar 16, 2013

I have a report that displays the results of a query. The query and the report are both run from a submit button on a form. I use DoCmd.OpenQuery "name", followed by DoCmd.OpenReport "name". Due to slow network connection the query shows up before the form is displayed. I would like the query to be hidden or minimised. In other words, I do not want the user to see the results of the query, only the report.

View 3 Replies View Related

General :: Select Query Producing Inaccurate Results

Mar 6, 2015

I have a query that is returning inaccurate "Date Completed" results. Here is the SQL:

PARAMETERS [Enter Start Date] Text ( 255 ), [Enter End Date] Text ( 255 );
SELECT DISTINCT [Qry BDM FA English Email Test Part 1].ADI_DISTRIBUTOR_ADVISOR, ADL_AAH_ADVISOR_ACTIVITY_HISTORY.AAH_DATE_COMPLETE D, [Qry BDM FA English Email Test Part 1].AGA_EMAIL, ADL_AAH_ADVISOR_ACTIVITY_HISTORY.AAH_EMP_ID, DateAdd("d",180,Date()) AS [Next Update],

[Code] .....

View 4 Replies View Related

General :: Combo Charts - Graph Showing Certain Dataset As Column And Average For That Set

Aug 10, 2015

Is it all possible to create the equivalent of a combo chart in Excel in Access?

What I need is a graph showing a certain dataset as columns but also a line showing the average for that set.

As an example lets take an exercise programme in a school, each child performs a series of exercises every week and data is recorded, to monitor their fitness progression.

Lets say I wanted to show a graph of one particular exercise, with the class students listed along the x axis, and then show the class average for that exercise dataset as a line on the same graph.

View 3 Replies View Related

General :: Need To Create Query From A Table

Apr 14, 2014

I have an old ERP system. The upload function is one line per value. So if I want to upload 7 models I need 7 lines, not one line with Qty of 7
however my source system sends the data as one line with Qty of 7

DLM2245/17DLM2245/17X1
DLP2204/17DLP2204/17X7
DLP2249/17DLP2249/17X7
DLV1004/17DLV1004/17X147
DLV1005/17DLV1005/17X158
DLV1009/17DLV1009/17X187

so in this example line 1 is fine. But line two needs 7 lines, and line 3 needs 7 lines and line 4 147 lines etc etc etc.so this is how the first three lines would look in the query.

DLM2245/17DLM2245/17X
DLP2204/17DLP2204/17X
DLP2204/17DLP2204/17X
DLP2204/17DLP2204/17X
DLP2204/17DLP2204/17X
DLP2204/17DLP2204/17X
DLP2204/17DLP2204/17X
DLP2204/17DLP2204/17X

[code]....

View 3 Replies View Related

General :: Create Query Or Report With Macros Or VBA?

Mar 21, 2014

I want to create either a Macro or VBA that will automatically create a report or a query.

View 4 Replies View Related

General :: Using Both Query And Table To Create Pivot Chart

Sep 7, 2014

I was just wondering if I could use a query and table to create pivot chart? and If so how I could do this? I need information from both in order to create the chart I want.

View 1 Replies View Related

General :: Cross Join To Create Ledger Type Query From 4 Tables

Apr 2, 2013

I have 4 queries in which data needs to be connected from the date and shown as a single date showing each sections entry in a row and a cumulative total is maintained as the balance .

See the attached image ...

View 7 Replies View Related

General :: Create A Button That Will Create A New Empty Backend

Oct 31, 2013

I created a database and I manage to split it into front end and backend. now I'm going to make an EXE of the front end.My question is when I open the front end, I need the database to be empty, and them create a button that will make the user select which project he wants to open (backend).I also need to create a button that will create a new empty backend and save it as a new project.

View 7 Replies View Related

Create A Browse Button That Put Results In Field

Oct 4, 2005

Is there a way to create a browse button on a Microsoft Access 2003 form that also will put the results in another text field.

Once the file is found and selected I need a text field updated with the file location.

View 2 Replies View Related

Graph (2 Fields From Query On X And Y-axis)

Jul 26, 2005

Hi!

I have this table from a query:

1 1,34
2 1,23
3 1,21
1 0,65
2 0,55
3 ...
1
2
3
1

And I want 1,2,3 at the Y-axis and the X-axis to be the other values (1,34...)


But I only get a graph that shows 1,2,3 at Y but only the value 1 at the X-axis and the 1,34-values as legends! Why?

View 1 Replies View Related

Graph Date Range From Query?

Jun 18, 2012

I have a graph which queries data from a table, I need the graph to show the dates in the table with the correct results specific to that date.

However on the graph its displaying dates not in the table so its plotting the results out wrong, I need it to only show the dates in the the table on the bottom axis.how to do this.

View 1 Replies View Related

Create Error Message For Form Search Results Being Null

Sep 21, 2012

I have a form and when it's opened you get 3 different search questions to answer or leave blank. My question is.... If a search parameter is entered but no results are found to match it, how do I create an error message telling the requestor "No Data Found"?

View 7 Replies View Related

From Query To Graph - Running Sum Of Tasks Outstanding

May 10, 2006

Hi,

I am still confuse after reading threads on producing running sum on queries. help!

This query is to produce a time line graph of Progress Tasks with 3 main categories - New, Completed and Outstanding. So I got months on the x-axis and count on the Y-axis.

sample data.
say we look back for jobs in the month in feburary
Date Added; Date Completed ; category
11/1 ; NIL ; Outstanding
11/1 ; 1/3 ; Outstanding
11/1 ; 14/2 ; Completed
1/2 ; NIL ; Outstanding
1/2 ; 1/3 ; New and Outstanding
1/2 ; 14/2 ; New and Completed

so the total count of the categories for Feburary
New = 2 ,Completed= 2, Outstanding=4

can anyone help?

thanks
galantis

View 1 Replies View Related







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