CrossTab Query Date Range

[syedadnan]

Regards

I have a crosstab query and which is doing fine for me, what i need more is to get a date range criteria based on form as below;

Between [Forms]![frmReports]![fdate] And [Forms]![frmReports]![TDate]

I have a Tdate field in query which i want that rest all calculation (sum) to be made on the basis of date range given by the formula for date range to the field TDate in query, i have attached a pic as well

 

[Minty]

In a cross tab query you have to explicitly define the parameters. Right click the design view window and select "Parameters".

Enter the parameter name(s) and data type(s).
Bob will be your uncle.

 

[syedadnan]

In a cross tab query you have to explicitly define the parameters. Right click the design view window and select "Parameters".

Enter the parameter name(s) and data type(s).
Bob will be your uncle.

Right but tried no result

 

[CJ_London]

@syedadnan. After 300 posts you should know by now that comments such as 'no result' are totally unhelpful for others trying to help you.

What does it mean? nothing returned? wrong data returned? you get an error?

What dates have you entered in your frmReports?

What is your actual sql?

 

[Minty]

You have to keep the format / names exactly the same as in

 

[syedadnan]

@syedadnan. After 300 posts you should know by now that comments such as 'no result' are totally unhelpful for others trying to help you.

What does it mean? nothing returned? wrong data returned? you get an error?

What dates have you entered in your frmReports?

What is your actual sql?

Correct and Apology for that really,,

Yep i got the desired result as what you given instructions, actually i was not confident about the parameters but now its okay..

Thanks a billion for you and Minty and well