Urvi
10-26-2007, 08:20 AM
Dear Friends,
I have a report to which I am passing two date variables from the calling form and using which i am setting the query criteria of beginning date and end date.
The report is working fine and displays the dates in the report header correctly in the preview. But when I try to print the report, it prints 12/30/1999 for both the beginning ansd ending dates.
I read that 12/30/1999 is the date that access prints if it gets a null or blank date. I don't understand why the parameters should become null when it is being shown in the preview and also setting the query criteria.
Pls help!!!!!!!!!!!!!!!!!!!!!!!!!!
I have a report to which I am passing two date variables from the calling form and using which i am setting the query criteria of beginning date and end date.
The report is working fine and displays the dates in the report header correctly in the preview. But when I try to print the report, it prints 12/30/1999 for both the beginning ansd ending dates.
I read that 12/30/1999 is the date that access prints if it gets a null or blank date. I don't understand why the parameters should become null when it is being shown in the preview and also setting the query criteria.
Pls help!!!!!!!!!!!!!!!!!!!!!!!!!!