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

MS Access Help with Moving Multiple Tables into One

P: 1
Hi,

My name is Megan and I am 21 and just learning to use Access. I was hoping that someone would be able to help me.

My problem is that I have created a database with multiple tables (over 10) and I need these tables to feed into 1 table.I need to fill and maintain a table in Database1 with data periodically (every minute) gleaned from various tables in Database2.

I have too many tables to create a query large enough to open, and I have limited restrictions to downloading software at the company that I am at. And I am not familiar with sub forms.

If you can provide me with some help, I would greatly appreciate it.

Thank you,
Megan
Mar 22 '07 #1
Share this Question
Share on Google+
2 Replies


DeMan
100+
P: 1,806
Hi Maegan,
Welcome to theScripts. You'll notice a range of different forums on the Right Hand Side of the Screen. I hope you don't mind that I move your question to the Access Forum (where I'm sure the experts are better equipped to help you out)
Mar 22 '07 #2

Denburt
Expert 100+
P: 1,356
Hello Megan there are a list of Articles that you may find interesting here:
MS Access Articles

There is an article in there that discusses SQL Statements and 1 on subforms and how to reference them. Let me know if that helps answer some of your questions. :)
Mar 22 '07 #3

Post your reply

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