Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    May 2001
    Location
    Mount Vernon, Washington, USA
    Posts
    305
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access Field Management

    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?
    lynndelap

  2. #2
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access Field Management

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •