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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Dcount (multiple criteria) 3
query count help 3
Query Criteria 7
How to finding student Rank and How to upload bulk marks of each student at a time. 1
returning current month and year 2
How do I update a chart based on criteria input? 2
Query - ies - Questions 6
How do I chart in Access 3

Back
Top