•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS Access and FileMaker Pro section within the Web Development category of DaniWeb, a massive community of 373,364 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,632 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS Access and FileMaker Pro advertiser:
Views: 677 | Replies: 8
 |
•
•
Join Date: Oct 2007
Location: malta
Posts: 18
Reputation: 
Rep Power: 1
Solved Threads: 0
Newbie Poster
microsoft access help 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.
•
•
Join Date: Mar 2006
Location: Japan
Posts: 122
Reputation:
Rep Power: 3
Solved Threads: 12
Junior Poster
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
Location: malta
Posts: 18
Reputation:
Rep Power: 1
Solved Threads: 0
Newbie 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?
i have 2 decimal places in the form, the table and the query. what happens is that if for example i input 1.34, the figure will show as 1.00, and if i post 1.89 it will show as 2.00.
•
•
Join Date: Mar 2006
Location: Japan
Posts: 122
Reputation:
Rep Power: 3
Solved Threads: 12
Junior Poster
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 3: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
Location: malta
Posts: 18
Reputation:
Rep Power: 1
Solved Threads: 0
Newbie Poster
i have tried with fixed, standard and general
•
•
Join Date: Mar 2006
Location: Japan
Posts: 122
Reputation:
Rep Power: 3
Solved Threads: 12
Junior Poster
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!"
•
•
Join Date: Mar 2006
Location: Japan
Posts: 122
Reputation:
Rep Power: 3
Solved Threads: 12
Junior Poster
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
Location: malta
Posts: 18
Reputation:
Rep Power: 1
Solved Threads: 0
Newbie 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?
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb MS Access and FileMaker Pro Marketplace
Linear Mode
•
•
•
•
advertising ajax antivirus apple browser business code computer console development dos exploit firefox game google hardware ibm internet ip ipod linux microsoft mobile mozilla mp3 news novell office open openoffice operating os pc ps3 red hat security software source survey system ubuntu upgrade virus vista web windows xbox 360 xp yahoo zune
- linking database Microsoft Access with VB.NET (VB.NET)
- 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)
- Microsoft Access Field Format ??? (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
