link a graph to a drop-down list

[titiakila]

Thank you @June7.


I have this error :
the selected query does not contain enough data to create a chart or the fields cannot be extracted. select a table or query containing at least one numeric date or text field
Does it work for you ?

[titiakila]

Sorry that didn't worked for me @June7
I have the following error :
the selected query does not contain enough data to create a chart or the fields cannot be extracted. select a table or query containing at least one numeric date or text field

[June7]

It worked for me with your sample db.

[titiakila]

It didn't worked for me I'm sorry to bother you but did you simply choose the requy you wrote as the source of the graph ?
because I can't choose it I have the error :
the selected query does not contain enough data to create a chart or the fields cannot be extracted. select a table or query containing at least one numeric date or text field as I said

[June7]

The SQL statement is directly in graph RowSource property. I didn't change anything else in the db.

[titiakila]

Oh ok thank you very much it works ! I didn't know what rowsource meant. Thank you !!!!!