Forum Discussion

CShewear's avatar
CShewear
Copper Contributor
Dec 28, 2023

Printing Customer Information from a Customer ID

I am setting up a database.  I would like to know how I can print a customer name by just showing the customer ID.   Is this possible?   Thank you.     CS
access
Tom_van_Stiphout's avatar
Tom_van_Stiphout
Steel Contributor
Dec 28, 2023
Create a report query, joining the 3 tables. Then base your report on that query.
CShewear's avatar
CShewear
Copper Contributor
Dec 28, 2023
Thank you. I don't believe I have ever queried reports. But I will give it a shot. Thanks for the guidance.
  • George_Hepworth's avatar
    George_Hepworth
    Silver Contributor
    Dec 28, 2023

    CShewear 

    PMFJI: " I don't believe I have ever queried reports"

    That's not what is happening.

     

    What Tom is suggesting is a query based on the relevant tables.

     

    That query then is used as a report's recordsource.

     

     

     

     

    • CShewear's avatar
      CShewear
      Copper Contributor
      Dec 28, 2023
      Thank you for clarifying. I will see if I can do that.
      Sincerely,
      CS
  • Tom_van_Stiphout's avatar
    Tom_van_Stiphout
    Steel Contributor
    Dec 28, 2023
    Check out the aforementioned Northwind Starter Edition. You'll see qryrpt* queries, corresponding to rpt* reports.