UNION ALL Query

Good job!

--

Ken Snell
MS ACCESS MVP

"Brook" wrote in message
...
Ken,

I just set up a new table and created an appendquery to
populate the data from my UNION Query to my tblMaster.

Thanks for all your help!

Brook
-----Original Message-----
Send it to a table? Do you want to append to that table
or make the table?

--

Ken Snell
MS ACCESS MVP

"Brook" wrote in
message
...
Final Question,

Is there a way that I can send this UnionQry to a
tblMaster?

Brook
-----Original Message-----
I see you identified that my "Autonumberfield" was
just a
generic reference
to the field name, and that you needed to replace it
with
the real name.

I'm not sure what you mean by needing to do this for
all
your fields? If you
mean you need to add the rest of the fields to the
query,
then yes.

--

Ken Snell
MS ACCESS MVP

"Brook" wrote in
message
...
I got it!

Thanks for your help!

I guess I have to do this for all my fields now,
right?

Brook


-----Original Message-----
Because I don't know all the fields that are in your
tables, I will show you
how to bring over your formatted display using just
the
one field from each
table. You'll need to add more fields to each SELECT
clause to bring over
the other fields.

SELECT "KI-" & Format
(tblCustomOrders.Autonumberfield, "0000") AS
ActOrderNum
FROM tblCustomOrders

UNION ALL

SELECT "NW-" & Format
(tblStockOrders.Autonumberfield, "0000") AS
ActOrderNum
FROM tblStockOrders;
--

Ken Snell
MS ACCESS MVP

"Brook" wrote
in
message
...
Jeff,

Thanks for the info, yes I did you a format for
the
display of my Autonumber: for tbleStockOrders I
used
the
format "NW-"0000, and for tblCustomOrders I used
the
format "KI-"0000, I am using an update query to
send
the
info from the unionquery to a tblMasterInventory.
Any
suggestions on how I can pull these formats into
my
tblMasterInventory?

Thanks for your help!

Brook

-----Original Message-----
Brook

From your description, it sounds like you've
used a
format to modify the
display of your autonumber fields. This doesn't
modify
the data stored,
just the display of it.

--
Good luck

Jeff Boyce
Access MVP

.



.



.



.

Good job!

--

Ken Snell
MS ACCESS MVP

"Brook" wrote in message
...
Ken,

I just set up a new table and created an appendquery to
populate the data from my UNION Query to my tblMaster.

Thanks for all your help!

Brook
-----Original Message-----
Send it to a table? Do you want to append to that table
or make the table?

--

Ken Snell
MS ACCESS MVP

"Brook" wrote in
message
...
Final Question,

Is there a way that I can send this UnionQry to a
tblMaster?

Brook
-----Original Message-----
I see you identified that my "Autonumberfield" was
just a
generic reference
to the field name, and that you needed to replace it
with
the real name.

I'm not sure what you mean by needing to do this for
all
your fields? If you
mean you need to add the rest of the fields to the
query,
then yes.

--

Ken Snell
MS ACCESS MVP

"Brook" wrote in
message
...
I got it!

Thanks for your help!

I guess I have to do this for all my fields now,
right?

Brook


-----Original Message-----
Because I don't know all the fields that are in your
tables, I will show you
how to bring over your formatted display using just
the
one field from each
table. You'll need to add more fields to each SELECT
clause to bring over
the other fields.

SELECT "KI-" & Format
(tblCustomOrders.Autonumberfield, "0000") AS
ActOrderNum
FROM tblCustomOrders

UNION ALL

SELECT "NW-" & Format
(tblStockOrders.Autonumberfield, "0000") AS
ActOrderNum
FROM tblStockOrders;
--

Ken Snell
MS ACCESS MVP

"Brook" wrote
in
message
...
Jeff,

Thanks for the info, yes I did you a format for
the
display of my Autonumber: for tbleStockOrders I
used
the
format "NW-"0000, and for tblCustomOrders I used
the
format "KI-"0000, I am using an update query to
send
the
info from the unionquery to a tblMasterInventory.
Any
suggestions on how I can pull these formats into
my
tblMasterInventory?

Thanks for your help!

Brook

-----Original Message-----
Brook

From your description, it sounds like you've
used a
format to modify the
display of your autonumber fields. This doesn't
modify
the data stored,
just the display of it.

--
Good luck

Jeff Boyce
Access MVP

.



.



.



.

Good job!

--

Ken Snell
MS ACCESS MVP

"Brook" wrote in message
...
Ken,

I just set up a new table and created an appendquery to
populate the data from my UNION Query to my tblMaster.

Thanks for all your help!

Brook
-----Original Message-----
Send it to a table? Do you want to append to that table
or make the table?

--

Ken Snell
MS ACCESS MVP

"Brook" wrote in
message
...
Final Question,

Is there a way that I can send this UnionQry to a
tblMaster?

Brook
-----Original Message-----
I see you identified that my "Autonumberfield" was
just a
generic reference
to the field name, and that you needed to replace it
with
the real name.

I'm not sure what you mean by needing to do this for
all
your fields? If you
mean you need to add the rest of the fields to the
query,
then yes.

--

Ken Snell
MS ACCESS MVP

"Brook" wrote in
message
...
I got it!

Thanks for your help!

I guess I have to do this for all my fields now,
right?

Brook


-----Original Message-----
Because I don't know all the fields that are in your
tables, I will show you
how to bring over your formatted display using just
the
one field from each
table. You'll need to add more fields to each SELECT
clause to bring over
the other fields.

SELECT "KI-" & Format
(tblCustomOrders.Autonumberfield, "0000") AS
ActOrderNum
FROM tblCustomOrders

UNION ALL

SELECT "NW-" & Format
(tblStockOrders.Autonumberfield, "0000") AS
ActOrderNum
FROM tblStockOrders;
--

Ken Snell
MS ACCESS MVP

"Brook" wrote
in
message
...
Jeff,

Thanks for the info, yes I did you a format for
the
display of my Autonumber: for tbleStockOrders I
used
the
format "NW-"0000, and for tblCustomOrders I used
the
format "KI-"0000, I am using an update query to
send
the
info from the unionquery to a tblMasterInventory.
Any
suggestions on how I can pull these formats into
my
tblMasterInventory?

Thanks for your help!

Brook

-----Original Message-----
Brook

From your description, it sounds like you've
used a
format to modify the
display of your autonumber fields. This doesn't
modify
the data stored,
just the display of it.

--
Good luck

Jeff Boyce
Access MVP

.



.



.



.