Chart of variable fields - Microsoft Access / VBA

laurentc via AccessMonster.com

Hi.

I would like to build a chart based on a query.
The issue is that this query is a "cross-tab" query, in which:
- the fields names change
- the number of fields changes

The query is like the following one:
MyDate / Price1 / Price2 / Price3 / Price4 ...

and each "field title" change each time I ask for new information.
I would like to be able to see a chronological chart based on all the Prices
(all the fields except 'MyDate').

I wanted to do so by the reagular mean, that is to say creating a new "chart
Form" linked to the query, but that does not work.

Does anyone have an idea?

Thanks a lot.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200611/1

Nov 2 '06 #1

Subscribe Post Reply

1162

laurentc via AccessMonster.com

I spent a new bunch of hours on this issue, looking for other solutions, but
in vain...

Does someone already tried to do this?

Thanks a lot.
laurentc wrote:

>Hi.

I would like to build a chart based on a query.
The issue is that this query is a "cross-tab" query, in which:
- the fields names change
- the number of fields changes

The query is like the following one:
MyDate / Price1 / Price2 / Price3 / Price4 ...

and each "field title" change each time I ask for new information.

I would like to be able to see a chronological chart based on all the Prices
(all the fields except 'MyDate').

I wanted to do so by the reagular mean, that is to say creating a new "chart
Form" linked to the query, but that does not work.

Does anyone have an idea?

Thanks a lot.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200611/1

Nov 3 '06 #2

laurentc via AccessMonster.com

Really no one ever try to chart variable fields?
It is a pity.

Thanks a lot for any help/piece of advice.
Or please tell me that it is simply impossible...

Regards

Laurent

laurentc wrote:

>I spent a new bunch of hours on this issue, looking for other solutions, but
in vain...

Does someone already tried to do this?

Thanks a lot.

>>Hi.

[quoted text clipped - 17 lines]
>>
Thanks a lot.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200611/1

Nov 8 '06 #3

Similar topics

help in craeting a chart in access 2000

by: Paul | last post by:

Let say, I have a table called USERS with the following fields: UserID, Date, Name, ComType. ComType gets it's info from another table called TYPE with fields: TypeID, TypeOfCom, with options:...

Microsoft Access / VBA

Getting to a Chart's Props?

by: PeteCresswell | last post by:

I've been to http://msdn.microsoft.com/library/default.asp?url=/library/en-us/mschrt/html/vbobjtitleobject.asp, but still don't have a clue. For example, I've got a chart object namde...

Microsoft Access / VBA

Problem with my chart in MS Access 2002 using a form and VB

by: StBond | last post by:

Hi everyone, I am new to Access and Visual Basic so things my be getting across a bit cloudy. I only started using VB for one week. I am having a little problem with the database that I am...

Microsoft Access / VBA

Access does not remember chart axis format

by: spm_no | last post by:

Hi, I am using Access 2002 and am creating a scatter-chart on a form in which the X-axis is a date. I can format and display the x-axis properly as a date. However, when I close and reopen...

Microsoft Access / VBA

changing Chart Legend text .for cr.NET?

by: Rob | last post by:

Hello; I searched and could not find a solution. DOes anyone know how you can actually have the Chart Legend reflect your report/table? I am using a simple two column table like this to test...

Visual Basic .NET

How to pass a filtered recordset of a form to a chart?

by: Saintor | last post by:

This is for A97 in runtime or MDE mode. My intent was to define a temporary query using the recordsetclone property / filter / orderby. The controlsource of my chart would be based on a grouped...

Microsoft Access / VBA

Chart Help Needed

by: StevenR via AccessMonster.com | last post by:

I have a form where I want the user to pick the fields for a Pivot Chart from 3 Combo boxes. Each Combo box holds 50+ fields from a stored procedure. I want the user to pick 1 or no fields for each...

Microsoft Access / VBA

pivot chart question

by: devagupt | last post by:

i have a form called get downtime data. WHen information is entered into it and the button "get downtime data" pressed , it displays the results of a query. WHen i view the query in pivot chart view...

Microsoft Access / VBA

Stacked Bar Chart in MS Access Form

by: Wedgewood | last post by:

Group, I am trying to build a gantt chart in a MS Access for but I can't seem to get it to pick up the second data series. In excel, you create a stacked bar chart using fields "Key Date" and...

Microsoft Access / VBA

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing