RE: connecting fields in mulitple tables

Tech-Archive recommends: Fix windows errors by optimizing your registry

Post the SQL of the query as it is now.
--
Dave Hargis, Microsoft Access MVP


"buscher75" wrote:

I was wrong, it does not show an error, it returns zero records when you run
the query. Under one serial number I want to show the three operators that
worked on that unit with their names not their badge numbers.

"Klatuu" wrote:

It shouldn't be necessary to include the operator id 3 time is the query as
output. They are only needed in the Join. What error are you getting?
--
Dave Hargis, Microsoft Access MVP


"buscher75" wrote:

Hello, I have three tables that collect data. Each has an operatorID field.
I then have a table that has the operatorID and the operator's name.

Ultimately, I would like to produce a summary report pulling the operatorID
from each table and show the persons name not their ID. A field called
“SerialNumber” connects all three data collection tables through a
relationship. I can successfully show the employee’s name with one
operatorID field in the query, but get an error trying to run the query when
all three table's "operatorID" fields are listed. What am I doing wrong? Do
I need 3 different queries and then pull from each query in the report? Or,
is there a way to convert the information within the report?

I appreciate your help.

.

Relevant Pages

  • RE: connecting fields in mulitple tables
    ... Dave Hargis, Microsoft Access MVP ... the query. ... I then have a table that has the operatorID and the operator's name. ...
    (microsoft.public.access.queries)
  • RE: connecting fields in mulitple tables
    ... the Green Tag name should be on the left side of the table name ... Dave Hargis, Microsoft Access MVP ... the query. ... I then have a table that has the operatorID and the operator's name. ...
    (microsoft.public.access.queries)
  • Re: MS Access 2003 Record Filter Problem
    ... What are the data types of OperatorID and TransactionTime in the ... Microsoft Access MVP ... When I Execute Query filtering on the Operator ID ...
    (microsoft.public.access.queries)
  • Re: Group String data
    ... SELECT operatorID, MIN ... ID STEP_RESULT Dut_ID Operator Project Temperature TestCase ... I am using following query ...
    (microsoft.public.access.queries)
  • RE: Tables and Forms
    ... Dave Hargis, Microsoft Access MVP ... record source of my form to go to the query. ... You will see the name of the table in the Record Source property. ...
    (microsoft.public.access.gettingstarted)