Converting Hexadecimal To Decimal
Apr 5, 2012How to convert Hexadecimal to decimal? I've tried use Val() to get the value but some value is not valid ....
View Replies
ADVERTISEMENT
Converting To 2 Decimal Places
May 27, 2005I would like to force a field to be 2 decimal places in the SQL view of a query as I am creating a UNION.
If is there anyway of doing this? I have tried CONVERT() & FORMAT() but I can't seem to get this to work.
Any help would be greatfully received.
Kind Regards
Carly
Simple I Hope - Converting Feet/inches To Decimal
Nov 11, 2005Hi - I am writing a small form that has a calculated field. I want to convert feet and inches in length to metres, and vice versa - so user inputs 10.45 metres, and I will have two fields giving the answer (I suppose) - one with the whole numbers before the decimal place (the feet); the other taking just the numbers after the decimal and converting them from /10 to /12 for inches. Think I can work out the reverse if anyone has a nifty way of doing this - thanks very much; I'm new to this site.
J
Queries :: Hexadecimal String To Binary
Sep 24, 2013I have a text column with hexadecimal strings like "4E1B0A65FE3299FE", ie. of length 16.I'm doing an ALTER COLUMN query to convert the column to varbinary, but Access is doing conversion by ASCII, which results in a varbinary field of size 32, I think this is because the text column is in Unicode.
SQL Server has something called "styles" which are used with CONVERT.where you can choose to convert by two characters at a time 2:1..How do I do the same in an Access query? CONVERT/CAST are no supported.
Modules & VBA :: How To Create Hexadecimal File
Sep 13, 2013I would like to read a TIFfle to ACCESS, and store its content as hexadecimal like below to further other process..., how can I achieve this change and storage??
0000: 49 49 2A 00 4E 00 00 00 80 3F E0 50 38 24 16 0D
0010: 07 84 42 61 50 B8 64 36 1D 0F 88 44 62 51 38 A4
0020: 56 2D 17 8C 46 63 51 B8 E4 76 3D 1F 90 48 64 52
0030: 39 24 96 4D 18 80 80 00 60 00 00 00 01 00 00 00
0040: 60 00 00 00 01 00 00 00 08 00 08 00 08 00 0F 00
0050: FE 00 04 00 01 00 00 00 00 00 00 00 00 01 03 00
0060: 01 00 00 00 11 00 00 00 01 01 03 00 01 00 00 00
0070: 0F 00 00 00 02 01 03 00 03 00 00 00 48 00 00 00
0080: 03 01 03 00 01 00 00 00 05 00 00 00 06 01 03 00
Round Up Decimal Point To 4 Decimal Places
Jun 2, 2005Hi there,
I am not sure the best way to do this,
I have a field with values that look like: 1.69553366385509 or 0.0061705541157596
I want these values to look like: 1.6955 or 0.0062 (4 decimal places [rounded up if possible])
Thanks for your help with this
Sue
Decimal Problem
Nov 27, 2005I am new to this forum and Access 2000.
When creating a table I want to use a field to record hours worked to the tenth of an hour. When I enter 6.7 and tab to the next field the hours record as 7. I am using field size as integer, decimal as 1 and format as general number. I have tried numerous other combinations, but whatever decimal I enter rounds to show no decimal in the table. I will use this field in calculations.
I suspect the solution is simple, but I am not having any luck. I'd appreciate some help.
Gary4
Decimal Places
Jan 10, 2007I am using an inventory software program called ERP. I am trying to have at least 8 decimal places show in all my reports/tables/etc. I have set decimal places to 8 and 8 are showing up in some the reports BUT after the 4th decimal place, the other 4 decimals default to 0 (i.e. I put .19214, but only
.19210000 shows up). In other tables only 4 decimal places are showing up (no 0 or anything after the 4th decimal place. I would greatly appreciate any help!!!
THANK YOU!!!!!!
LL
Decimal Place
Jan 27, 2007i have a statement like this:
rs![tblRecurringDefects] = f("txtTotalRecurring" & i) / f("txtTotalJobs" & i) * 100
how can i have two decimal place?
Decimal Contorl
May 14, 2007I have a table set up with a numeric field with 2 decimal places. When this table runs through a couple queries and comes out in a report - somehow the number is rounded. Where would the rounding occur - how can I stop it from happening?
View 5 Replies View RelatedDecimal Problem
Jul 20, 2007Is there anyway in a query or a form to set the amount of decimal places on a number or change it to currency. In one query im dividing a price by a mileage and I get a really long string of number and I need to make it just be two decimals.
Any ideas.
Decimal Places
Apr 12, 2005I have search the forum and cannot find an answer, can anyone please help. I have a few field in my table that have number and I would like to be able to enter decimal place numbers like 8.25.
I have set:
Field Size = 'Long Integer'
Format = 'General Number'
Decimal Places = '2'
When I go to enter a number it rounds to the whole so when I enter 8.25 it inputs 8.
Any ideas? I need the decimal to show in the query and the form and it isn't showing in any of those. I have set the query to 2 decimal places and form to 2 decimal places.
Thank you very much!
Adam
Decimal Places
Jan 26, 2006Hi all,
I want to but numbers with 2 decimal places in a field. I have the data type set to number in the desired field - yet when I copied and pasted the data over, all the numbers that had 2 decimal places lost them. The only number visible was the whole number. How can I make the numbers reatain their 2 decimal places?
Elliot
Decimal Problem
Jan 17, 2007Hi guys,
just a short question,
I want my autonum. to be in 3 decimals:
001
002
003
004
etc.
Someone has a suggestion??
Thanks a lot.
Stefan
Decimal Problem
Jan 17, 2007Hi guys,
just a short question,
I want my autonum. to be in 3 decimals:
001
002
003
004
etc.
Someone has a suggestion??
Thanks a lot.
Stefan
Decimal Number
Oct 22, 2007Hello
my problem is how to reduce decimal number of column in the tables. Problem is that some numbers are quotients and they have a lot of decimal which make a problem in the report where they have to have just 2 decimals.
Column in the query and in the report is not reserved only for numbers.
if some one have idea?
Decimal Number
Oct 22, 2007Hello
my problem is how to reduce decimal number of column in the tables. Problem is that some numbers are quotients and they have a lot of decimal which make a problem in the report where they have to have just 2 decimals.
Column in the query and in the report is not reserved only for numbers.
if some one have idea?
Decimal Number
Oct 22, 2007Hello
my problem is how to reduce decimal number of column in the tables. Problem is that some numbers are quotients and they have a lot of decimal which make a problem in the report where they have to have just 2 decimals.
Column in the query and in the report is not reserved only for numbers.
if some one have idea?
Decimal Point
Dec 14, 2005Hi
I have data numbers:
1500
60000
8900
How can I put a decimal point two from the right ie:
15.00
600.00
89.00
Thanks.........
Decimal Places
Aug 8, 2006I have values (using a make-table query) in an Currency field like £123.45.
Using an update query, I want to make these values become £123. What function, or otherwise, can I use to get this?
I have used a combination of the Round and CInt functions to do this but all I get is £123.00 not £123. I know I can change the DecimalPlaces table property to 0 to get what I want, but I am running code to do all this, hence I need an update query that will resolve the issue if possible.
Auto Decimal?
Jul 21, 2005Is there a way to make some of the entry fields in my form auto add the decimal so that when users do data entry they do not have to enter the decimal point? I can do it in excel, but I haven't figured out how to do in Access form.
I want to be able to just enter 456755 and it format correctly, when the actual number is 4567.55.
Any help for a newb would be great!
Why Cant I Get 2 Decimal Places
Nov 24, 2005I would like the users to enter values of day 2.5 however it always rounds up to 3 i have checked the propeties of the field in the table and i have set it to 2 decimal places. I have also checked the property of the field on the form and done the same. There must be something i am missing.
Thanks for lookin gand your help.
Decimal Places
Dec 13, 2004I have a query with a calculated field Qty=([tons]*[%AC]) that I need to round to three decimal places before making next calculation of total dollars ([unit price]* [Qty]). I know I can display the three decimal places by using format - Standard and decimal places 3 but it still calculates with all the decimal places of the original calcuated quantity and when the report prints showing the extended dollar amount is not what it appears it should be Qty may display18.019 but is actually calculating on 18.018737864077. I have searched this forum and access help but have not found anything to correct this problem. Any suggestions.
View 6 Replies View RelatedNo Decimal Places Box
Oct 14, 2006I am making a query in which one of the fields I want to display is a Calculated field. It is just two other fields divided. I want to display this calculated field with 0 decimal places, but when I view the properties, there is no decimal places box. There is everything else like the description, format, input mask and so on. Any ideas?
View 2 Replies View RelatedCheck For A Decimal Value!!
Oct 19, 2006How can I check whether an entered value in a textbox is a decimal value or not??
View 2 Replies View RelatedDecimal Places
Jan 17, 2007Hi, I have a column in my table that I have set as a number. I have also set decimal places to 2 but when I type in 0.75 and move to the next entry, it changes the 0.75 to a 1! How do I make it not do that? Many thanks
View 1 Replies View Related