CrossTab Query Date Range (1 Viewer)

S

syedadnan

Access Lover

Local time

Today, 11:38

Joined

Mar 27, 2013

Messages

315

• Feb 23, 2017

• #1

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

 

Attachments

• 
  Untitled.png

  24.4 KB · Views: 413

Minty

AWF VIP

Local time

Today, 08:38

Joined

Jul 26, 2013

Messages

10,371

• Feb 23, 2017

• #2

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.

 

S

syedadnan

Access Lover

Local time

Today, 11:38

Joined

Mar 27, 2013

Messages

315

• Feb 23, 2017

• #3

Minty said:

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.

Click to expand...

Right but tried no result

 

C

CJ_London

Super Moderator

Staff member

Local time

Today, 08:38

Joined

Feb 19, 2013

Messages

16,607

• Feb 23, 2017

• #4

@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

AWF VIP

Local time

Today, 08:38

Joined

Jul 26, 2013

Messages

10,371

• Feb 23, 2017

• #5

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

 

Attachments

• 
  XTabParams.JPG

  62.5 KB · Views: 2,597

S

syedadnan

Access Lover

Local time

Today, 11:38

Joined

Mar 27, 2013

Messages

315

• Feb 23, 2017

• #6

CJ_London said:

@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?

Click to expand...

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