Reports

Incorrect printout of report
Using Access 2002 I have a report in which the detail has 5 sub reports which contain a text box that is to count the number of persons who fit the criteria. That part seems to work. When I print the report I want to get 5 lines orf information. Instead I get one line printed the number of times the criteri... 7 Jul 2008 17:39

Grand totals in reports
I have a report, which correctly displays the total of the items in it. This report has a subreport, which also correctly totals the items. How do I get a grand total of both the main and sub reports to print? ... 10 Jul 2008 17:33

Grouping
i have an access2003 report which displays data like this week amount 1 10 2 10 3 10 4 10 5 10 6 10 7 10 8 10 im trying to group records every 4 weeks so i can get a sum. s... 3 Jul 2008 08:23

Sum of IIF
Sorry if this is a repeat, but I think I posted it in the wrong area before. I'm trying to use an Iif function between two columns that are populated in the db. The lines total across, but when I try to grand total them att he bottom, I get asked for more information or get an error. =Sum(IIf([Monthly Limit]... 2 Jul 2008 23:13

Dividinglines property in Access reports
I am trying to remove the dividing lines between records in continuous subforms in my Access reports. I have se the property to NO, but the lines are not disappearing. What am I doing wrong? ... 2 Jul 2008 18:05

Report Error for certain Crosstab Query
I'm developing a report that uses as its recordsource a crosstab query. All works well until I run a query where one of the columns has no data. For example, let's say I had a table that showed inventory at different stores and a crosstab query that pivoted on ClothingType and I had "Mens" and "Womens" in the... 2 Jul 2008 18:05

Sum Problem
I have a control called TreatWeeks in the Detail section of a report. Its ControlSource is: =Int([LOSDays]/7). This produces the desired result in the Detail section. In the Report Footer secion, I created a control with a ControlSource of: =Sum([TreatWeeks]). When I run the report, I get an Enter Paramet... 2 Jul 2008 17:03

duplicates within fields
Hi I have a table with the following fields: Surname Address Phone number Date I want to create a query that shows the latest entry for a particular surname, so if I have the following in the table: Smith, 1 New Street, 01234567, 01/06/2008 Smith, 5 Old Road, 76543210, 01/07/2008 Jones, 14 The Avenue, 98... 3 Jul 2008 04:18

Cannot open any more tables
I've read through previous posts regarding this error and tried printing even without previewing first, and I still get this error and the last two columns on my report do not print. Originally, I had 18 subreports based on 18 queries. However, I was able to consolidate my queries down to 9 since they were essent... 2 Jul 2008 11:54

Grouping two fields together ?
Hi, I've been trying to search for an answer, and haven't come up with anything. I'm hoping it's possible. I have three fields on a report: [DocumentNumber], [DocumentTitle], and [Filed With]. The [Filed With] field will be a document number that will coincide with another record's [DocumentNumber]. I am hopi... 9 Jul 2008 12:41