Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2008
    Posts
    150

    Unanswered: Help Using the Same Field in a Query

    Hello,

    I am working with Microsoft Access 2010.

    I have a field called AC125 and I would like to output multiple dates based on the same field (AC125). So,

    I have a query with the field “AC125” and I would like to use the same field in my query 4 times to get the output below.

    How can I get these results?

    AC125 AC125 AC125 AC125
    4/20/13 4/27/13 5/4/13 5/11/13
    4/20/13 4/27/13 5/4/13 5/11/13
    4/20/13 4/27/13 5/4/13 5/11/13
    4/20/13 4/27/13 5/4/13 5/11/13
    4/20/13 4/27/13 5/4/13 5/11/13

    Thank you.

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    haven't got a clue
    some idea of your table design would help
    some idea of how you get from that table design to your required output format would help

    is this an Access problem or an Access problem from within an Excel application?
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Sep 2008
    Posts
    150
    Hi Healdem,
    n
    I have a table called Forecast with a field called AC125. The field type is a date field.
    I have created a basic query with the Forecast table, and I was trying to use the "AC125 field multiple times to get different dates. I need to see all dates in 4/20/13, 4/27/13, etc., but I need to get all of the dates outputed in differnt cells.

    I hope this clears it up. I appreciate you responding. :-)

  4. #4
    Join Date
    Sep 2006
    Location
    Surrey, UK
    Posts
    994
    Provided Answers: 2
    If you are having problems with Access, why have you posted a question in the Excel forum?

    It is possible to have a column appear more than once in the output of a query, but for the second appearance (and all subsequent appearances), you will need to provide a new, unique alias.
    10% of magic is knowing something that no-one else does. The rest is misdirection.

Posting Permissions

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