remove fields from query without data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

i use a build sql sentence to make a result table, which i use to match data out in a result query. But in the case that some fields are blank (null data) i dont want these to be shown in the output file.. is there a way to achive this?

newbie
 
Hi, and thanks for your response.

I have query that contains many fields. The result of this query im presenting for the user by different methods, and various data is nesesary in different situations. Therefore i wish to remove any fields within a record if that fields dosent contain data. So my question is how to remove the empty fields within the record if they are empty

newbie
 
The answer is you can't do this in any one query. The Select List is the Select list.

You could do something like this in a report or on a form in single (not
continuous) mode. You would need vba code that would check each field and then
hide or show the associated control. In addition, you would probably want the
code to move the specific controls around.

I do wonder why you would do this. If you are displaying the information to the
user, they would normally want it to be consistent. If some bit of information
was missing in record 1 and was in records 2 and 3, I would want to see that
record 1 field 1 was blank by seeing a "hole" in the data display.

If what you are saying is that you have one base query and want to show various
combinations of the fields depending on which "method" you are using, then I
would suggest that you need to base various forms (or reports) on the base
query. You can choose which fields to display in each form and report.
 
Back
Top