how to show calculated field in reports!!!

  • Thread starter Thread starter manish
  • Start date Start date
M

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
 
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")
 
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
Click to expand...


.
Click to expand...
 
Back
Top