no show if Null

[juster21]

I'm trying to build a query that will look at one table and only return the fields that have values. The table has 1 record with 10 fields which is used to store parameter values.
I only want the parameters that have been selected and therefore have a value.

Thanks!!

 

[Joe4]

Queries don't quite work like that. You have to explicitly tell it which Fields to include.
If you wanted it to work dynamically and only include Fields that have values, you would probably need to use VBA to build the SQL code for the4 query dynamically, looping through the fields for the records and determining which ones to include in the construction of your dynamic query.

What is it that you actually intend to do with this query when complete?

 

[juster21]

Queries don't quite work like that. You have to explicitly tell it which Fields to include.
If you wanted it to work dynamically and only include Fields that have values, you would probably need to use VBA to build the SQL code for the4 query dynamically, looping through the fields for the records and determining which ones to include in the construction of your dynamic query.

What is it that you actually intend to do with this query when complete?

I have a report and I am trying to create a subreport that displays the criteria selected by the user.

 

[Joe4]

Depending on how you have written your report, you might be able to do something on the report level to suppress those Null entries.