I'm trying to sum more than one field in thr report but it always shows error
my formula =Sum([Amount Claimed]) and it's a number field so what can I do
step by step if possible..thx

I am converting calculations from Excel to Access (2003).
As a newbie in Access, I am trying to find out how to use functions with a
range over a set number of records.
Suppose I want to calc the average, max, min or StDev of price over previous

Is there a validation rule which will indicate a field must be unique?

I have a database of employee details, name address, employed from, sickness,
etc.
I have a form created from the data.
I need a button on the form that when it is pressed will print an envelope

Is there a way in code to do the same query several times
looping it so it goes through say 5 or 6 tables,
selecting the same fields from each with same criteria,
and appending it to the same table. It would save a lot

The most comprehensive reply I could have wished for, thank you for the
effort of putting that info together, Im now off to explore the links.  Happy
Christmas.

I was recently promoted to a higher position at my work place.  I have a lot
of new responsibilities now and would like to do some of it at home.  I tried
to send a document to my home desktop but I can't open it.  It tells me that
it's an excel document.  Is there a program that ...

I plan to put an Access database on a server, and build an Excel application
that pulls data from it via ADO. Will each user need a runtime version of
Access on their local machine, or is a copy of Excel all they will need?

I need to create a database for a small school.  Objectives are basically:
Family information
For each student:
Course(s)

What is the biggest database that Access can comfortablely handle? I know
Microsoft says 2GB minus the space needed for database objects, but I have
seen much smaller capacity suggested by other non-microsoft sources.

We have several computers newtorked to gether using a hub. (No server)  One
computer has the access file on it.  A shortcut link to that file is on the
desktop of the other computers.  All computers have access installed. We
where using access 2000 and then upgraged to 2003.  The ...

I am very new to Access so I appologise if this is a stupid question but it
has stumped me!! I have started a new database and have created a table, I
have then created a form to input data into the table, it all works fine but
the only way I can get to the form is to open Access ...

How do I prevent a user closing my database by clicking the X in the top
right of the database window? Is there any way to disable this?

In
Access what does the 2 oblong connected circles mean?

If you have No records in a Sub-Report how do you get the report to read
Zero in the amount field?  I set the fieldto Zero on the default, that
didn't work,  I did an IIf statement on the Sub-Report and that gives me
a Zero Amount in the Total Field.  However when I try to get ...