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 |
#11
|
|||
|
|||
Typo correction
David,
no, only works in SQL view. Brian "David" wrote in message ... Brian, That did the trick. THANK YOU. Any way to do UNION queries in the Query window vs. SQL window? -- David "Brian Bastl" wrote: SELECT a.id As MyID, a.firstfield As Selection From table As a Union All SELECT b.id, b.secondfield from table As b Union All etc.... "Brian Bastl" wrote in message ... Sounds like what you want is a union query. SELECT a.id MyID, a.firstfield As Selection From table As a Union All SELECT b.id, b.secondfield from table As b Union All etc.... Brian "Brian Bastl" wrote in message ... Sorry, think I misread your post, unfortunately too late. Brian "David" wrote in message ... Hello, Bad design, I know, but a customer wants to take what is currently field1, field2, field3, etc. and use this data in a drop down box. The table is a single record, with 10 of these fields. Any suggestions on how to make each field a record in a query, and use it as the data source for a combo box. (or other suggestions for using this data in a combo box). The data can be changed by the user, which is why I need to dynamically access it. Thanks! -- David |
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Make Table Query - Sorting Errors | Fred | Running & Setting Up Queries | 19 | February 22nd, 2006 09:41 PM |
Query is not updatable - | Doug Johnson via AccessMonster.com | Running & Setting Up Queries | 3 | January 21st, 2006 12:36 AM |
Help again from Ken Snell (Query) | Randy | Running & Setting Up Queries | 22 | August 29th, 2005 08:15 PM |
Need Help In Printing Current Record in Specific Report | RNUSZ@OKDPS | Setting Up & Running Reports | 1 | May 16th, 2005 09:06 PM |
Access combo box-show name, not ID, in table? | write on | New Users | 30 | April 30th, 2005 09:11 PM |