Thanks for the info,

When I tried this, and ran the query again, a pop up box
asking for tblCustomOrders.Autonumberfield and
tblStockOrders.Autonumberfield??

Not sure what to do?

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

.



.