Thanks! I entered:
Exp1: Nz([Column3.table1],'-')
and it worked like a charm :)...
Marcel44
Last Activity: Jun 20 '13, 03:19 PM
Joined: Jun 17 '13
Location:
-
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!
No activity results to display
Leave a comment: