hi,
i am trying to round off the value of a text field and then append it to a decimal field, but it's giving type conversion failure, below is the query plz help :- -
IIf(Len(CDbl([a.text]))<8 And Mid(CDbl([a.text]),8,1)<>5 Or Mid(CDbl([a.text]),8,1)<1,(Round(CDbl([a.text]),3)),CDbl(Round([a.text],3)+0.001))
2  2100 
hi,
i am trying to round off the value of a text field and then append it to a decimal field, but it's giving type conversion failure, below is the query plz help :-
-
IIf(Len(CDbl([a.text]))<8 And Mid(CDbl([a.text]),8,1)<>5 Or Mid(CDbl([a.text]),8,1)<1,(Round(CDbl([a.text]),3)),CDbl(Round([a.text],3)+0.001))
Hi Durgapur,
Len(CDbl([a.text] : Len() function will be used only with string/varchar datatypes so don't convert text to decimal before checking the length [Same for other functions].
Try this -
IIf(Len([a.text])<8 And Mid([a.text],8,1)<>5 Or Mid([a.text],8,1)<1,(Round(CDbl([a.text]),3)),Round(CDbl([a.text]),3)+0.001))
Hope this helps
Please use CODE tags when posting source code:
[CODE]
Source code goes here.
[/CODE]
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Tongu? Yumruk |
last post by:
I have a little proposal about type checking in python. I'll be glad
if you read and comment on it. Sorry for my bad english (I'm not a
native English speaker)
A Little Stricter Typing in Python...
|
by: s_gregory |
last post by:
The mdb is considerable size 70 +- mb. A complex union query was
working well, but when an additional union select... was added into
the query, selecting identical fields from a different source,...
|
by: David Barger |
last post by:
Greetings,
It appears that an Append Query I run in Access XP is randomly failing
to append a field.
I have payroll data being entered into a payroll database. This data
is exported daily to...
|
by: Arno R |
last post by:
Hi all,
I have a database that I need to use in different versions of Access.
This is A97 in most places and A2k in a few other locations.
(I develop in A97 and convert the db to A2k for these...
|
by: john in fl |
last post by:
Hello Everyone,
I have an Append Query that worked fine in Access97 but now fails to
work in Access 2000. The error that occurs is that it puts null values
in a field due to a "Type Conversion...
|
by: Reedsp |
last post by:
OS: MS XP
Access version: 2003 SP2
I am trying to use an update query to replace quote marks with nothing. In essence, I'm removing quote marks. I get a error message when a field is empty or...
|
by: isben22 |
last post by:
I am a beginning developer using ACCESS 03 and Share Point Portal 2003.
I have a list of events with start and stop dates in SharePoint that I want to pass to and Access Data Base.
Ultimatly I...
|
by: Smithers |
last post by:
Are there any important differences between the following two ways to
convert to a type?... where 'important differences' means something more
profound than a simple syntax preference of the...
|
by: billa856 |
last post by:
Hi,
I am trying to insert Null value in column(ShipDate) in my table.That column(ShipDate)'s type id date/time and format is short date.
I am using "" to insert Null in that column(ShipDate)...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |
