ACCESS Charts & criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I get access to chart a query that has a critera that filters down a
table by entering a selection? I can hard code it in the criteria field and
it works (I.E. chart values for "part 1" only), but if the critera is
subjective (enter part #, or enter dates range), it doesn't recognize the
field. If access can't do it, does the export to excel work with a subjective
field?
 
1) you should get all criteria from controls on forms
2) Chart row source queries are often crosstab queries.
Crosstab queries require you to enter the data types
of all parameters. Select Query->Parameters and
enter the Forms!frmDates!txtStart Date/Time
 
Back
Top