Report footers

[uttam1]

Hi all,

I need to have certain details in my report, like count of records where this value = this, when I create a text field in the report and fill in the code for it's control source, it displays the value for all records in the database! But if the same textbox is placed in the reports footer, it appears just once. What should I do to get the value just once in the main design area of the report?

Thanks in advance,
Uttam

 

[dhookom]

There is no "main design area" of reports. There are sections. What do you want to see and in which section?

Duane
MS Access MVP

 

[GhostWolf]

It sounds like the report details you're after is something like "a list of FirstNames and how many people have each one" - but you don't have the correct query to return this information.

You'll need a query like "select FirstName, count(*) as NameCount From PersonnelFile Order by FirstName".

Use that query as the report's datasource, and place the fields FirstName and NameCount in the details section of your report.


Good luck.

 

[uttam1]

Thanks for the replies, GhostWolf, will try what you said.

I'm basically looking for count values in the design section, but not count values for all records in the database, only a concerned one. I get that only in the page footer. How do I get that in the design section?

Thanks
Uttam

 

[dhookom]

There is no "design section" section of a report. You can count the number of records matching a specific condition with a text box in a group or report footer section:
=Abs(Sum([Fruit] = "Apple&quot)
or
=Abs(Sum([Gender] = "F&quot)



Duane
MS Access MVP