Results 1 to 10 of 11

Thread: Sorting Data In An MS-Access Table Using SQL

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 09-21-2013, 02:29 AM #7
    alansidman
    alansidman is offline
    Senior Member alansidman's Avatar
    Join Date
    Apr 2012
    Posts
    125
    Rep Power
    14
    I have adapted your db as shown in Table1 and built three queries, 2,3 and 4. Query 4 appears to be what you are looking for. It is Union All query that joins Query 2 with Query 3.
    Attached Files Attached Files
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Export data from Excel to Access Table (ADO) using VBA
    By Admin in forum Excel and VBA Tips and Tricks
    Replies: 4
    Last Post: 02-24-2015, 07:53 PM
  2. Make Table SQL Query In Access That Adds A Primary Key
    By Portucale in forum Access Help
    Replies: 5
    Last Post: 08-08-2013, 10:02 PM
  3. Fetch Data From Access Database Using SQL Only If All The Where Criteria Is Selected
    By bethrah in forum Excel Help
    Replies: 8
    Last Post: 08-08-2013, 03:52 AM
  4. Combine table with dates and values in a new way (special re-sorting)
    By Stephan Ellmann in forum Excel Help
    Replies: 2
    Last Post: 02-23-2013, 09:18 PM
  5. Upload Excel Data to SQL Table
    By littleiitin in forum Excel and VBA Tips and Tricks
    Replies: 3
    Last Post: 08-22-2012, 11:02 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules