Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jan 2003
    Location
    Dallas, Texas
    Posts
    139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Report picking up wrong field (2003)

    I'm at a loss. I have a report that is really more of a letter. It's control source is a query called Primary Administrators. The only fields on the report/letter are:
    Person Name
    Dept
    Mail Code

    The Person Name and Dept field are picking up exactly what they are supposed to. However, the Mail Code-----. I have no idea where that field is getting its' numbers. I've checked the control for the report. It is Primary Administrators. I've checked the control for the field Mail Code. It is Mail Code. I've run the query independently ( it gets the numbers from a table) and the numbers in Mail Code are correct. The numbers showing in the Mail Code field look like the numbers in the ID field, but -- because of deletions - at least two of the numbers are not included in the ID field of the query.
    What else could it be? Where else do I look? Do I need an exorcist? <img src=/S/aflame.gif border=0 alt=aflame width=16 height=16>
    He-e-lp!

    This says 2003 - it is actually Access 2002. Thank you.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Report picking up wrong field (2003)

    If Mail Code is a lookup field, displayed as a combo box in the query, you can do either of the following:

    - Add the lookup table to the query, and replace Mail Code by the appropriate field from the lookup table.

    or

    - Change the Mail Code text box on the report to a combo box, and give it the same settings as those of the field in the table or query (look at the Lookup tab for the field)

  3. #3
    2 Star Lounger
    Join Date
    Jan 2003
    Location
    Dallas, Texas
    Posts
    139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report picking up wrong field (2003)

    Thanks Hans - See what trouble you cause yourself when you only THINK you know what you are doing. For the time being, Lookup fields remain a mystery. But I'm mailing out my report today. Thanks again.

Posting Permissions

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