|
|
to many decimal places..
I have calculations that are done on the form and seen on the report.
On the form and Report, the decimal places are extended to 8 places.. i have
went under properties and changed it there and also under design in the table
from which the information comes. Is there something I am missing??
Thanks
LA
--
Message posted via http://www.accessmonster.com
|
|
0
|
|
|
|
Reply
|
 misschanda
|
10/5/2007 5:48:49 PM |
|
Hi -
You don't need to change anything in the table. For the forms and reports,
change the properties of the controls to Format = Fixed and Decimal Places =
2 (or however many you need). Neither of these changes will affect the data
in the source tables.
HTH
John
misschanda wrote:
>I have calculations that are done on the form and seen on the report.
>On the form and Report, the decimal places are extended to 8 places.. i have
>went under properties and changed it there and also under design in the table
>from which the information comes. Is there something I am missing??
>
>Thanks
>LA
--
Message posted via http://www.accessmonster.com
|
|
|
0
|
|
|
|
Reply
|
J_Goddard
|
10/5/2007 6:05:30 PM
|
|
thanks alot. worked great!!!
J_Goddard wrote:
>Hi -
>
>You don't need to change anything in the table. For the forms and reports,
>change the properties of the controls to Format = Fixed and Decimal Places =
>2 (or however many you need). Neither of these changes will affect the data
>in the source tables.
>
>HTH
>
>John
>
>>I have calculations that are done on the form and seen on the report.
>>On the form and Report, the decimal places are extended to 8 places.. i have
>[quoted text clipped - 3 lines]
>>Thanks
>>LA
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200710/1
|
|
|
0
|
|
|
|
Reply
|
misschanda
|
10/5/2007 7:10:54 PM
|
|
|
2 Replies
304 Views
(page loaded in 0.099 seconds)
Similiar Articles: Too many decimal places in Pie Chart - microsoft.public.access ...I'm generating a pie chart using the output of a query. In the Design View of the query, I selected the field containing the distribution and set its ... Too many decimals - microsoft.public.access.formscoding ...Too Many Decimal Places In Mail Merge | MS Access [Archive] Too many decimal places in mail merge General Too many decimal places - Excel Help Forum Too many decimal ... Displaying decimal places in Access - microsoft.public.access ...Can I pursuade Access to show me decimal places on data I have already entered. At the moment everything gets rounded up or down. I've done what i... 0 Decimal places/round function. - microsoft.public.access ...Some of these will return results with many decimal places. The textboxes on the form have zero decimal places specified but it doesnt seem to matter. Decimal places in mail merge - microsoft.public.word.docmanagement ...Discussion on Mail Merge shows too many decimal places | TechRepublic In Word 2003, I am experiencing a problems using mail merge with an Excel data source. How do I truncate decimal places on a merged field? - microsoft ...I'm creating a Word template with merged fields. One of the incoming fields is numeric with several decimal places (40.96670). I want to truncate ... How do I stop rounding of my calculation results. - microsoft ...I have a calculation that is being rounded, much to my dismay. I tried setting the decimal places to 2 in the table and yet my results are still ... Years of Service Calculation to 2 decimal places - microsoft ...Hi there In my database, I have used the following calculation to determine a person's years of service. YearsOfService: DateDiff("yyyy",[Hire... Form Rounds up Decimal numbers, WHY? - microsoft.public.access ...Decimal/Percentage to Whole Number - microsoft.public.excel.misc ... Form Rounds up Decimal numbers, WHY ... Too many decimal places in Pie Chart ... in which you will ... Currency and the number of decimal places - microsoft.public ...I would have thought that by limiting the property of the field to 2 decimal places then only 2 places could be entered. Wrong! I'm looking for a quick and easy way to ... Calculate pi to one million decimal places - CodeProjectSo 10 times as many decimal places will take about 100 times as long. My 7,000 MIPs PC took about 15 hours to calculate the first 1,000,000 decimal places of pi. Too many decimal places - Microsoft AnswersI wrote a query to sum results and count the # of time the questions was asked then I divided the result by the # of times the question was asked. Q1_Sum: Score ... Decimal Places — FactMonster.com - Fact Monster: Online Almanac ...See examples of decimal places from millions to millionths and how to add and subtract them. Too Many Decimal Places - Java | Dream.In.CodeToo many decimal places: ... Hello everyone I am in a Java programming online class so my professor is 0 help. SUM returning too many decimal placesSQL Server 2008 - I'm summing a column (REAL datatype) that contains numeric values that all have exactly two decimal places (i.e. 342.51). But when I SUM ... 7/16/2012 10:54:40 PM
|
|
|
|
|
|
|
|
|
Search |
Post Question |
Groups |
Stream |
About |
Register
38 followers. 