Results 1 to 6 of 6
  1. #1
    Star Lounger
    Join Date
    Apr 2003
    Posts
    56
    Thanks
    0
    Thanked 0 Times in 0 Posts

    table's fields outlook (a97)

    hi there
    I hv a question abt the making table with fields remain unchange.
    Everymonth i will receive a data table(table1). Frm table1, i want the mod field data will show on column side (pls see table2)
    My question is whatif the fields for e.g 'L4' were not in the data in the table1 but the table 2 which i already set hv the L4? I don want to replace or create a new table. I wan to use the table2 becoz all the data fields are set. so how to make the L4 available in the table2 n value shows 0 although in the table1 do not hv L4?Pls help the desperate here ....
    Thank you..
    nuglorious
    Attached Files Attached Files

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

    Re: table's fields outlook (a97)

    It would be nice if you wrote complete words instead of hv and abt and pls. This is not a chat site.

    You can fix the columns in the crosstab query by setting the Column Headings property of the query. See attached version.
    Attached Files Attached Files

  3. #3
    Star Lounger
    Join Date
    Apr 2003
    Posts
    56
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: table's fields outlook (a97)

    hello there
    firstly sorry abt the abbreviation.
    i unable to open the access file. The error message said 'Unrecognize database format. Currently im using a97. Please resend.
    Thank you
    nuglorious

  4. #4
    Star Lounger
    Join Date
    Apr 2003
    Posts
    56
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: table's fields outlook (a97)

    for your info, my office are using MS97 but at home im using MS2K. So the file i send to you earlier was sent frm my home.
    thank you for your understanding
    nuglorious

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

    Re: table's fields outlook (a97)

    >> firstly sorry abt the abbreviation. <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15>

    Here is the database in Access 97 format.
    Attached Files Attached Files

  6. #6
    Star Lounger
    Join Date
    Apr 2003
    Posts
    56
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: table's fields outlook (a97)

    Thank you for sharing to me. Im appreciated.
    oh no..pls..im too shy...almost my both ball eyes droped <img src=/S/yikes.gif border=0 alt=yikes width=15 height=15> <img src=/S/rofl.gif border=0 alt=rofl width=15 height=15>

    <img src=/S/wink.gif border=0 alt=wink width=15 height=15>

Posting Permissions

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