Results 1 to 4 of 4

Thread: Query question

  1. #1
    Join Date
    Mar 2004
    Posts
    2

    Unanswered: Query question

    I have two linked tables

    How can I get access to allow me to select quantities of these items and provide a list of these selected items in a new table?



    Thanks in advance!

    Ken

  2. #2
    Join Date
    Oct 2003
    Posts
    16

    Re: Query question

    Your question is a little too vague.

    Are you having trouble creating the query to select/summarize the data or putting the output of that query into a new table?

    Either way, a brief description of the tables involved and the desired result should lead to a quick answer.

    Regards

  3. #3
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    SELECT Value1, Value2 Value3     
      INTO
    TempTable
       FROM yourTable

  4. #4
    Join Date
    Aug 2003
    Location
    Delft, The Netherlands (EU)
    Posts
    447

    Re: Query question

    ... or consider to create a TableMake action query.
    Make everything as simple as possible, but not simpler! - A. Einstein
    DB Problems? DB Explorer, BTrieve Re-engineering, DB Conversions & ETL? Conversion Tool

Posting Permissions

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