• Access Field Management

    Author
    Topic
    #355587

    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?

    Viewing 0 reply threads
    Author
    Replies
    • #524738

      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.

    Viewing 0 reply threads
    Reply To: Access Field Management

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: