467,900 Members | 1,351 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,900 developers. It's quick & easy.

access query issue....is it possible?

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
  • viewed: 1102
Share:
2 Replies
<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
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.

Similar topics

7 posts views Thread by Julia Baresch | last post: by
49 posts views Thread by Yannick Turgeon | last post: by
4 posts views Thread by BerkshireGuy | last post: by
6 posts views Thread by baramee | last post: by
17 posts views Thread by DaveG | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.