Hi again,
Ok, so I have about 15 crosstab queries. Each crosstab query is an employee's name. Within the query are the weeks as the column heading, the work order numbers as the row heading, and the hours as a value. Each query comes from a different employee table (1 table per employee). Is there any way I can combine all the queries into 1 query/report?
So far it seems to me that the only way I'll have a chance at making every employee name, week, work order number, and hours fit into one query would be to have a giant table of that information and work from there. Could someone please let me know if there is an easier way to show that information?
Thanks,
Tiffany
7 2715
Hi again,
Ok, so I have about 15 crosstab queries. Each crosstab query is an employee's name. Within the query are the weeks as the column heading, the work order numbers as the row heading, and the hours as a value. Each query comes from a different employee table (1 table per employee). Is there any way I can combine all the queries into 1 query/report?
So far it seems to me that the only way I'll have a chance at making every employee name, week, work order number, and hours fit into one query would be to have a giant table of that information and work from there. Could someone please let me know if there is an easier way to show that information?
Thanks,
Tiffany
I assumed all the information was already in one giant table. Is this not the case? How are the tables set up then?
Each time an employee fills out the form, their information goes to their own table. So each employee has their own table. I'm finding more and more that one combined table is the more effective option so I will probably end up doing that....making my previous dilema a useless question. So I guess I don't really need any more help yet. Thanks for reading though :)
Tiffany
Each time an employee fills out the form, their information goes to their own table. So each employee has their own table. I'm finding more and more that one combined table is the more effective option so I will probably end up doing that....making my previous dilema a useless question. So I guess I don't really need any more help yet. Thanks for reading though :)
Tiffany
Good luck. You can make a large query using a union query. Don't forget to include a field to specify to whom the record belongs.
Each time an employee fills out the form, their information goes to their own table. So each employee has their own table. I'm finding more and more that one combined table is the more effective option so I will probably end up doing that....making my previous dilema a useless question. So I guess I don't really need any more help yet. Thanks for reading though :)
Tiffany
You might benefit more from reading this tutorial first: Database Normalisation Tutorial
I.e. instead of one giant table, you would have an employees table, then a work orders table, etc... They link better through queries that way...
Regards,
Scott
instead of one giant table, you would have an employees table, then a work orders table, etc... They link better through queries that way...
Thanks for the advice. I have a few of the tables you suggested. Unfortunately I don't know enough about relationships to do anything with them....a task for another day I suppose.
Thanks,
Tiffany
Thanks for the advice. I have a few of the tables you suggested. Unfortunately I don't know enough about relationships to do anything with them....a task for another day I suppose.
Thanks,
Tiffany
For that other day :-)
Relationships aren't really all that difficult to understand! Once you grasp the essential fact of Relational Databases that you should only store one unique piece of information in one place, it follows logically that you need to 'relate' or connect each piece of information that you have stored.
Relationships then are the connections between pieces of data. They exist in three forms: Many to Many, One to Many and One to One. The most common type of relationship is One to Many. It means that One piece of information (i.e. SalesmanID) can be related/connected to Many orders. From this example you can easily understand that Many to Many and One to One relationships refer to tables/subjects that store data in their own particular format.
All data stored in a database have these types of relationships inherently. All you are doing by designing your database correctly is reflecting the relations/connections that already exist!
As I think I mentioned in a post to the Database Normalization tutorial , the best/easiest to understand book that I know of is Database Design for Mere Mortals, 2nd edition by Mike Hernandez. I'm not trying to be his advertising manager, but I would strongly urge you to read the book! It's well worthwhile for anyone who works with databases.
Regards,
Scott
Great thanks, I'll try that.
Tiffany
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Darleen |
last post by:
I am seeking conceptual here on how to get started with a "3D Matrix"
in Access. We run a training center which holds multiple classes in
multiple cities at multiple times. So I need to create a...
|
by: Nathan Bloomfield |
last post by:
Does anyone know if there is any documentation which relates to Access2k + ?
or can anyone help adjust the code?
I am having trouble converting the DAO references.
TITLE :INF: How to...
|
by: Judy |
last post by:
I'm using Access 2003 and was wondering if it is possible to have a
paramater selection within a crosstab query so that I wouldn't need to build
a new table.
I have a select query that I'm using...
|
by: carl.barrett |
last post by:
Hi,
I'm back with the same question as I still can't get it to display
my data the way I want it to.
The table lists information about a perpetrator involved with an anti
social behaviour...
|
by: BeruthialsCat |
last post by:
I have 4 crosstabs which are keyed on a managerID field. I want to
combine them to provide the data for a graph. I currently have them
combined in a union query to produce 4 rows of data for each...
|
by: tizmagik |
last post by:
I am having a lot of difficulty generating a CrossTab Query based
report. I have looked online for several tutorials and whatnot but I
have not been able to really find what I'm looking for, nor...
|
by: salad |
last post by:
Operating in A97.
I didn't receive much of a response conserning Pivot tables in Access.
Pivot tables are nice, but a CrossTab will work for me too.
Using a Pivot table, one is actually...
|
by: greg |
last post by:
I have a table that I want to left join with crosstab query and I want
to be able to edit data in the table (only). However, once I perform
the join, the entire query result cannot be edited. Is...
|
by: m.wanstall |
last post by:
I have a crosstab query that compiles data for Months of the year. I
have a stacked select query on top of that crosstab query that uses
the latest 2 months data and exports it to a fixed length...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
| |