Newbies senat0r Posted March 22, 2005 Newbies Posted March 22, 2005 Hi All, I am having difficulty in creating a summary total of data in a related table. 1st Table (Comparison DB) contains the field "Site", "Machine Type", "Gross Revenue" 2nd Table (2002) contains the same fields but has hundreds of records because at any one site there can be multiple of the same machine type. The relationship uses "Site" & "Machine Type" The 1st table will only contain one unique record for each site and then machine type but needs to summarise the gross revenue from table 2 by machine type. This summary field needs to be placed in a report on table 1 (Comparison DB) but extract the data from table 2. Is this possible ? Hope somebody understands. It is quite difficult to explain. Thanx
aaa Posted March 22, 2005 Posted March 22, 2005 If I have truly understood you, try so. Creat getsummary field in second table by "Site&" & "Machin Type" Sort your recors for getting the value of this field Create relation from second table to first. Then by script put data from second table to first using relation. This is one of ways. There are other ways to do it using export or import.
Recommended Posts
This topic is 7255 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now