Results 1 to 4 of 4
  1. #1
    sazzysally is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2016
    Posts
    2

    Stack records

    Hi all

    I wanted to know if it possible to create a new table query or multiple queries to stack data in a row from an existing table. Basically I have the bellow records in table 1

    Car | Crash test 1 | Crash test 2


    Ford PASS Fail
    BMW PASS PASS
    VW FAIL FAIL
    MERCEDES PASS Blank
    Ferrari FAIL Blank

    create table 2 so the data looks like this

    Car | Crash test |
    Ford PASS
    Ford Fail
    BMW PASS
    BMW PASS
    VW FAIL
    VW FAIL
    MERCEDES PASS
    Ferrari FAIL

    thanks so much all xXx

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,549
    yes, in a macro you will add several queries
    Q1 will append CAR, TEST1
    Q2, append CAR , TEST2
    etc...

  3. #3
    sazzysally is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2016
    Posts
    2
    sorry little confused how I would do that? do I need to create a blank destination table?

  4. #4
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,549
    Yes, or make the 1st query a make table.
    the rest append qrys.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Implementing LiFo Stack, an implementation
    By GraeagleBill in forum Code Repository
    Replies: 2
    Last Post: 06-08-2014, 03:24 PM
  2. General Module - Implementing LiFo Stack
    By GraeagleBill in forum Programming
    Replies: 2
    Last Post: 05-13-2014, 01:15 PM
  3. Replies: 1
    Last Post: 01-24-2013, 05:50 PM
  4. Error 28 Out of Stack Space
    By loulou in forum Programming
    Replies: 1
    Last Post: 03-30-2012, 10:59 AM
  5. Error 28: Out of Stack Space??
    By mugsmugs in forum Access
    Replies: 1
    Last Post: 02-22-2009, 09:54 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums