By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,456 Members | 1,472 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,456 IT Pros & Developers. It's quick & easy.

A report based on one particular field from multiple tables

LeighW
P: 73
Hi there,

Everytime a user edits data within the bound forms in the database the approval checkbox (which is a bound field) changes to "False".

Is there a way of creating one sole report based on the records from each table where the approval field is "False"?

This means that I don't require a relationship between the tables it is purely for an approver to come along generate a report and check what has been modified.

Each form is bound to a table.

Form1 = Table1, Form2 = Table2, Form3 = Table3.

The approval field resides in each Table.

Is what I ask possible?

Thanks for any help,

Leigh
Sep 11 '12 #1
Share this Question
Share on Google+
3 Replies


zmbd
Expert Mod 5K+
P: 5,285
If the tables are related this is fairly straight forward.
However, if not, then two possible ways that I can think of to do this.
You could create a seperate report for each table and then insert these into a parent report. You would then get a single report that groups the records by table.
If you just need to have the data all on combined and pretty then the next option is to try a union query... these can be a hoot and you'll have to have a good understanding of SQL and grouping theory to create the query.
-z
Sep 11 '12 #2

LeighW
P: 73
The tables are related in this kind of format.

Table 1 -> Table 2 -> Table 3

The problem is someone could modify a record from Table 1 and then a couple completely unrelated records in Table 3 so I guess the report would look a bit messy with a record from Table 1 then Table 3 then Table 2, etc.

I think to make it as easy as possible for the approver it would be better if it shows all of the unapproved records from Table 1 THEN from Table 2 THEN from Table 3

From that perspective I'm guessing joining a number of reports into a parent report would be best? I wanted to avoid creating numerous reports for one job but it looks like I'll have to do it that a way.
Sep 12 '12 #3

zmbd
Expert Mod 5K+
P: 5,285
From what you've typed, there appears to be no relationships established between the tables. Thus, IMHO, the solution will be the unbound parent report hosting the three subreports.

Please keep in mind however, that this solution is based upon absolutly no information about the structure of the tables or the relationships between them, if any exsist, that might suggest a different way to handle the data.

-z
Sep 12 '12 #4

Post your reply

Sign in to post your reply or Sign up for a free account.