By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,963 Members | 1,784 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,963 IT Pros & Developers. It's quick & easy.

access query issue....is it possible?

P: n/a
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) ));

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
<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;
Nov 13 '05 #2

P: n/a
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!!!!!!!

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.