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.
I am using Access 2003.
Your help will be much appreciated.
Eskil 2 5641
Open your pivot table form in design view, select the calculated control(s)
that you want formatted, view properties, then set the Format to fixed or
standard, and Decimal Places to the required number. Close, save and view;
your controls will now show the decimal precision that you specified.
-Ed
"eskil" <es********@hot mail.com> wrote in message
news:11******** *************@o 13g2000cwo.goog legroups.com... 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.
I am using Access 2003.
Your help will be much appreciated.
Eskil
As far as I can see this doesn't work. Changing the field to fixed
only puts .00 on the end - eg 2 now shows as 2.00 not 2.34 as it really
should be.
Ed Robichaud wrote: Open your pivot table form in design view, select the calculated control(s) that you want formatted, view properties, then set the Format to fixed or standard, and Decimal Places to the required number. Close, save and view; your controls will now show the decimal precision that you specified. -Ed
"eskil" <es********@hot mail.com> wrote in message news:11******** *************@o 13g2000cwo.goog legroups.com... 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.
I am using Access 2003.
Your help will be much appreciated.
Eskil This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Bajal Mohamed via SQLMonster.com |
last post by:
I am facing problem like;
We generate reports thru Excel Pivot table. The data is coming from sales
cube. Let?s assume that there are 2 products A and B. The user wants to
filter for each product and view ?stock in hand? and ?total sales? for
particular month (as two columns).
From the Pivot table filtering, when we choose product A and month ?Jan?,
it is showing values for ?stock in hand? and ?total sales? columns for that
month.
|
by: Brian Andrus |
last post by:
Ok. I upgraded to MS Access 2003 recently and now I am having great
heartache.
In Access 2002, when I opened a table to view the data, there were
wonderful little "plus" signs that I could click on for each record
that would open up the corresponding record in any linked table. I
could drill down and edit/add records in a most efficient and simple
manner.
In Access 2003, this is GONE! ARGHH!
|
by: Jerome Ranch |
last post by:
I consider myself an Excel PT wizard of sorts, but now I have a
situation with so much infromationthat I need to categorize and
summarize, that I will use access to manage it.
Interestingly, though, the pivot tables in excel 2003 do not resemble
the pivot tables in access 2003 as closely as they did previous
versions of the products.
One of the most powerful features for me is the grouping function.
In excel 2003 if one right clicks date...
|
by: Jerome Ranch |
last post by:
Okay
So I've got pivot tables setup in Access 2003.
Only about 30K records in the current 2005 databases...the pivots
summarize the info in a number of nice ways.
I need to get the pivot tables into a document so I can distribute the
tables, as is, as an electronic report (without the detailed data)
So I export to rtf and xls, and I get an error that there is a too
much information. I don't want all the data, just the summary table!
|
by: Decreenisi |
last post by:
Hi,
I have to convert an existing spreadsheet for rejects into an access
database. My problem is I use a load of lookup tabels in excel. How do
I approch this in access. Also, just a general question, can you do
pivot tables in access.
Thanks
| |
by: Pourya99 |
last post by:
Hello,
I have an Access Data Access Page which has a pivot table. The data source of the pivot table is a SQL database table. The data in the pivot table itself is not a problem.
I have a text box below the pivot table. Let's say the pivot table has: First Name, Last Name, and Address. When I click on a record in the pivot table, I want the Address for that selected record to be displayed in the textbox below.
What I have currently...
|
by: Adu |
last post by:
Pivot Tables
--------------------------------------------------------------------------------
Hi guys,
I have two questions:
First Question: I have created a Pivot Table on my Access database. I don't know much about them. However anytime I click the button on my form to view it. It gives me a form view results instead of Pivot Table view. I check the properties and it is set to Pivot Table. What should I do?
The second question is...
|
by: benchpolo |
last post by:
I have data extracted from Access db to Excel with a pivot table. Somehow, I am having issues with the pivot table were it doesnt update the totals. For example, the first extract i did in Access has 6000 data rows and pivot table in excel should refresh on open and reflect the 6000 data rows.
2nd extract in Access has 10000 data rows when pivot table opens it doesn't refresh the summary count on the pivot table based on the 10000 data...
|
by: mld01s |
last post by:
I really need help!!! I dont know if its possible to share pivot tables, or see pivot tables in other machines that the one where the tables were created.
This is what happens:
I created a database to track different daily results. In a form in that database I added a pivot table, this table lets me see the results, sort them, and everthing a pivot table should let users do. Below the pivot table on the same form I have some fields for...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
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 choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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 launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
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.
| |