473,326 Members | 2,680 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Get more than two decimal places to carry over from table to query and form

I have a restaurant I am creating a DB for, and the POS system and all other revenue sources display a sales total on the reporting with tax included. I am trying to create a formula in a query, later to be reflected in a data entry form to back out the tax. I have created a tax table to use as the source for a combo box on the form. The problem I am having is our tax rate is 8.25%, so I am storing the value in the field as 1.0825 to use in my formula.

In the form I have created I have set the combo box that is used to select the tax rate to the standard and fixed number format with 4 decimal places but only the first two decimal places come across (1.08).

I have tried using different combinations of settings across my table, query and form (all the same, mixed, etc) but can't seem to get the last two decimal places to come across.

Any suggestions?
Dec 15 '14 #1
5 1593
jimatqsi
1,271 Expert 1GB
Scott,
Welcome to Bytes.com. Always glad to see new posters.

It's not clear to me if the problem is in the query retrieving data for the combo box or in the combo box Formatting of the retrieved data. Probably the query is retrieving the data just as it is.

Have you set the number of decimal places for the combo box in the Format section? It may be the setting is defaulting to two decimal places.

Jim
Dec 15 '14 #2
twinnyfo
3,653 Expert Mod 2GB
Scott,

I have also had strange experiences when using Double Data types in queries, such that it ALWAYS returns a decimal out to two places only. You should be able to change the property settings for the field in the query that is calculating so that the decimal places are extended to the fourth digit. I've had success with the calculations, but the display seems to be the rub....
Dec 16 '14 #3
NeoPa
32,556 Expert Mod 16PB
Hi Scott. Welcome to Bytes.com :-)

It seems like the problem you're having is with a ComboBox control. Why don't you give us some details of this control from the Properties sheet. It's hard to guess what it is that is causing this with so little information.

Please understand that I appreciate that you have given information. What I'm trying to do here is to point you towards the sort of information that will be helpful in order to find your problem.

Good luck.
Dec 18 '14 #4
Sorry, I set the post to email when I got replies, but never got an email. I actually got it figured out...I don't remember exactly what I changed where, but it is working as needed now. Thanks
Dec 25 '14 #5
NeoPa
32,556 Expert Mod 16PB
It's not unusual for such emails to be blocked unless you allow them specifically in your client.

Glad to hear you got the problem resolved anyway :-)
Dec 31 '14 #6

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: shez | last post by:
Hi, Is there any way to output a double value with different number of decimal places (apart from using 'sprintf'). I looked up the reference for C++ streams and found the 'setprecision'...
0
by: FOGHORN | last post by:
i have a linked table that displays a value to 2 decimal places in a query (i.e £13.11). Sounds simple...the value £13.11 is displayed in a query but when i then create a pivot table from the query...
2
by: hunslair | last post by:
This is a really basic question. I am taking a teach yourself beginners course on Access 2003 and have run into a road block on one practice. In a select query, I have created a simple calculation...
3
by: Mitramirsa | last post by:
I want to write a trigger so that rows deleted from the table are logically-deleted, rather than being actually removed. That is, such rows are marked as being deleted, rather than actually being...
2
ollyb303
by: ollyb303 | last post by:
Hi, My colleague has a db with a form linked to a table. On the form is (among many other things) a checkbox and textbox. When the checkbox is checked, the value in the textbox should be 37.5, and...
4
by: edtrvl | last post by:
Hi there, I'm trying to insert multiple rows from a table format web form into multiple rows in a SQL table, (1 row for 1 row). Any help would be greatly appreciated, thanks in advance Here's...
4
by: ChipR | last post by:
I have a table with currency fields set to 2 decimal places. My query has Percent: IIf(=0 Or IsNull(),0,/*100) Even with a balance and estimate with 1 digit decimals I'm getting 13 digits...
0
by: faisalbaf | last post by:
I m preparing a database of members of an organization for keeping the travel record only. I have three tables: tblMembersDescription, tblTravelDetails and tblManifesting. Whenever anyone comes for...
6
by: scrapcode | last post by:
Hi guys, I have a form that is checking staff names against staff numbers and I'm looking for the best way to return this data. I have up to 20 text boxes where staff numbers are entered, and...
1
by: skti89 | last post by:
My Sql Code Enter password: mysql>use database database changed; mysql>select * from table id name gender ----------------- 1 Robert Male
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.