At the Report Footer I have a kind of statistics of membership query using
Total as follows:
TotalAll: Sum(IIf([JenisKel] Is Not Null,1,0))
TTLMale: Sum(IIf([JenisKel]="L",1,0))

I have a report that needs to print a detail line from an unbound control in
the detail line. I read a databae to populate this unbound control. However,
the problems that I'm having is that the vba code works correct meaning that
it retrieves the information but the report (unbound ...

We accidentally checked Hidden when doing an Access report and can't find
where to get it back. In 2003 it was Tools => Options => Hidden Objects.
Anyone know where this went to in Office 2007?
thanks..

I have 2003 access. In my report design view I want to repeat a line of data
in this line there are 3 title boxes & 3 data source boxes. I do not have the
option of RepeatSection property to Yes. Can anyone out there Help me?

I'm trying to get a report setup to show me data in the in the following
manner:
Month     data 1     data 2     data 3     data 4
Jan            2             5             4           9

   I've written a report scheduling tool based on a Form Timer_Event.  I
have built a 'report schedule' table which contains many fields I require to
run the reports based on the timer.  Anyway, I create a recordset, based on
the reports in the schedule table, and run the reports ...

Hi I currently have 2 seperate reports that I want to use in one.
I have...
1. A Date report that works from a form with a to and from field, it then
finds all reports between those two fields.

It seems that the report run the query and onopen code while I open it for
design and save which takes a long time.
Are there any workaround for this?
Your help is great appreciated,

I would like to know how to sort a calculated field in a report, so I can
see the person with the highest number of leads first.  
From what I’ve read, I should create a totals query in order to link that
information and insert it into the report.  I don’t know how to do this.  

Hello all, I have an access report I am working where I need to sort
different tiers/layers and they all need to be sorted in descending
order based on the overall count.  I am working with data in the
following format.

From what I learned from this forum I am able to make statistics report for
number of gender, male and female using this formula in the source control:
=Sum(IIf([JenisKel]="L",1,0))
L= stands for male

I have a report with multiple subreports on it, one for each month.
The subreports are linked to the main report via a project ID, and some
projects dont have data entered for that month.  The missing data is blank
but I want to show 0s.  I have tried

I have a database with multiple reports. All the reports run without a
problem except for one. This one report is behaving oddly. It will not open
when one attempts to run it. Also, if one attempts to open it in design view
to try to troubleshoot what is wrong, the report will ...

It's me again.  Which means the solutions you offer cannot be coded in VBA,
for I am, the Macrobater! ;)  Kidding aside...
I'm trying to create a document in Word.  The document is a trip report
which contains all deficiency reports pertaining to that site at the end of

I have created a list box with about 20 categories. I need to have a record
count of each category in my report. Please help. I have a total of all but I
need individual totals.
Thanks!