access query issue....is it possible?

[tina.boroff]

Hello Everyone

I have a database that I am using with Frontpage. Users update this
database in Frontpage via ASP pages. I am now setting up a page for the
database to be edited......so here is the access question.

I have 2 tables. One is the main one Results and contains
Name, VNumber, Problem, Date, etc.
and the other is machinedata and contains VNumber, MachineDescription,
MachineSerialNumber, etc.

On the main one the user must input a VNumber. That VNumber relates to
the VNumber in MachineData. The record associated with the VNumber in
MachineData also give detailed information about the machine.

I need to find a way to have a table or query that looks at the current
Results database and pulls all of the records entered. Then it looks
at the VNumber and matches it to the VNumber in MachineData and
automatically adds in the detailed information (serial numbers,
description, etc). I have tried to do this with a query but it does
not want to put it all in one table/query so that I can use it in
frontpage.

Here is my data for the VNumber query:
SELECT MachinesData.MachinesVNumber, MachinesData.VDescription,
MachinesData.VManufacturer, MachinesData.VModel, MachinesData.VSerial,
MachinesData.VLocation
FROM MachinesData
WHERE (((MachinesData.MachinesVNumber)=(Results.VNumber) ));

[ByteMyzer]

<ti*********@gmail.com> wrote in message
news:11**********************@g49g2000cwa.googlegr oups.com...

Hello Everyone

I have a database that I am using with Frontpage. Users update this
database in Frontpage via ASP pages. I am now setting up a page for the
database to be edited......so here is the access question.

I have 2 tables. One is the main one Results and contains
Name, VNumber, Problem, Date, etc.
and the other is machinedata and contains VNumber, MachineDescription,
MachineSerialNumber, etc.

On the main one the user must input a VNumber. That VNumber relates to
the VNumber in MachineData. The record associated with the VNumber in
MachineData also give detailed information about the machine.

I need to find a way to have a table or query that looks at the current
Results database and pulls all of the records entered. Then it looks
at the VNumber and matches it to the VNumber in MachineData and
automatically adds in the detailed information (serial numbers,
description, etc). I have tried to do this with a query but it does
not want to put it all in one table/query so that I can use it in
frontpage.

Here is my data for the VNumber query:
SELECT MachinesData.MachinesVNumber, MachinesData.VDescription,
MachinesData.VManufacturer, MachinesData.VModel, MachinesData.VSerial,
MachinesData.VLocation
FROM MachinesData
WHERE (((MachinesData.MachinesVNumber)=(Results.VNumber) ));

Try:
SELECT MachinesData.MachinesVNumber, MachinesData.VDescription,
MachinesData.VManufacturer, MachinesData.VModel, MachinesData.VSerial,
MachinesData.VLocation
FROM MachinesData INNER JOIN Results ON
MachinesData.MachinesVNumber=Results.VNumber;

[tina.boroff]

Works! Thanks so much...I guess i need to do a little read up on
InnerJoin....for some reason I have never quite understood it. THANKS
SO MUCH!!!!!!!