Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jul 2001
    Location
    Florida, USA
    Posts
    394
    Thanks
    0
    Thanked 0 Times in 0 Posts

    ID instead of Name in report from Query (Office 2000)

    Hi,
    I'm trying to prepare a report from a query. The query looks fine in datasheet view but if I try to build a report from it, the report shows the ID number (from autonumber) instead of Customer name.

    I'm confused, <img src=/S/confused.gif border=0 alt=confused width=15 height=20> if the query looks fine in datasheet view, why is it giving me something else in the report?

    Thanks,
    Louise

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ID instead of Name in report from Query (Office 2000)

    Hi Louise,

    You probably use a lookup table for the field in the table. The field in the table store your ID number. In the query there is a automatic lookup that don't work in the report.
    In the query, add your Customer table. Link the tables by the ID's. Add the customer name to the query and use this field in your report.
    Francois

  3. #3
    3 Star Lounger
    Join Date
    Jul 2001
    Location
    Florida, USA
    Posts
    394
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ID instead of Name in report from Query (Office 2000)

    Hi Francois!

    That worked. <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23> Thanks!
    Louise

Posting Permissions

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