Date Range

[Guest]

Hi,

When I want the date rage appeared on the report header, I use textbox and put
(qry criteria) in its recordsource. It works fine.

However, For this time, I got a message like this ‘First([Between [From this
date] And [To this date]])"

Is there something wrong with the qry criteria?

Would you please show me how to fix the problem?

Thanks

Chi

 

[Guest]

It's very hard to understand the crtieria, can you post the full SQL

What is the First in the beginning?
Why there are to square brackes in the end And in the beinning?

First([Between [From this date] And [To this date]])"

Try
Between [From this date] And [To this date]

Also to write the criteria in the text box, use the control source with

="Between " & [From this date] & " And " & [To this date]

 

[Guest]

The 'First' seems like it is from a totals query and the [Between [From this
date] And [To this date]] was placed in the field row of query design view.

 

[Guest]

Thank you Ofer and Karl,

It works!!!!!!!!!!!!!!!. Excellent!


-----------------------------------------------

It's very hard to understand the crtieria, can you post the full SQL

What is the First in the beginning?
Why there are to square brackes in the end And in the beinning?

First([Between [From this date] And [To this date]])"

Try
Between [From this date] And [To this date]

Also to write the criteria in the text box, use the control source with

="Between " & [From this date] & " And " & [To this date]
--
Good Luck
BS"D

Hi,

When I want the date rage appeared on the report header, I use textbox and put
(qry criteria) in its recordsource. It works fine.

However, For this time, I got a message like this ‘First([Between [From this
date] And [To this date]])"

Is there something wrong with the qry criteria?

Would you please show me how to fix the problem?

Thanks

Chi