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

query make table problem?

P: n/a
I have a make table query that I make a table from. I want the rows to
continue increasing but it overwrites the data each time. I am gathering
data from a linked source and to collect statistical data for analysis in a
table over a period of time. Any help would be appreciated.

thanks.
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Append query is what you want

HTH
David B

Derek Davlut <de****@trico.on.ca> wrote in message
news:bu**********@news.storm.ca...
I have a make table query that I make a table from. I want the rows to
continue increasing but it overwrites the data each time. I am gathering
data from a linked source and to collect statistical data for analysis in a
table over a period of time. Any help would be appreciated.

thanks.


Nov 12 '05 #2

P: n/a
Once the table is made, use an Append or Update query to make the changes or
additions you need. Running a make table again will just replace the one
that's there.

Mike Storr
www.veraccess.com

"Derek Davlut" <de****@trico.on.ca> wrote in message
news:bu**********@news.storm.ca...
I have a make table query that I make a table from. I want the rows to
continue increasing but it overwrites the data each time. I am gathering
data from a linked source and to collect statistical data for analysis in a table over a period of time. Any help would be appreciated.

thanks.

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.