Solved Display Filtered Range in Report

[silentwolf]

Hi,

I got a query and a form to filter and display a report.

The Query has one date field wich I filter with
Between [Forms]![frmPrintTimeSheet]![txtDateFrom] And [Forms]![frmPrintTimeSheet]![txtDateTo]

What I like to do is to display that date range in the Report.
I placed a textfield in the report header but just been able to get the first date in the textbox not both.

Maybe someone could tell me.

Many thanks.

Albert

 

[theDBguy]

Try concatenating them.

=Forms!frmPrintTimeSheet.txtDateFrom & "-" & Forms!frmPrintTimeSheet.txtDateTo

 

[silentwolf]

Hi DB Guy,

That did the tricke many thanks to you!!

Cheers

Albert

 

[theDBguy]

Glad to hear you got it to work. Good luck with your project.