Need ur urgent help plzzz

[Bob Quintal]

=?Utf-8?B?dGFtZXJlbHJlZmFpZQ==?=

I've imported about ten tables in Access 2003 from text files,
with no primary keys, but they are same exact design
(structure) in all of them. data maybe repeated with different
values.

let's say xyz is in table 1 his income is $200
and same xyz in table 2 has income $500

and so on with the other data

so I want to build a query on all these tables and group
clients with same name to show their data and compare them???
Although there isn't any relationship between them (how can I
make relation in this case?)

How can I do all this ???

Don't make relations.

Create an UNION QUERY as follows

SELECT 1 AS SoucrceTable, * from table1
UNION ALL
SELECT 2 AS SoucrceTable, * from table2
UNION ALL
SELECT 3 AS SoucrceTable, * from table2
....
Until you have all the tables.
You can then open the query and sort by any field you want.

 

[tamerelrefaie]

I've imported about ten tables in Access 2003 from text files, with no
primary keys, but they are same exact design (structure) in all of them.
data maybe repeated with different values.

let's say xyz is in table 1 his income is $200
and same xyz in table 2 has income $500

and so on with the other data

so I want to build a query on all these tables and group clients with same
name to show their data and compare them???
Although there isn't any relationship between them (how can I make relation
in this case?)

How can I do all this ???

 

['69 Camaro]

Chris, what's wrong with this picture when you see it on your computer?

http://www.time.gov/timezone.cgi?Mountain/d/-7/java

HTH.
Gunny


news[email protected]...

 

[tamerelrefaie]

Thanks alot Bob,
really I can't thanks u enough. there is still another small part
which is
how can I get the max. income from all these incomes and the related data to
it???

and again many thanks

 

['69 Camaro]

Hi, Chris.

It shows the correct time. Right now it is showing, 19:33.

I am not sure how to determine what might be wrong with it in the context
of your
question.

Why do you ask?

All of your posts are an hour ahead:

http://groups.google.com/group/micr...84a0d?lnk=st&q=&rnum=1&hl=en#7f6ba28f41584a0d

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

['69 Camaro]

Hi, Chris.

Oddly enough, my timezone on my computer timezone was set for Pacific,
even though I'm
Mountain time.

Ah. That explains it.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.