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,482
    Provided Answers: 11
    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

    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-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.
    DONT WORRY ABOUT THOSE WHO TALK BEHIND YOUR BACK
    THEY'RE BEHIND YOU FOR A REASON

  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
  •