Adding new fields to an existing report

  • Thread starter Thread starter Shashank Date
  • Start date Start date
S

Shashank Date

On Access 2002: Two problems:

1. I tried adding a column to an existing report which was created using the
Wizard, by dropping a text box at the required place and changing the
Control Source property using the Expression Builder. I picked the field
from the table so the property looked like this

= [MM_CUST_ADDRESS]![ADDRESS]

But when I run the report it prompts for a ADDRESS Parameter. What am I
missing ?

2. On that same report, I wanted to add a field in the Group Footer section,
which is a computation based on two existing fields CURRENT_DATE and
AS_OF_DATE. So I set the Control Source property of the newly added text box
to

= SUM(DateDiff("d",[CURRENT_DATE],[AS_OF_DATE]))

But it prompts for the parameters AS_OF_DATE and CURRENT_DATE.
Surprisingly it does not do that if I change the property to look like this:

= DateDiff("d",[CURRENT_DATE],[AS_OF_DATE])

I have taken out the SUM() function. Here CURRENT_DATE is a field in the
Group footer and AS_OF_DATE is a field in the Group Header.

Any suggestions will be highly appreciated.
Thanks,
-- Shashank
 
1. Go to the properties for the report. (by right clicking
on the box on the top left corner). Then go to the Record
Source and click the ... to the right and make sure that
ADDRESS is one of the selected fields.

2. Try doing the DateDiff in the Detail (you can make the
field property visible no so that it does not show) Then
in the footer SUM the new DateDiff Field.
 
estewart said:
1. Go to the properties for the report. (by right clicking
on the box on the top left corner). Then go to the Record
Source and click the ... to the right and make sure that
ADDRESS is one of the selected fields.
Click to expand...

That worked !
2. Try doing the DateDiff in the Detail (you can make the
field property visible no so that it does not show) Then
in the footer SUM the new DateDiff Field.
Click to expand...

That did not :-(

Thanks for the tips ...

-- Shashank
 
Back
Top