472,807 Members | 5,232 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,807 software developers and data experts.

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
2 1228
<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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Daniel | last post by:
I use an Access database to basically take data exports, import them, manipulate the data, and then turn them into exportable reports. I do this using numerous macros, and queries to get the data...
7
by: Julia Baresch | last post by:
Hi everyone, My company recently upgraded from Office 97 to Office XP. As those who've read my other posts know I have a database with 3 nested subforms Main form-->First Subform-->Second...
3
by: pbbriggs | last post by:
I will try to be as descriptive as possible, but this error has me stumped and I am not sure what relevant info to include.... I am running Access XP on a Windows XP machine. I initially began...
2
by: Mattyboy | last post by:
Guys I have built a database with saved queries that runs fine in Access but when I call it from the web using ASP, an exception occurs. I have tried multiple ways of testing the databases with...
49
by: Yannick Turgeon | last post by:
Hello, We are in the process of examining our current main application. We have to do some major changes and, in the process, are questionning/validating the use of MS Access as front-end. The...
4
by: BerkshireGuy | last post by:
Our IT department wants to place our Access 2000 tables on an SQL server due to the fact the tables are quite large. With that said, can we still use the Access queries or do we have to do...
6
by: baramee | last post by:
I develop web application by asp.net with ms access. In general , it work fine. But if hit rate of web is very much, it occure error 'Unspecified error'. it error on conn.open. My code will be...
17
by: DaveG | last post by:
Hi all I am planning on writing a stock and accounts program for the family business, I understand this is likely to take close to 2 years to accomplish. The stock is likely to run into over a...
4
by: ShastriX | last post by:
Getting a weird error while trying out a query from Access 2003 on a SQL Server 2005 table. Want to compute the amount of leave taken by an emp during the year. Since an emp might be off for...
1
by: smaczylo | last post by:
Hello, I've recently been asked to work with Microsoft Access, and while I feel quite comfortable with Excel, I'm at a complete loss with databases. If someone could help me with this issue I'm...
0
by: erikbower65 | last post by:
Using CodiumAI's pr-agent is simple and powerful. Follow these steps: 1. Install CodiumAI CLI: Ensure Node.js is installed, then run 'npm install -g codiumai' in the terminal. 2. Connect to...
0
linyimin
by: linyimin | last post by:
Spring Startup Analyzer generates an interactive Spring application startup report that lets you understand what contributes to the application startup time and helps to optimize it. Support for...
0
by: erikbower65 | last post by:
Here's a concise step-by-step guide for manually installing IntelliJ IDEA: 1. Download: Visit the official JetBrains website and download the IntelliJ IDEA Community or Ultimate edition based on...
0
by: kcodez | last post by:
As a H5 game development enthusiast, I recently wrote a very interesting little game - Toy Claw ((http://claw.kjeek.com/))。Here I will summarize and share the development experience here, and hope it...
0
by: Rina0 | last post by:
I am looking for a Python code to find the longest common subsequence of two strings. I found this blog post that describes the length of longest common subsequence problem and provides a solution in...
0
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
0
by: lllomh | last post by:
How does React native implement an English player?
0
by: Mushico | last post by:
How to calculate date of retirement from date of birth
2
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.