Hide row in table if field is blank

[spids101]

Hello there,

Been lurking around the forum for while now and glad I found it. Its been great help for creating my database, thanks so much.

I have run into some problems though. I have one main table where all the details of users are imported, I have created several queries for different types of courses users sign up for. I would like that when I select a query it only shows the users who signed up for certain course.

So basically what I would like to do is if a field is empty or null to hide the whole row.

Sorry if I havent been very clear.

Thanks in advance for any help.

 

[BlueIshDan]

You're taking the wrong approach... well half way lol.

You're going to have to change the query up to filter by course.

If you wish to, you could create a combo box in the form header that displays all the distinct course names. On the selection of a course it would filter the query results by the selection.

 

[spikepl]

So basically what I would like to do is if a field is empty or null to hide the whole row.

That is Excel-speak, not Access database.

Find and do a tutorial on queries - the best half-hour investment you can do.

 

[spids101]

Thanks guys I will try your advice

 

[spids101]

Awesome got it working

Thanks so much