var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: ignore blank field in reports
I ran a query that has some fields that are empty. Now I want to create a report from that query. I want it to ignore the empty fields and connected label box, but I want to capture the rest of the data from the record. If I use the criteria in the query it does not give me the whole record.
Edit your query to discard null fields
WHERE nullField IS NOT NULL
What do you mean by ignore the null fields and labels but keep the record?
So .. go to the design view of my query and under criteria enter
WHERE Circuit1 IS NOT NULL
Do this for each of my 20 fields…
WHERE Circuit2 IS NOT NULL
(1 record has 20 fields that can be populated.)
Uh.. Maybe I don't understand what you're doing here.
what are these 20 fields,
What do you mean by "one record"
I have a database set up that is for testing circuits.
so line 1 or record 1 consists of the results of 1 test. These circuits may be on (blank) or off (Off).
SO... record 1 looks like this:
Circuit1 Circuit2 Circuit3 Circuit4
Record 1 MISSING OFF
Record 2 OFF OFF OFF
Record 2 OFF MISSING
My Query mirrors the table.
I want a report that will only tell me the fields that are populated. I don’t want to have any of the labels or the blank spaces on my report.
Circuit1 MISSING Circuit 3 OFF
Circuit1 OFF Circuit2 OFF Circuit 4 OFF
You see how just unchecking the show box on the query will not work for me.
Lets try this a different way.
Post your exact table structure, and query SQL
Did you see my reply to your other similar post about..."unchk box won't do" ???? Find that post and try the suggestions I input for you. Just might work.
yes I saw your posting. I already have it configured for the box to come up blank. What I want is for the report to skip or hide the label box also if the answer is null.
I think in the OnFormat event you could get away with:
label1.visible = checkbox1.value
label2.visible = checkbox2.value
Easier than 30 if statements if it works.
Last edited by pootle flump; 05-06-04 at
Reason: Tab error