Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Location
    Wales
    Posts
    343

    Unanswered: Crosstab Report Column problems

    Hi guys,

    Hope I can explin this one simply?

    I have a crosstab used to report the number of products sold by period (month) - this works well in the query mode. However I have made a report that accounts for each period (1 to 12 ) across the report. Products are listed in rows - simple so far until I come to a new year. Beacuse the Period(month) is set to a table holding Year - Period Number and from to date for the period. The report is showing an error as for instance we are in period 1 and it cannot find periods 2 3 4 5 6 etc (this is because they havnt occured yet) is there a way of telling the record source within the text box in the report that { if PEROID does not exist then 0 else PERIOD DATA} for instance ?

    I just seem to to be missing the plot here

    Hope Ive made claer what the heck i'm doing here

    Thanks guys

    Gareth

  2. #2
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,424
    Provided Answers: 8
    In the Cross Tabs query In Design View right click the Columu heading feild then click the proprites you can add the columu heading there 1,2,3,4,5,6,7,8,9,10,11,12

    or is it ; can't remeber
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  3. #3
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Another thought is left outer joining from a tale that contains all the periods, using this as the column headings. Then future periods just have 0 totals but are ready set up to display data as the dates pass.

    Make sense? No? Fancy posting your SQL so far?
    Testimonial:
    pootle flump
    ur codings are working excelent.

Posting Permissions

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