I have two issues:
1) I have two charts that need to display information for same start date and end date. I can get it so that the criteria of the query prompts the user, but then it has to occur twice (once for each chart). I can just have the report query prompt once for a start date and end date; but then the charts use the data from all dates, and the report creates the same report for all the days from start date to end date...
How do I prompt the user for a start date and end date only once, but get that date to feed into both charts?
2) I need to also use the end date to populate some field values. Essentially, I have some general information that needs to correspond to the end date inputted.
How do I connect field values only to the end date from when the user is prompted?