Omit fields with no data

[poppyrock]

I need to create a report which will display rental information on only those items that the client wants. I haven't figured out how to include the fields for which data is entered, and not those which are null without excluding all info for the client

 

[Remou]

Have you read

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

I think you will find that you need a table of customers, a table of rental items, and a table that shows which customers have rented which items:

[tt]CustomerRentals
CustomerID ) Primary Key
RentalItemID )
<... etc ...>[/tt]