how to show calculated field in reports!!!

[manish]

h1!
I have two calculated fields in a query that uses it to
filter records. they are
[start date]
[last date]
now my problem is that i want the values of these fields
to show in my report in the header. for example it should
be like :

Transaction for the period [start date] to [last date]

any suggestions ???
help!
manish

 

[SteveJ]

Create a text box and in the Properties->Data->Control Source enter the
following:

="Transaction for the period " + Format([start date], "dd/mm/yyyy") + " to "
+ Format([last date], "dd/mm/yyyy")

 

[manish]

Dear SteveJ
I tried ur suggestion and it worked !!! thanx a lot for it.
regards
manish

-----Original Message-----
Create a text box and in the Properties->Data->Control Source enter the
following:

="Transaction for the period " + Format([start date], "dd/mm/yyyy") + " to "
+ Format([last date], "dd/mm/yyyy")

h1!
I have two calculated fields in a query that uses it to
filter records. they are
[start date]
[last date]
now my problem is that i want the values of these fields
to show in my report in the header. for example it should
be like :

Transaction for the period [start date] to [last date]

any suggestions ???
help!
manish

.