I have a form containing a chart (as a subform). I want the chart to display data from the 20 most recent records (by the records' autonumber or date fields). I am guessing that this can be done by setting the criteria of the charts' query. Any ideas on what kind of statement to use in the criteria? Thanks.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
chart query criteria syntax
- Thread starter shelspa
- Start date
- Status
Similar threads
- Question