473,652 Members | 3,039 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Access and Blanks

5 New Member
I am starting a small program using Access and would appreciated a bit of help with the following;

In Queries I have built a short Expr1 as follows:

Expr1:([FrameLgt]>=3.2,[FrameLgt]*[SteelRate])

Now if the Value is 3.2 or above the Expr1 returns a result but if the value is below 3.2 the Expr1 returns a Blank.

How do I avoid getting a Blank?

Regards

John
Sep 18 '06 #1
1 1501
akhenaton42
5 New Member
use IIF statement -

Expr1:IIF([FrameLgt]>=3.2,[FrameLgt]*[SteelRate],[write here whatever you want returned])



I am starting a small program using Access and would appreciated a bit of help with the following;

In Queries I have built a short Expr1 as follows:

Expr1:([FrameLgt]>=3.2,[FrameLgt]*[SteelRate])

Now if the Value is 3.2 or above the Expr1 returns a result but if the value is below 3.2 the Expr1 returns a Blank.

How do I avoid getting a Blank?

Regards

John
Sep 18 '06 #2

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

Similar topics

1
1697
by: Brad L. Meyer | last post by:
Hi all! Happy Holidays to all! I work for a nonprofit 501.3.c case management agency. All of the computers have MS ACCESS database software installed. Is it possible to recreate agency forms in access (complete with logos) and have Access complete needed forms? For example: We take some identifing information at the first contact.
9
1601
by: HelmutMunich | last post by:
Hello, I am Helmut, my database for multiuser is Frontend/Backend. The turnover file is browsed by VBA for Article numbers to be found in the article table. I use DAO 3.6 lib. The sql Statement uses the article number of the turnover file - with 29 Fields. After record 187 or so, the Article number, read from the turnover file shows only a string of ten blanks.
64
5212
by: John | last post by:
Hi What future does access have after the release of vs 2005/sql 2005? MS doesn't seem to have done anything major with access lately and presumably hoping that everyone migrates to vs/sql. Any comments? Thanks
2
3151
by: JohnR | last post by:
When creating an msAccess db within the Access UI itself the fields that are text are NOT padded with blanks. For example, if I have a 10 char field and put in "HI" and then when I come back to the field and click my mouse on it the cursor is just after the "I" in "HI"... that is, no blanks were added to the field. However, when I create an MDB database programatically in VB.Net using ADOX and create the tables using SQL stmts (ie:...
34
4092
by: Registered User | last post by:
Hi experts, I'm trying to write a program that replaces two or more consecutive blanks in a string by a single blank. Here's what I did: #include <stdio.h> #include <string.h> #define MAX 80
2
3661
by: Manah | last post by:
I currently receive text files that need to be manipulated into a suitable format for uploading into a Pervasive/Btrieve datafile. The text file I receive needs a number of steps to clean it up and so I set up an Access database to perform all the steps and would like to link the output directly to the database table rather than exporting to text and manually importing into the pervasive database table. I have linked the pervasive data table...
49
4338
by: Allen Browne | last post by:
If you are looking for opinon on what's useful in Access 2007, there's a new article at: http://allenbrowne.com/Access2007.html Covers what's good (useful features), what's mixed (good and bad), what's gone (features removed), what's fixed (old issues solved), what's broken (new bugs), configuration, compatibility, should you buy, and links. It is opinion, so you may disagree, but hopefully it's an informative summary.
10
2805
by: Diego F. | last post by:
Hi all. I have an application that receives a message from a socket in an array from a certain size. As the array size may be longer that the message received, the end of the array has blank characters. I use the System.Text.Encoding.ASCII.GetString method to convert to string and insert in a database. The problem is that in the database the blanks are inserted as well. How can I remove the blanks before inserting in the database?
6
1728
by: guinnie | last post by:
I'm trying to update a table (67024_G03_03012004 ) by matching on the name column in another table (blanks) field. These columns are the same. I can't get it to work. Any help would be appreciated ! Here is my SQL: UPDATE 67024_G03_03012004 SET 67024_G03_03012004.Student_OEN = (select . from where .=.);
4
1507
by: eBob.com | last post by:
I have a RichTextBox in which I'd like blanks to appear different from nothing. Imagine a file which does not fill up the RTB. You can't tell how many, if any, blanks might follow the last visible, i.e. non-whitespace, character. I thought that I could set the BackColor of the RTB to LightGray and then the blanks would show up as white. But instead the characters show up on a LightGray background and the blanks, of course, show up as...
0
8367
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8279
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8703
jinu1996
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8467
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
1
6160
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4145
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4291
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1914
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
2
1591
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.