Prev: Insert Items from Yes/No CheckBox into Query
Next: Record with longest entry
From: khussey on 5 Feb 2010 13:12

--
kh
From: Jeff Boyce on 5 Feb 2010 14:32
Why?

Having two copies of the same data exposes your database to integrity
issues.

More info, please...

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"khussey" <khussey(a)discussions.microsoft.com> wrote in message
news:AD14BFC9-A98B-4FFD-A31F-E722F1F0D666(a)microsoft.com...
>
> --
> kh


From: Bob Barrows on 5 Feb 2010 14:59
An Append or Update query - see online help

--
HTH,
Bob Barrows


From: John W. Vinson on 5 Feb 2010 16:59
On Fri, 5 Feb 2010 10:12:01 -0800, khussey <khussey(a)discussions.microsoft.com>
wrote:

< nothing >

It's considered polite to use the big textbox to ask a comprehensible
question, not just use the subject line.

As noted elsethread, this is probably a Bad Idea - relational databases use
the Grandmother's Pantry Principle, "a place - ONE place! - for everything,
everything in its place". Storing the same data in multiple tables risks
anomalies if one or the other table gets edited; you then have "the same" data
actually being different.

That said, an appropriate Query (append or update) could do this. If you would
like help with a query post some more information about your tables and what
you're trying to do.
--

John W. Vinson [MVP]
 | 
Pages: 1
Prev: Insert Items from Yes/No CheckBox into Query
Next: Record with longest entry