 |  |  |  |  |  |  |  |
microsoft access help
Please support our MS Access and FileMaker Pro advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
•
•
Join Date: Oct 2007
Posts: 34
Reputation: 
Solved Threads: 0
Light Poster
hi i am trying to do a simple access database, with quantities, and a query with a report
I have create a table with one of the variables being a numeric value, but i need to have 2 decimal places. when i format with 2 decimals, what ever i type in is rounded up. Can anyone help.
I have create a table with one of the variables being a numeric value, but i need to have 2 decimal places. when i format with 2 decimals, what ever i type in is rounded up. Can anyone help.
Does the data in your table have 2 decimal places, or did you just set the query and report to display at 2 decimals?
Who was the first person to look at a cow and say, "I think I'll squeeze these dangly things here, and drink whatever comes out!"
•
•
Join Date: Oct 2007
Posts: 34
Reputation:
Solved Threads: 0
Light Poster
•
•
•
•
Originally Posted by HI2Japan 
Does the data in your table have 2 decimal places, or did you just set the query and report to display at 2 decimals?
What data type and field size do you have set in the table? Keep in Mind that some of the field sizes don't allow decimals.
Last edited by HI2Japan; Mar 17th, 2008 at 4:10 am.
Who was the first person to look at a cow and say, "I think I'll squeeze these dangly things here, and drink whatever comes out!"
•
•
Join Date: Oct 2007
Posts: 34
Reputation:
Solved Threads: 0
Light Poster
i have tried with fixed, standard and general
In the table you should be looking at either currency or number. The field size should be either decimal, single or double.
Who was the first person to look at a cow and say, "I think I'll squeeze these dangly things here, and drink whatever comes out!"
Long integer which is the default for number data type, while it will show 2 decimal places if you set it , it cannot actually read them.
Who was the first person to look at a cow and say, "I think I'll squeeze these dangly things here, and drink whatever comes out!"
•
•
Join Date: Oct 2007
Posts: 34
Reputation:
Solved Threads: 0
Light Poster
Thanks it worked, i used field size as double, format as standard and decimal places as 2.
Since you are so good at this may i ask another question?
Since you are so good at this may i ask another question?
|
Similar Threads
- linking database Microsoft Access with VB.NET (VB.NET)
- Microsoft Access Field Format ??? (Windows Software)
- Is it possible to display report in Visual Basic which is created in Microsoft Access (Visual Basic 4 / 5 / 6)
- how to retrieve the Microsoft Access DAtabase from the INternet using web services (VB.NET)
- I hava trouble with Microsoft Access database, Pls help me. (Java)
- Microsoft Access Format/Validation ??? (Windows Software)
- Upgrading to Microsoft Access 2002 (MS Access and FileMaker Pro)
Other Threads in the MS Access and FileMaker Pro Forum
- Previous Thread: Migrating from access to Filemaker/Copy Paste Help
- Next Thread: develop a web based application
Views: 1290 | Replies: 8
| Thread Tools | Search this Thread |
Latest MS Access and FileMaker Pro Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
Tag cloud for MS Access and FileMaker Pro
