UNION ALL Query
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
.
|