2 TABLE INTO 1

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

_Bigred - 18 May 2005 05:51 GMT

Using access 2000

I have a Main table
I have a Player Stats table
I have a Player Info table

I believe each of these (3) tables have the same fields in them, and would
like to put the player stat table data into the main table. Then I would
like to put the player stats table data into the main table.

So when I'm finished I have a up to date Main table, that contains ALL the
info collectively from the other two tables. I have tried various queries.
But every time I run them they do add the data but the add each player again
in to the db. So if I start with a empty main table, then run queries and
put the stats & info into it (main table) I end up with two records for each
player (1 record has their info - the other record has their stats).

How do I get this fixed?

TIA,
_Bigred

Reply to this Message

Duane Hookom - 18 May 2005 07:02 GMT

Leave the information in three tables and combine them with a query when
needed.

Why would you state "I believe each of these (3) tables have the same fields
in them"? Can't you look at them and tell for sure? The structures should
all be mostly unique.

Signature

Duane Hookom
MS Access MVP

> Using access 2000
>
[quoted text clipped - 18 lines]
> TIA,
> _Bigred

Reply to this Message

_Bigred - 19 May 2005 05:17 GMT

what kind of query do I use to combine them (when needed)? I have been
trying to work on a update query and a append query but keep running into
problems (this is when trying to merge 2 tables into 1 main table).

Ultimately the data which I want to have in 1 table, changes everyday since
it is statistics. And I would like to have it dumped into 1 main table when
I run the appropriate query(s) so that I can base my statistical queries off
1 table, and base all my forms and reports off the same.

Maybe my db layout is poor, I would ultimately have a table for batting
stats, a table for pitching stats, a table for field stats, and table for
general info about each player (ie. college, draft year etc....)

Any suggestions would be appreciated,
_Bigred

> Leave the information in three tables and combine them with a query when
> needed.
[quoted text clipped - 25 lines]
>> TIA,
>> _Bigred

Reply to this Message

Duane Hookom - 20 May 2005 05:03 GMT

Look up Select Query in Help.
Do you have any tables yet?
I would not create tables with duplicate information.

Signature

Duane Hookom
MS Access MVP

> what kind of query do I use to combine them (when needed)? I have been
> trying to work on a update query and a append query but keep running into
[quoted text clipped - 42 lines]
>>> TIA,
>>> _Bigred

Reply to this Message