Results 1 to 2 of 2
  1. #1
    funsofinnih is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jan 2012
    Posts
    1

    Change of report layout

    I need help to change a report format as per the tow tables below ie from Table A to Table B for about 25k records. What kind of queries can I use?



    TABLE ATABLE BWeekChannel codeChannel_NameAddressE1085TE1105TE1055E1225C3010Channel codeChannel_NameAddressModel48495048ENU45TOPCLASSG 91 RAILWAYLINE ENUGU22121ENU45TOPCLASSG 91 RAILWAYLINE ENUGUE1085T21348ENU11UPSON COMMUNICATION1 CHIME AVENUE21125ENU45TOPCLASSG 91 RAILWAYLINE ENUGUE1105T22548ENU44VILLA COMM61 OGUI ROAD ENUGU11007ENU45TOPCLASSG 91 RAILWAYLINE ENUGUE105515848ENU55WIRELESS OPTION31 ZIKS AVENUE12000ENU45TOPCLASSG 91 RAILWAYLINE ENUGUE122523548ENU16WISDOM COMMUNICATION12 NEW HAVEN MARKET20512ENU45TOPCLASSG 91 RAILWAYLINE ENUGUC301014749ENU45TOPCLASSG 91 RAILWAYLINE ENUGU12534ENU11UPSON COMMUNICATION1 CHIME AVENUEE1085T26249ENU11UPSON COMMUNICATION1 CHIME AVENUE65892ENU11UPSON COMMUNICATION1 CHIME AVENUEE1105T15249ENU44VILLA COMM61 OGUI ROAD ENUGU54565ENU11UPSON COMMUNICATION1 CHIME AVENUEE105518549ENU55WIRELESS OPTION31 ZIKS AVENUE18823ENU11UPSON COMMUNICATION1 CHIME AVENUEE122529449ENU16WISDOM COMMUNICATION12 NEW HAVEN MARKET25723ENU11UPSON COMMUNICATION1 CHIME AVENUEC301052550ENU45TOPCLASSG 91 RAILWAYLINE ENUGU35857ENU44VILLA COMM61 OGUI ROAD ENUGUE1085T15850ENU11UPSON COMMUNICATION1 CHIME AVENUE22545ENU44VILLA COMM61 OGUI ROAD ENUGUE1105T14550ENU44VILLA COMM61 OGUI ROAD ENUGU85233ENU44VILLA COMM61 OGUI ROAD ENUGUE105505250ENU55WIRELESS OPTION31 ZIKS AVENUE52030ENU44VILLA COMM61 OGUI ROAD ENUGUE122506350ENU16WISDOM COMMUNICATION12 NEW HAVEN MARKET95513ENU44VILLA COMM61 OGUI ROAD ENUGUC3010753ENU55WIRELESS OPTION31 ZIKS AVENUEE1085T115ENU55WIRELESS OPTION31 ZIKS AVENUEE1105T282ENU55WIRELESS OPTION31 ZIKS AVENUEE1055080ENU55WIRELESS OPTION31 ZIKS AVENUEE1225023ENU55WIRELESS OPTION31 ZIKS AVENUEC3010030ENU16WISDOM COMMUNICATION12 NEW HAVEN MARKETE1085T229ENU16WISDOM COMMUNICATION12 NEW HAVEN MARKETE1105T055ENU16WISDOM COMMUNICATION12 NEW HAVEN MARKETE1055575ENU16WISDOM COMMUNICATION12 NEW HAVEN MARKETE1225121ENU16WISDOM COMMUNICATION12 NEW HAVEN MARKETC3010233

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,824
    What do you mean by 'change a report format as per the tow tables below ie from Table A to Table B'? If you tried to post sample records, result is not very usable.

    I downloaded your file and tried opening it but Excel does not recognize the file.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Change date after printing report
    By dutyfree in forum Reports
    Replies: 4
    Last Post: 10-24-2011, 12:55 PM
  2. Can't change report name
    By kman42 in forum Reports
    Replies: 1
    Last Post: 10-19-2011, 02:40 PM
  3. Replies: 1
    Last Post: 04-25-2011, 12:20 PM
  4. report layout
    By ippy in forum Reports
    Replies: 0
    Last Post: 12-09-2010, 01:23 PM
  5. Change way report prints
    By johnpaul in forum Reports
    Replies: 1
    Last Post: 10-01-2010, 11:17 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums