how to show only not null values in the query

[MHD-SH]

Hello friends!

I got a problem, I have accounting sheet with particulars, dates, and both debt and credit accounts, I need to make quires for both sides debt and credit, it's easy by using not null statements, but want the query to show only the not null values not the whole record and hide the empty cells. how to do it ?


I don't know if I explained myself well




thx in advance

[orange]

Without seeing your query and the table(s) involved it is difficult to offer a focused response.

I suggest you copy the sql of the query you are currently using and post it.

Also, it would clarify things, if you could provide readers with a sample input record, and an example of what you want for output from that record.

Good luck.

[MHD-SH]

thx dear

as in the pic, in every record I have 2 values, I want the query to show them only and hide the rest.

the SQL I use is:

Select a, b, c, d, e from table name
where a is not null or b is not null or c is not null or d is not null or e is not null;

but in this case access show to whole record, and that's the problem.

I guess I need some .net statement to deal with this issue.

thx again

[alansidman]

Please show us what the end result should look like using the example you provided

[MHD-SH]

I want the result to be:
record 1: a and e only not the whole record
record 2: a and d only
record 3: a and c

[alansidman]

In your table, are there only five five fields and will Field a always be populated?

Maybe this:

SELECT tblABCDE.A, tblABCDE.B
FROM tblABCDE
WHERE (((tblABCDE.B) Is Not Null));
Union
SELECT tblABCDE.A, tblABCDE.C
FROM tblABCDE
WHERE (((tblABCDE.C) Is Not Null));
Union
SELECT tblABCDE.A, tblABCDE.D
FROM tblABCDE
WHERE (((tblABCDE.D) Is Not Null));
union
SELECT tblABCDE.A, tblABCDE.E
FROM tblABCDE
WHERE (((tblABCDE.E) Is Not Null));