I've made a union query and I want to add now a column to this query
Beside I want it to get the table name beside each record because these
records belongs to different tables as I said in the begining it's a union
query.

example
table1
table2
table3

union query xyz containing all data in these three tables.

I want to add a column to this query and in this column, i want it to
contain infront of each record the name of the table from which it come from.

please really need your help.

Add the following to each select statement in the union query ---
, "YourTableName" AS [TableName]
--
KARL DEWEY
Build a little - Test a little


"tamerelrefaie" wrote:

> I've made a union query and I want to add now a column to this query
> Beside I want it to get the table name beside each record because these
> records belongs to different tables as I said in the begining it's a union
> query.
>
> example
> table1
> table2
> table3
>
> union query xyz containing all data in these three tables.
>
> I want to add a column to this query and in this column, i want it to
> contain infront of each record the name of the table from which it come from.
>
> please really need your help.

SELECT Field1, FIeld2, "Table1" As DataSource
FROM Table1
UNION
SELECT Field1, FIeld2, "Table2"
FROM Table2
UNION
SELECT Field1, FIeld2, "Table3"
FROM Table3

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"tamerelrefaie" <(E-Mail Removed)> wrote in message
news:02E985AB-CCAC-4F2D-9538-(E-Mail Removed)...
> I've made a union query and I want to add now a column to this query
> Beside I want it to get the table name beside each record because these
> records belongs to different tables as I said in the begining it's a union
> query.
>
> example
> table1
> table2
> table3
>
> union query xyz containing all data in these three tables.
>
> I want to add a column to this query and in this column, i want it to
> contain infront of each record the name of the table from which it come
> from.
>
> please really need your help.

Really thanks alot Karl

"KARL DEWEY" wrote:

> Add the following to each select statement in the union query ---
> , "YourTableName" AS [TableName]
> --
> KARL DEWEY
> Build a little - Test a little
>
>
> "tamerelrefaie" wrote:
>
> > I've made a union query and I want to add now a column to this query
> > Beside I want it to get the table name beside each record because these
> > records belongs to different tables as I said in the begining it's a union
> > query.
> >
> > example
> > table1
> > table2
> > table3
> >
> > union query xyz containing all data in these three tables.
> >
> > I want to add a column to this query and in this column, i want it to
> > contain infront of each record the name of the table from which it come from.
> >
> > please really need your help.

Really thanks alot Douglas

"Douglas J. Steele" wrote:

> SELECT Field1, FIeld2, "Table1" As DataSource
> FROM Table1
> UNION
> SELECT Field1, FIeld2, "Table2"
> FROM Table2
> UNION
> SELECT Field1, FIeld2, "Table3"
> FROM Table3
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
> "tamerelrefaie" <(E-Mail Removed)> wrote in message
> news:02E985AB-CCAC-4F2D-9538-(E-Mail Removed)...
> > I've made a union query and I want to add now a column to this query
> > Beside I want it to get the table name beside each record because these
> > records belongs to different tables as I said in the begining it's a union
> > query.
> >
> > example
> > table1
> > table2
> > table3
> >
> > union query xyz containing all data in these three tables.
> >
> > I want to add a column to this query and in this column, i want it to
> > contain infront of each record the name of the table from which it come
> > from.
> >
> > please really need your help.
>
>
>