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) )); 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;
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!!!!!!! This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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=()=>{
|
by: lllomh |
last post by:
How does React native implement an English player?
|
by: Mushico |
last post by:
How to calculate date of retirement from date of birth
|
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...
| |