Hi there,
I've been using ASPRunner for a few months now and it's a fantastic product, however my Web / Database knoweldge is very limited. I have to implement something for a client however I have no idea how to achieve the following on the MENU.ASP page:
I need to display a graph with each bar being the value from a query (called qrySettle). What the graph should display is 2 bars - the first is the total number of records with "Instruction date" in October and the second bar should be the number with "Settle Date" in October. So for example, if in qrySettle there were 10 instructions in October, bar 1 would be 10, if 7 of those settled, bar 2 would be 7.
Clicking the graph would then link to the asp query where they can view the records as normal.
Can anyone tell me if this can be easily achieved or do I need to run the query first then display the results as a graph?
Any help on this subject would be much appreciated - as I say i'm no expert on this subject.
Many thanks,
Bryan
