Access Field Management

Topic

New Reply

I need to keep the relationship in one table, between three fields (columns) the same. This is for products: ID, Full Desc, Short Desc. When I run a report only the Full Desc and Short Desc that match the ID I choose should appear. How do I accomplish this?

Reply | Quote

Replies

I think you could do this in one of two ways:

Open your report in design view and delete the ID text box and label.

However a better way would be to make a query based on your products table and only show the two fields Full Desc, Short Desc. This has the advantage that you can Sort Ascending on the full description and have your report list the items in alphabetical order.

You then base your report on this query.

Reply | Quote