If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#21
|
|||
|
|||
UNION ALL Query
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 . . |
#22
|
|||
|
|||
UNION ALL Query
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 . . |
#23
|
|||
|
|||
UNION ALL Query
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 . . |
#24
|
|||
|
|||
UNION ALL Query
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 . . |
#25
|
|||
|
|||
UNION ALL Query
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 . . |
#26
|
|||
|
|||
UNION ALL Query
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 . . |
#27
|
|||
|
|||
UNION ALL Query
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 . . |
#28
|
|||
|
|||
UNION ALL Query
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 . . |
#29
|
|||
|
|||
UNION ALL Query
Thanks,
That is what I needed to know.. You have been a great help. Have a great day. 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 . . . |
#30
|
|||
|
|||
UNION ALL Query
Thanks,
That is what I needed to know.. You have been a great help. Have a great day. 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 . . . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
"UNION" Query with different fields in the two tables | Dkline | Running & Setting Up Queries | 5 | July 30th, 2004 09:05 PM |
UNION query question | Dale Peart | Running & Setting Up Queries | 6 | July 14th, 2004 12:26 AM |
Union Query Issue | Larry | Running & Setting Up Queries | 4 | July 12th, 2004 08:53 AM |
UNION Query truncating Memo fields | Matthew DeAngelis | Running & Setting Up Queries | 4 | June 10th, 2004 02:17 PM |
Edit table using union query | De'Ville | Running & Setting Up Queries | 1 | June 1st, 2004 11:46 AM |