|
| 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 |
|
#1
December 19th, 2005, 02:43 PM
posted to microsoft.public.access.queries
|
|||
|
|||
Adding tables
Hello,
I'm using a query to add a table to another table, but i have problems with the sorting For example: Table A has 20 records; record A - record T Table B has 2 records; record 1 and record 2 When I add table A to B; I want the table to be like : record 1 record 2 record A record B record C record D record E record F ..... record P record Q record R record S record T BUT: Sometimes the table is something like: record Q record R record S record T record 1 record 2 record A record B record C ..... record L record M record N record O record P I can not sort the table, but the order of the added table should remain. Any ideas?? Gertjan 
|
|
#2
December 19th, 2005, 04:20 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Adding tables
Tables are not sorted.
They can be indexed but you need to sort in your queries or via grouping and sorting in a report. "Gertjan" wrote: Hello, I'm using a query to add a table to another table, but i have problems with the sorting For example: Table A has 20 records; record A - record T Table B has 2 records; record 1 and record 2 When I add table A to B; I want the table to be like : record 1 record 2 record A record B record C record D record E record F ..... record P record Q record R record S record T BUT: Sometimes the table is something like: record Q record R record S record T record 1 record 2 record A record B record C ..... record L record M record N record O record P I can not sort the table, but the order of the added table should remain. Any ideas?? Gertjan
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Tables not adding up ? but queries are | Matthew | New Users | 1 | November 19th, 2005 08:31 PM |
| need to join local tables with sql 7 tables using guids | Susan via AccessMonster.com | Running & Setting Up Queries | 0 | January 31st, 2005 08:58 PM |
| Mutliple Tables lookup? | Westley | Database Design | 4 | June 15th, 2004 01:07 AM |
| Adding three tables to one | TYE | Running & Setting Up Queries | 1 | June 6th, 2004 07:45 PM |
| Adding color to pivot tables | Becky | Worksheet Functions | 0 | April 7th, 2004 01:56 PM |
Linear Mode
