How can I make a graph show the last 30 days. I have a continuous form that allows the user to fill in a date field and a weight field. The graph in the forms footer shows the all of the information, but obvisley looks clutered as it shows everyday regardless if you put in a record on that day, so it shows from the first record up to Date() if that makes sense.
To keep it looking tidy, I would like it to recall the last 30 days by refault with an option to search between two dates.
How should I go about this?
I should add that the graph is fed by a query (qryWeightForChart) which has three fields in it WeightDate, Weight and Dog_ID. Im guessing but I think the crireria for the weight date will have to be something like:
Date(-30) and Date()
Thanks
To keep it looking tidy, I would like it to recall the last 30 days by refault with an option to search between two dates.
How should I go about this?
I should add that the graph is fed by a query (qryWeightForChart) which has three fields in it WeightDate, Weight and Dog_ID. Im guessing but I think the crireria for the weight date will have to be something like:
Date(-30) and Date()
Thanks
Last edited:
