Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Feb 2004
    Location
    Jacksonville, Florida
    Posts
    70
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Querry Calculations (9.0/2001)

    I'm trying to create a formula in a querry that has a column called "Planned_Start." I want that column to look at another column and change all the dates from mm/dd/yy to a mm-yyyy format. Does anyone know how to go about doing that? <img src=/S/bwaaah.gif border=0 alt=bwaaah width=123 height=15>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Querry Calculations (9.0/2001)

    You don't really need calculations to do that. You can add the date column to the query design grid a second time and give it Planned_Start as alias:

    Planned_Start: DateFieldName

    where DateFieldName is the name of the ... - you get the idea. Set the Format property of this field to mm-yyyy. If, however, you want to group on this field, or something like that, youwill need to calculate the dates:

    Planned_Start: DateSerial(Year([DateFieldName]),Month([DateFieldName]),1)

    and again, set the Format property to mm-yyyy.

  3. #3
    Star Lounger
    Join Date
    Feb 2004
    Location
    Jacksonville, Florida
    Posts
    70
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Querry Calculations (9.0/2001)

    I think I'm slower than the average car! I tried duplicating the fieldname, and looked for an alias field, but there wasn't one....what do I do at this point. Did I even do it right? I went to the table design view, and copied the name "Meth_Planned_Starts" then I went to the "general tab" expecting that's where the alias option was at, however it wasn't.....

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Querry Calculations (9.0/2001)

    You create an alias in a query by typing AliasName: FieldName in an empty column of the query design grid. See screenshot below.
    Attached Images Attached Images
    • File Type: png x.png (3.8 KB, 0 views)

  5. #5
    Star Lounger
    Join Date
    Feb 2004
    Location
    Jacksonville, Florida
    Posts
    70
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Querry Calculations (9.0/2001)

    Thank you soooo much, that eliminated the headache of the whole linking to excel problem <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23>

Posting Permissions

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