Search results

  1. M

    Passing parameter to report

    Excellent! Thanks a lot!
  2. M

    Passing parameter to report

    End_Cycle_Sprint from the "view_Story_Complete" query, which is used on the report.
  3. M

    Passing parameter to report

    The End_Cycle_Sprint attribute contains those (Cycle_Sprint) entries. Each cycle has a number of sprints associated, each sprint is between two dates, and I'm grouping on those sprints so that I can see what kind of work has been accomplished per sprint. I was able to add a End_Cycle_Sprint...
  4. M

    Passing parameter to report

    I look forward to the solution :)
  5. M

    Passing parameter to report

    No problem. It could be this: https://productforums.google.com/forum/#!topic/youtube/_SdyaTAWkJ0 I've started watching them on youtube, but it seems to be covering a use case more complicated than mine. The videos also make extensive use of code templates which I assume have been collected and...
  6. M

    Passing parameter to report

    Thanks, although you seem to have disabled playback on other sites, so they don't play from that link you've given. :)
  7. M

    Passing parameter to report

    Hi, I can't get a form to open a report and pass in parameters to restrict the selection. I have two controls on frmCycleSprintChart (cmb_From and cmb_To), and button which executes the following to launch the report (rpt_CycleSprintChart): DoCmd.OpenReport "rpt_CycleSprintChart"...
  8. M

    Chart in Report based off Query not working

    Great! Thanks very much :). I have another query, should I make a new post or continue here?
  9. M

    Chart in Report based off Query not working

    Sure, sorry I'm not clear. I've attached a mockup. The report is grouped as follows: End_Cycle_No (e.g. Cycle 17) -graph of each sprint in one graph Sprint_Cycle_End (e.g. CD17-1, CD17-2, CD17-3) -details of the stories
  10. M

    Chart in Report based off Query not working

    Thanks! Is there a way to embed this into the report which has the list of stories, grouped by End_Cycle_No?
  11. M

    Chart in Report based off Query not working

    It's almost there, I want to display the complete cycle which has multiple sprints so that they can be compared with each other. Ideally I'd want to be able to configure a view so that multiple cycles and sprints can be compared with each other, as in the attachment.
  12. M

    hi there

    Thanks, I've posted attachments now.
  13. M

    Chart in Report based off Query not working

    Attached database.
  14. M

    Chart in Report based off Query not working

    Added a zip, as I am allowed to upload a zip.
  15. M

    Chart in Report based off Query not working

    Hi all, Sorry for the long post! I'm learning MS Access as I'm attempting to get an excel spreadsheet converted into something more fit for purpose. I'm wanting to store information on development stories, so that I can refer to past development, and eventually plot velocity. The tables I have...
  16. M

    hi there

    Hi all, I'm primarily a java and oracle sql developer, but trying to learn access for some internal development. I also need to have 10 posts before I can post links!
Top Bottom