I'm trying to let the field have a particular value if it satisfies a
condition else another value must be displayed. Any help?
Thank you.

Hi, I have a report "votrial" which is based on a query "vototals" which
totals by date for each unit.  I want to be able to choose which two weeks to
report (usually but not always, the last two reports.)  The field name is
"vodate."  

Can anyone suggest what I can do to stop my report repeating itself?  I have
my information, 8 lines that keeps duplicating itself for 5 pages.  I only
need to see it once, not 25 times.  I know I haven't provided much technical
information on this but I've never seen this before ...

I have a database of contact names and addresses.  The address is entered in
the table in a series of Text data type fields e.g. Add1, Add2, Add3, Add4,
Town, County, Postcode.  
Not all contacts have data in e.g. Add3 or Add4.  

I teach at a school and am looking for a way to keep track of the scores my
students get on several tests.  Additionally I want to know which questions
they miss so that I can analyze how I teach the same subjects for the next
year.  (i.e. improve my teaching in areas where lots ...

How do I set up a report where I need to add the values from 2 fields in the
same report? Each of the two fields are calculated fields. For example:
CalculatedActual:
=Sum((IIf([Ind]="Actual-LIHTC",[1],"0"))+(IIf([Ind]="Actual-HTC",[1],"0")))

I added sorting and grouping to my report, but now I want to remove it. How
do I do that?

We discovered that if you have the property sheet up for a report and
activate the query builder and then close the property sheet before you close
and save the changes you made in the query builder, all your changes are
lost. If you close the query builder first and then close ...

I have a report that gives detail of transactions line by line, one
transaction on one line. I need to put a total in the report footer for the
number of transactions (ie the number of lines) in the report. Is there a
COUNT function somewhere which I can put in a text box in the ...

Good Day All,
I am wondering if it is possible to use a SQL Statement for the Control
Source of a text box?  If so, how would I format it?  I have tried to use the
SQL below but I get an error.  Any help would be greatly appreciated.

I have a table which has index on id and Amount field (table 1). The table1
has more than 20,000 records and will keep increasing. There is another table
table2 which is related to table1 by id.
I have created a form based on the query which links table1 and table2 by id

I have created a report with background colours. The print preview shows the
background colours, but they don't print out. Coloured text is OK. I am using
a new printer (Canon MP530). My previous printer (HP laserjet) had no
problems. I can successful print background colours in ...

HOW DO I MAKE A COPY OF A REPORT TO USE WITH A NEW QUERRY?

I have a report that i want to show the total cost and then the balance
due.... I have the calcs in the report as =sum[total cost formula] and the
same for balance due the problem is that when the report comes up the first
calc shows an addition of all my records  what should be

The problem i am haveing is, I have a query that works ( calcs the total
due)
and when i run it the values come up just fine... I cant seem to get my
report to see the query and when i try to "run" my report it brings up a