Help Removing Empty Fields From Reports

[levio]

I am helping a lawn care business set up an Access database. I would like to make a report that shows each customer and the jobs that are preformed for them. I don't want the jobs that are not preformed (blank Fields) displayed under that customer. I think I might have to do it through VBA, but am very unfamilar with it. Does anyone have some help for me?

 

[Remou]

If your database is normalized*, you should be able to do this with a query.

*

http://www.r937.com/relational.html

 

[levio]

The database is normalized to where the owners want it, and I can create a report that shows ALL services, I just wan to hide the services that do not have data stored in them for that customer.

 

[dhookom]

I would normalize the data with a union query where each non-null "job" creates a record in the query. Then possibly create a subreport based on the union query.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[JoeAtWork]

I just wan to hide the services that do not have data stored in them for that customer

If your database is indeed normalized then you should be able to create a query that joins the Customer table to the ServicesPerformed table joined to the Services table.

[tt]

ServicesPerformed
ServicePerformedID Services
Customers ServiceID-------------------ServiceID
CustomerID--------CustomerID
[/tt]