How to set a calendar to be the entry of paramenter field to make graph in report

[djungna]

Hi friend
Anyone can help me

If I need to make the graph in report.
(the report are made from the query and i set one field as the parameter value.)

Now the parameter that I key in , normally is the date.

Many time that I key in the correct date but it show nothing in the graph.

So i thinking that for the parameter field, if I can make the calendar then just select the date in calendar and use that for the value in parameter field.
Then the graph is show according to the select dat in calendar.

How can I do that?

 

[ColinEssex]

Firstly, why is the query not returning any records when you type in the correct date?

Secondly, you can use a calendar to select the date. Search for ActiveX calendar, there are samples available.

Col

 

[djungna]

Dear colin, please help

Dear colin

Sometime if i type the the date too quick, even it is correct date, it will show blank in the graph.

I have try to paste the calendar (from active X) but I have no idea how to use it (it show on blank space in on th report).
Can you please show me??

 

[ColinEssex]

Sometime if i type the the date too quick, even it is correct date, it will show blank in the graph.

What I was getting at was this - Is the query running the graph showing any records when you run it cold?

I think maybe its better you post your Db and we'll have a look - in the meantime here is an ActiveX example you may like to peruse

Col

 

[djungna]

Thank you ColinEssex

Thank you so much Colin
I have already check in your file and it work.
Thank you for your great help.