leave empty field out of report

[Ankie]

Well I have made a database with a report based on a query.
Now I don't want to show the empty field in the report.. how can I do this?
I want all the fields that are not empty show in the report, with no blank spaces...
here the database ..


Thanks for help!

Ankie

 

[KeithG]

Use Not Null in the criteria row of your query

 

[Ankie]

Use Not Null in the criteria row of your query

If I do that, the query wouldn't show anything at all..

 

[KeithG]

Why are you using the IIF function in the query.

 

[Ankie]

Why are you using the IIF function in the query.

I just thought that was a good idea...
you think it's better in a function or something like that??
I'm not so known in visual basic,.. but maybe that's better.. I don't know...
What do you proceed??