valhil2003
Last Activity: May 16 '14, 07:24 PM
Joined: Mar 18 '14
Location:
-
And 5)I used the relationship wizard on the database tools ribbon (I selected who's related to who) -
1)Access 2013/Office 365
2)I am the sole user (for now) creator and administrator of the file.
3)Sorry about that. The whole idea is to have a query or a central table reporting the required fields from all the other tables. This would be a view only (no edit capability) table for the end users to see.
4)(Due to confidentiality agreements I have changed the names, yet I've left the relationships) * = Primary...Leave a comment:
-
Well, the table is used for tracking inventory. This query picks up all the needed data for reports, views etc and is supposed to be a single place repository for all the needed data to then be used, edited and changed by the users. The issue that I have with the SQL is that I need an action that can report the data input in every single one of the selected fields from the populated master tables.
As of this moment, the relationships...Leave a comment:
-
The SQL is as follows:
...Code:SELECT [Employee List].[Employee Name] , [Employee List].[Pay rate] , [Labor - Entry Scans].Station AS [Labor - Entry Scans_Station] , [Labor - Entry Scans].[Entry Scan] AS [Labor - Entry Scans_Entry Scan] , [Labor - Exit Scans].Station AS [Labor - Exit Scans_Station] , [Labor - Exit Scans].[Exit Scan] AS [Labor - Exit Scans_Exit Scan] , [Tracking -
Last edited by zmbd; Mar 19 '14, 10:01 PM. Reason: [z{placed code tags, I'll be back to format later}{Removed second question - one quesiton per thread}{Formatted SQL}]Leave a comment:
-
Reporting data between 6 'master' tables and 1 'child' table
I want to have seven tables (relationship between them already exists) that report the data as follows;
Table 1-6 - Masters: data is input here
Table 7 - Child: data from Master is relayed here
I have tried with a Query to no avail, and even though the master tables have test records populating them I cannot seem to get the necessary fields shown in the Child table... Help!
No activity results to display
Leave a comment: