|
by: eskil |
last post by:
Hi,
I am running a pivot table based on a query. I need to be able to
display decimal precision for on a calculated field (in the query).
The query returns the values correctly (i.e. with the number of
decimals specified), the pivot table - when viewed as a regular form -
shows decimals, but the pivot itself displays only the suffix ,00.
...
|
by: keliie |
last post by:
Hello,
I've created a form that contains a single unbound combo box and two
subforms. The two subforms display the results of a query (driven by
the combo box selection) in both tabular and pivot chart formats. The
problem that I'm having is that the Pivot Chart that I've created
rounds all of the values down to the nearest integer (e.g.,...
|
by: kaykae |
last post by:
I have this query and i create the pivot table based on the query itself
I have 2 fields that I need to get the sum of in the pivot table. Currently Access allow me to auto generate the sum for Quantity but when I try to automate it for the field HCReq (which is a calculated field) it automates the totals as a Count.
I need the HCReq to be of...
|
by: thomas.wordsworth |
last post by:
This is a bit of a two-part question.
1. Is there a way to control what filters are placed on a pivot chart
via vba.
I can easily change the underlying query and refresh pivot chart but
it's a big dataset and takes some time to load - my users are
impatient!
2. If this is not possible to code filters on the chart are the any
|
by: mkknerr |
last post by:
I have a pivot table that has calculated fields (by Row and or Column) and every time I try to view as a pivot chart it reverts back to the count not the calculated field. Can this be done and if so how. Thanks for your help. (this is in access 2003)
Thanks
MKK
|
|
by: Skywalker103 |
last post by:
Hello all
I have realy big problem. I have txt file linked as linked table to my mdb database. This table can contain aproximatelly 1 000 000 records (teoretically), but real count is 100-500 000 records. I have based Pivot chart on this table, but it takes maybe 2 minutes until data are accessed and prepared. Then it takes more then 3...
|
by: Skywalker103 |
last post by:
I have realy big problem. I have txt file linked as linked table to my mdb database. This table can contain aproximatelly 1 000 000 records (teoretically), but real count is 100-500 000 records. I have based Pivot chart on this table, but it takes maybe 2 minutes until data are accessed and prepared. Then it takes more then 3 minutes to refresh...
|
by: jpatton |
last post by:
How do you create/display a running sum on an MS Access Pivot Table view/chart?
When calculating the field on a query using the Dsum function, it works just fine. When selecting the pivot table view, this calculated field doesn't work as expected.
Currently using MS Access 2003.
Thank you,
J. Patton
|
by: CoreyReynolds |
last post by:
I can't find any information on this.
If I have an existing query and I want to dump it into a page on a spread sheet and modify it as a pivot table all in VBA, can I do that? I only have the code so far (that works) to dump in the data and create a chart based off it... except I have to manually alter the data I dumped in into a pivot table...
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
|
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
|
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
|