Results 1 to 3 of 3

Thread: As in SQL

  1. #1
    Join Date
    Mar 2004

    Unanswered: As in SQL

    I built a calculation query in the SQL editor.
    Some fields has a long name in the As [], For example A.D As [Birth day of the pupil]

    This makes the query very wide width.
    How can I edit the [] for two lines

    For example: instead of [Birth day of the pupil] I want [Birth day]
    of the


  2. #2
    Join Date
    Dec 2003
    Dallas, TX
    Hi wasimf,

    Not totally sure I follow you here. You are running a Query and for the A.D. field you are using the Alias [Birth day of the pupil]. This may make for a long line in the Query, but aren't you then spitting the Results out on either a Form or Report? If so, then you can make it short there or just create some shorter name Alias to begin with?


  3. #3
    Join Date
    Mar 2003
    The Bottom of The Barrel
    Provided Answers: 1
    Smack-on Bud.

    You would be better served using short, descriptive names in the datasource, reserving the drawn out long description for your report or form. Even if you're using just the query for export, I still like to make reports for this type of thing so I can keep it clean and simple.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

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