Going Crazy .....Help Required with Access 2003 DB
I am new to DB Access 2003 and i am having trouble generating a report from various tables, actually i have to generate a report based on three different tables and these tables have Date, Time, Unit, Operator in common but the other fields like Weight, Temperature, Laempe No', Machine No' and Mix No' n Readings come from other tables and while we have one value for all the other fields Readings has three values. I know it's kindda confusing ........but here is the problem........ I have tried to make a query n add the diff. tables from where i want the data to go in the DB but when it comes to building relationships i get so lost , i dont know which relationships should i build so that my report gets the necessary data.I tried building relations and my DB didn't have any values and it gave some error aswell.
I need some expert help on this issue now. Any help will be highly appreciated .
Thanks in advance.
6  2320 
So if I understand correctly all three tables have the fields Date, Time, Unit, and Operator in common.
If that is true you can link all the table together via the operator field.
What error are you getting? And, what is the report criteria?
MMcCarthy 14,534
Recognized Expert Moderator MVP
Have a look at this tutorial and come back with any questions. Normalisation and Table structures
Instinctively I think you are duplicating fields that shouldn't be duplicated.
Mary
I am still confused, i want to make one report from multiple tables but since the tables have different fields but Date, Time, Operator and unit are common fields in all the tables, can someone plz. suggest me how to write a query based on multiple tables to form a report.
I have never ever written relationships before and i am so lost here, i am not able to define correct relationships, because it doesnt populate any data from the tables.
 MMcCarthy 14,534
Recognized Expert Moderator MVP
I am still confused, i want to make one report from multiple tables but since the tables have different fields but Date, Time, Operator and unit are common fields in all the tables, can someone plz. suggest me how to write a query based on multiple tables to form a report.
I have never ever written relationships before and i am so lost here, i am not able to define correct relationships, because it doesnt populate any data from the tables.
The problem is if you join the three tables based on operator for instance this will only show the records that have the operator field in all three tables.
Also do any of the tables have more than one record per operator? If the tables are not joined correctly then you won't retrieve all the records but with your current structure I'm not sure it's possible. I need more information about what field is unique to each of these tables. By that I mean that there are no duplicates in the value of the field.
Mary
The problem is if you join the three tables based on operator for instance this will only show the records that have the operator field in all three tables.
Also do any of the tables have more than one record per operator? If the tables are not joined correctly then you won't retrieve all the records but with your current structure I'm not sure it's possible. I need more information about what field is unique to each of these tables. By that I mean that there are no duplicates in the value of the field.
Mary
I got it done, thanks for your help :)
MMcCarthy 14,534
Recognized Expert Moderator MVP
I got it done, thanks for your help :)
You're welcome.
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: Mahesh Hardikar |
last post by:
Hi ,
Oracle 8.1.7.0.0 on HP-UX 11.0
I am a newbie as far as PL-SQL is concerned . I have Sybase/MSSQL
T-SQL background.
We have a report which uses a select statement . This select statement
joins 15 tables . SOme of the tables are outer joined.
It runs much slow when parameters (From & To Date) are for a month.
|
by: Peter |
last post by:
Can anyone tell me how to change the data type of a field in a table created
with a make table query? The field is a binary and must be changed to text.
alternately does anyone know how to specify the field type when running a
make table query?
Thanks,
Sven
|
by: Ed |
last post by:
I am running Access 2002 and just ran the built in Access wizard for
splitting a database into a back end (with tables) and front end (with
queries, forms, modules, etc.).
After running the wizard, I opened the table relationship view and noticed
that all the relationships are missing. Is this supposed to happen? If so,
why? I've noticed that queries are behaving strangely now, seemingly
because the relationships are not established....
|
by: Neil Ginsberg |
last post by:
I have ODBC linked tables to a SQL 7 database in an A2K database. The linked
tables do not have the password stored in them, so the first time the user
accesses them, they need to enter the SQL password.
I am developing a process that will automatically run at night which will
access those tables. I need to be able to give Access the password, as the
user currently does, so that the process can run without a password prompt
appearing....
|
by: ChadDiesel |
last post by:
Hello everyone. I need some advice on table structure for a new project
I've been given.
One of our customers sends us an Excel spreadsheet each week containing
their order. Currently, someone formats the spreadsheet, prints it out, and
manually picks out the products we need to ship. I want to import this into
an Access table. Basically, the sheet with some data examples looks
something like this:
...
| | |
by: Stephen Layton |
last post by:
Our Access 2003 database (which had been converted a year or so ago from
an Access 97 database) contained one major table which suddenly
developed about five records which had clearly become corrupted. The
five records contained "Chinese" looking font. The corrupted records
were deleted and the database repaired and compacted several times.
However, today we found that a form, which had worked perfectly well for
several years was unable...
|
by: Kevin Chambers |
last post by:
Hi all--
In an attempt to commit an Access MDB to a versioning system (subversion),
I'm trying to figure out how to convert a jet table's metadata to text, a
la SaveAsText. The end goal is to be able to build an MDB completely from
the svn repository text files.
Has anybody dealt with this?
Thanks in advance,
|
by: Bob |
last post by:
I have Access 2003. When I look at the relationships of my tables, it
looks correct, with the various 1 to many relationships, and 1 to 1,
indicated with a line between keys. When I try to "Print Relationships"
the connection lines only appear for tables within the first 3 columns.
No lines appear to tables in the 4th and higher columns.
When switch the page layout to landscape, to get all the relationships
shown nicely on one page,...
|
by: TonyJH226 |
last post by:
MY database in Access 2003 is made up of about 30 related tables with relationships defined. I hit the "Show All Relationships" button on the tool bar and one of these tables somehow decided to move outside of the accessible area. The relationship lines are still attached to the appropriate tables but I can no longer see the table no matter what I do with the scroll bars.. The table seems to be in the upper left part of the screen. When I...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
