I have a report called Test_RPT that is based on a table called test_tbl. The table is created via a query called calculation_qry. The query has criteria of Between [start date] And [end date].
I thought I could originally tie this query as a select but my chart bombs which is why I went with the create table route as I don't know how to create a graph based on a query with criteria. If there is a better way please let me know as I am a novice at this (also attached) db.
The test_rpt runs correctly however I cannot seem to get the date included on the graph. Can someone help me as to how I can include the dates on my graph.