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

[Marcel44]

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!

[Rabbit]

Use the Nz() function to convert nulls into another value.

[Marcel44]

Use the Nz() function to convert nulls into another value.

Thanks! I entered:

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

and it worked like a charm :)

[Rabbit]

Glad you got it working! Good luck with the rest of your project.