Query that returns only popluated fields in a record?

[MHernan1]

Hi all,

Was hoping you could point me in the right direction. What I would like to do is have a query the returns only the populated fields on a record. I have a database that i am working where there are numerous columns but I don't want the end user to have to see all the columns when they do a query, just those that have values. They would only need to query one record at a time.

So for example:

Table 1 has four columns: "OrderID", "Apples", "Oranges", "Pears". I run a query to find a particular OrderID and only want to see the columns that have values.



Any help would be greatly appreciated.

thanks!

[June7]

Won't work. Filtering limits records, not fields. Query can't conditionally return/not return a field. Can't say 'If no data then don't include this field.'

Why are users working directly with tables/queries? You can display the record on a form then use code to hide controls bound to fields if no data.

Why would you want to do this anyway?

You have columns actually named "Apples", "Oranges", "Pears"? Does not sound like normalized structure.

[MHernan1]

thanks for the response, this exactly why i come here. I don't actually intend to have users editing the table directly, and it sounds like from your response I can accomplish what I need via a form. And no, those aren't the names of my actual columns, it was just an example I put out there.