Help on Report

[cbende2]

Hello all!



I'm having difficulty creating a report.

Let's assume I have 5 records with 5 fields.

record1, record2, record3, record4, record5, and field1(primaryKey), field2, field3, field4, field5.

Not every field has data in it(meaning it is either null or blank).

I would like for a report to display the field1(primaryKey) field, and any other field that is blank or null in that record.

I was thinking about putting 5 unbound textboxes(TextBox1, TextBox2, TextBox3....) on a report and putting some code that does the following:

If field1 is not null 
Then go to next field
Else 
TextBox1 = field1

this code would need to loop through each field and also increase textbox number after a textbox is assigned a certain fieldname

Any ideas??

Also, my database is normalized, the reason why some fields are blank is simply because we are tracking a process that is over a period of time. Therefore some fields are filled out way before others.

[orange]

you could try using this as the record source of your report. (untested)
I believe you want to display the PK for the records with some empty field(s)

Select ID,your field list from yourTable 
where
len(field1 & "") = 0 or
len(field2 & "") = 0 or
len(field3 & "") = 0 or
len(field4 & "") = 0 or
len(field5 & "") = 0 ;

[cbende2]

I believe you want to display the PK for the records with some empty field(s)

Yes! That's exactly what I would like!

For the SQL you gave me, is that assigning unbound textboxes with the field? I don't understand how that query accomplishes what I'm asking.

I'm still a newcomer when it comes to SQL and VBA.

[orange]

Use the report wizard with that query. It should build a report at least a starting point.

Why do you want a report--what about just running the query and see what results?

[cbende2]

My boss would like for only the fields that are null to display for each individual record.

I'm just trying to make the man happy ya know!