Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Posts
    1

    Question New and in need of some help

    Youíll forgive my ignorance in matters pertaining to databases but Iím in need some help and was advised to ask here. I am currently in my final year of studying A level computing in the UK and have ran into a problem in my course work, a fellow student recommended that I ask here.

    I donít know if there is an obvious answer to my question but this idea stumped my tutor and fellow class mates, I also donít know how much information any helper will need to know so Iíll tell you as much as I can.

    I am building a database for a cinema and have stored details on how much it coasts to hire the a film, how much it coasts to buy a ticket to a showing of a film and now many people have booked tickets to these showing. From this information I can deduce the amount taken per film showing, the amount taken per film and the profit that the film made. What I want to do is produce a chart in a report that shows for each film name (across the X-axis) the amount that the film made in revenue and in a separate column the amount that it coast to hire. This meaning for every name on the X-axis there will be two bars.

    I am using Microsoft Access 98 and have tried using the chart wizard to no success so far. Maybe Iím missing key option but I would be very grateful if someone could show me how to create this chart I need. Thank you very much for reading my message and if you have any ideas then please e-mail me at my address.

    Alastair J.R. Ball

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: New and in need of some help

    I don't know if I have understood right ...

    In Excel Charting, there in the Chart type of 'Column' you will have a sub-type which reads 'Clustered column. Compares values across categories) ... I think that is what you need

    I assume this chartype should be available in M$ Access also

    Cheers
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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