943,740 Members | Top Members by Rank

Web Development > Databases > MS Access and FileMaker Pro > microsoft access help
Ad:
Permalink
Mar 16th, 2008
0

microsoft access help

Expand Post »
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.
Reputation Points: 10
Solved Threads: 0
Light Poster
dragon@dragon64 is offline Offline
37 posts
since Oct 2007
Permalink
Mar 17th, 2008
0

Re: microsoft access 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?
Reputation Points: 35
Solved Threads: 21
Junior Poster
HI2Japan is offline Offline
195 posts
since Mar 2006
Permalink
Mar 17th, 2008
0

Re: microsoft access help

Click to Expand / Collapse  Quote 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.
Reputation Points: 10
Solved Threads: 0
Light Poster
dragon@dragon64 is offline Offline
37 posts
since Oct 2007
Permalink
Mar 17th, 2008
0

Re: microsoft access help

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.
Reputation Points: 35
Solved Threads: 21
Junior Poster
HI2Japan is offline Offline
195 posts
since Mar 2006
Permalink
Mar 17th, 2008
0

Re: microsoft access help

i have tried with fixed, standard and general
Reputation Points: 10
Solved Threads: 0
Light Poster
dragon@dragon64 is offline Offline
37 posts
since Oct 2007
Permalink
Mar 17th, 2008
0

Re: microsoft access help

In the table you should be looking at either currency or number. The field size should be either decimal, single or double.
Reputation Points: 35
Solved Threads: 21
Junior Poster
HI2Japan is offline Offline
195 posts
since Mar 2006
Permalink
Mar 17th, 2008
0

Re: microsoft access help

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.
Reputation Points: 35
Solved Threads: 21
Junior Poster
HI2Japan is offline Offline
195 posts
since Mar 2006
Permalink
Mar 17th, 2008
0

Re: microsoft access help

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?
Reputation Points: 10
Solved Threads: 0
Light Poster
dragon@dragon64 is offline Offline
37 posts
since Oct 2007
Permalink
Mar 17th, 2008
1

Re: microsoft access help

Just ask, not sure if I can help, but I'll try.
Reputation Points: 35
Solved Threads: 21
Junior Poster
HI2Japan is offline Offline
195 posts
since Mar 2006

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in MS Access and FileMaker Pro Forum Timeline: Migrating from access to Filemaker/Copy Paste Help
Next Thread in MS Access and FileMaker Pro Forum Timeline: develop a web based application





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC