Morning, I'm still fairly new to all this stuff so bare with me :). I've
looked around and found lots of great help on this site before, but nothing
that specifically addresses the problem I seem to be having now. I'll try to
be specific - so apologies if I get a little wordy:

I have a table that I have created a report from. The calculations are done
on the report itself. For example field c was blank on the table so I created
a formula in there a/b, that worked. Now I am trying to get the avg of c. It
won't work.

I have a report which calculates the savings made at a projects final account.
however it also includes the interim payments.
my issue is where i have a payment recorded in one field but not the other
it allows the full difference to be claculated.

I have two queries/reports that work perfectly as individuals however I need
one report with the information for both.  I created a third report and added
the other two as subreports.
So Far so Good, the fields in both of the original reports are the same, the

I have a very simple database consisting of 3 tables - Volunteer details,
Client details and then a Record of Calls table that records which volunteers
have visited which clients and when.
I have built a report which uses a parameter query to give me details of

Hey Newsgroup,
although I think my problem is simple, I can't figure out how to solve
it:
I got a database collecting folders. Every folder has a certain status

I have a report which has a group header based on dates. For each date (~60)
I need specific information. One of the pieces of info I need to display is
the number of records where the "port" field is Y or N.
In the group header if I use DCount, I get the number of records in the

Hi, there,
I am working on an invoice form, and I made a report form instead of using
form print function.
I used a blank report to create the invoice report.

My report has the body, and if I have done it rightly, I have put a subreport
in the report footer to count various fields in the report.
The sub report is based on a query with 3 fields a count of the total jobs
since 1998 (this is working on the report ok).  There are three ...

I know that I can't use record total expression in pager footer.
However, I have to use page footer to show sum amount (not report footer),
since the detail section for the report gets grow.
Is there anyway to get around this problem?

I have a textbox on a report with the following:
="1:               " & [Provision1] & IIf([Provision2] Is Not Null,Chr(13) &
Chr(10) & "2:               " & [Provision2],"") & IIf([Provision3] Is Not
Null,Chr(13) & Chr(10) & "3:               " & [Provision3],"") &