Re: UNION ALL Query

From: Ken Snell (kthsneisllis9_at_ncoomcastt.renaetl)
Date: 07/31/04 

Date: Sat, 31 Jul 2004 13:22:16 -0400

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" <anonymous@discussions.microsoft.com> wrote in message
news:7ace01c4770a$b987ce80$a601280a@phx.gbl...
> 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>
> >
> >.
> >

Relevant Pages

  • Re: Tapble top fusion generator
    ... >increased my monitor format to 1280x1024 and display it on a Mitsubishi ... >using a screen format less than 1280x1024 and the low -resolution LCD ... >Since the poster writing about the character overlap, ... is, when you make one web site viewable, you can render others ...
    (sci.physics.fusion)
  • Re: How to customize the output format of function dataset?
    ... It's line 85 of @dataset/disp that is where you want to go, ... However, since this is in a class directory, you'll have to modify it in place, which requires appropriate privileges for your MATLAB install directory. ... I will make a note to look into enhancing the display method for the dataset in the future. ... Just out of curiosity, would it be sufficient for your needs if the display respected the current setting of the FORMAT command? ...
    (comp.soft-sys.matlab)
  • 2 Ques regarding dates (matching and subtracting)
    ... The end-user enters a date in cell a2, validated to format DD/MM/YYYY. ... In K30, I want to display the number of days until the end of the month, ... "Jacob" wrote: ... > I want to use a subtraction or matching formula. ...
    (microsoft.public.excel.misc)
  • Re: Dividing hours
    ... you can display these in a format that mimics time by making use of the ... The divisional manager will enter in the annual planned hrs on the ... worksheets Each workbook also has a calculation worksheet. ...
    (microsoft.public.excel.misc)
  • Re: Create Dynamic Controls and Displaying Page by Page on the for
    ... My computer is client and other is server. ... I want to display all recevied values for parameters ... > I'm saying this because dynamically creating a few thousand controls might ... >> row data format will be same. ...
    (microsoft.public.vsnet.general)
Loading