Thanks in advance for any help given even it is as simple as that can't be done start over!
What I have is two tables (in 2 different databases). They both contain the same types of data about the same type machinery, but entries were originated for totally different causes.
Yes, they could be entered into 1 or the other tables. The project started out to do "one" simple thing and now has expanded into doing several things. The instructions were "keep it simple; take baby steps and by the way make it do this and display it like that and let it do this at the same time" LOL
What I need to do is pull the info from both tables into 1 report. What I have done for now is I have created a Make Table Query and an Append query. When I run a report, I clear all data out of the table and then run the Make table to get Info out of table 1 and then run the Append query to get data out of Table 2.
Is there a better way short of combing entry into one or the other table?
Thanks,
Lee
What I have is two tables (in 2 different databases). They both contain the same types of data about the same type machinery, but entries were originated for totally different causes.
Yes, they could be entered into 1 or the other tables. The project started out to do "one" simple thing and now has expanded into doing several things. The instructions were "keep it simple; take baby steps and by the way make it do this and display it like that and let it do this at the same time" LOL
What I need to do is pull the info from both tables into 1 report. What I have done for now is I have created a Make Table Query and an Append query. When I run a report, I clear all data out of the table and then run the Make table to get Info out of table 1 and then run the Append query to get data out of Table 2.
Is there a better way short of combing entry into one or the other table?
Thanks,
Lee
