eliminate null fields

[brobb56]

I have a report were data is

Borrower Report ID Form1 year1

I want the data to be

Borrower Report ID Form1 year1
Borrower Report ID Form2 year2
Borrower Report ID Form3 year3
Borrower Report ID Form4 year4

I do not want borrower and report id to show unless there is data in form 2, 3, or 4.

I can send you a copy of the db to get as better idea. I am a novice so please be kind.

 

[randy700]

What is the query used to generate the report?
Does it include a WHERE clause?


Randy

 

[brobb56]

The query is with borrower, report id, year and form all on the same table. It does not contain a where claus.

 

[dhookom]

brobb56,
Can you share your significant table and field names as well as any relationships?


Duane
Hook'D on Access
MS Access MVP

 

[randy700]

WHERE Trim([Form] & "") <> "" AND Trim([Year] & "") <> ""

You should probably use better field names because, I believe, Form and Year are reserved words in Access.


Randy

 

[brobb56]

The table I use has Borrower and is in relation to another table that has form1, year1, form2, year2, form3, year3, form4, year4. Randy700, where wiould I put the expression you wrote?

 

[randy700]

Post your current query.


Randy

 

[dhookom]

It looks like your table is a spreadsheet and not a normalized, relational database.

Duane
Hook'D on Access
MS Access MVP