473,385 Members | 1,445 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,385 software developers and data experts.

How to Display Null Values as dashes in a MS Access Query

I'm trying to display a null value as "-" (dash) in an MS Access query. How do I do that? Show Column3 in the example below as "-" instead of blank.

Example:

Column1 Column2 Column3 Column4
8:00 8:05 Null 8:15

Any help would be very much appreciated :)
thank you!
Jun 17 '13 #1
3 1353
Rabbit
12,516 Expert Mod 8TB
Use the Nz() function to convert nulls into another value.
Jun 17 '13 #2
@Rabbit

Thanks! I entered:

Exp1: Nz([Column3.table1],'-')

and it worked like a charm :)
Jun 17 '13 #3
Rabbit
12,516 Expert Mod 8TB
Glad you got it working! Good luck with the rest of your project.
Jun 17 '13 #4

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

Similar topics

3
by: Ian | last post by:
Hi everyone, I have been working on a database to overhaul the maintenance job system here, and Ihave hit a problem when developing a query. I have a table listing the details of each job and a...
4
by: dennis.joseph | last post by:
Hello Everyone, I have scoured through a million messages (ok...thats a bit exaggerated) but I just cannot figure out how to display null values in a query. I have tried Nz, IIF, Count(*) but it...
8
by: whocracks | last post by:
hi... can you tel me how to insert null values in Access table using Vb code.... actually i want to store record having some fields with null values...plz....... i mean error is in query...
11
by: Birky | last post by:
I have an issue where I can’t figure out how to open a form where all the objects within are nulled out until a user selects an appropriate Project Name. My form has several objects (12) within which...
6
by: NiteshR | last post by:
Hi, I am using C# code to retreive values from a table in sequel. This is done using a join between a table containg values and one using dates. The problem is that I am unable to retrieve a value...
0
by: Harshit | last post by:
Hi !!! I am having Two webforms in ASP.NET. a) SourcePage.---- 1 Textbox,1 Button b) DestinationPage. ---- 1 Gridview In the SourcePage I am going to give an input in the textbox and after ...
5
by: Nobby | last post by:
On a crosstab query, I often produce reports that show Counts of values. the problem that I have is that where there are no counts, no values are returned i.e. there are blank cells. Is there an...
5
by: ravindarjobs | last post by:
hello friends, i am using ms access 2003. i have a form. and i want to show the results of a query output in the form. the query is dynamic. it changes often. for this purpose data grid...
3
by: BurtonBach | last post by:
I previously wrote the following query which gives me that data I wanted and currently returns 436 records: SELECT qryTonnageSelect.Jobs_Job_ID, qryTonnageSelect.SumOfTransactions_TonsNetWeight,...
3
by: Gareth Jones | last post by:
Hi, I have the following line in the critera of a query Like "*" & !! & "*" This works fine when there is a value/data in each field, however when there are fields blank, it will not...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
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,...
0
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...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
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
0
BarryA
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...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

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.