I have a table (table1) which records scores of 0 to 4 for about 70
people. The scores are in a field (F4).
Is it possible to build a query which will return the percentage of
people who attained a score of, say, 3 ?

Hi, I am new to access and am trying to create a simple database which
does the following:
Record Serial numbers against users and locations. Once the records
are complete I would like to be able to mail a report to another

At the moment I have a button in a subform that appends the information to
another table and deletes it from the current table.
What I would like to do is put the button on the main form and change the
append and delete queries so that it only deals with the record with the

Any help would be sincerely appreciated,
I have an Access 2003 MDB that works fine under fully patched WinXP system.
However the same 2003 MDB is throwing an error under an up to date Vista
Business OS.

I have a date ordered field and have been asked to identify the number of
days since the last 24 hour or more period with no orders. So if I have
orders on 5/1/07, 5/2/07, none on 5/3/07 and then an order on 5/4/07 have to
create the value 5/3/07 using the dates where I do have ...

I have done this before but have forgotten and cannot find it on Help.  I
have a query to find a student by surname but I wish the result to open in a
Form.  How do I do this?  Any urgent help would be appreciated.
Mel

I've a Table that has records regarding birthday, Wheight, Height, sex ond
some others fields, I want to build a form to search/sort my database.
TblOriginal
   BD              Wheight(Kg)    Height (cm)    (...)

Below is an SQL asks me to enter a perameter value for X.MBFAM# every time I
try to run this query.  I have written several other SQL's just like this
that have worked nicely.  The PK for the C47FILES_TRANS table is TRFAM# and
the PK for the C47FILES_MEMBR table is MBFAM# and has ...

Hello. I need to build a querie that delete a record if one of this values is
the first of the day: "Saída torniquete 1" or "Saída torniquete 2" or "Saída
viaturas".
Imagine that I have this

I have a database of retail properties.  I need to create what I think is a
fairly simple query to find "similar" properties.  I am comparing square feet
and sales volumes.  I have set created a query where the user inputs the
ranges, but I'd like to have this done automatically. ...

Hello. I'm creating a querie that lists all employee activity. So the querie
runs onver a table that has all In and Out of the employees registries.
Sometimes in the the first day is Out, it happens because the employee
forgets to register is Out of job. So, is it possible to ...

I'm working on an application using Access 2003 English. My client is using
Access 2003 French. There is only one problem with this "cross-languages"
usage.
In Access English a parameter from a form in a query would be:

I am collecting 3 values from a form - [1stpayDate],[1stPayAmount],[LoanNo]
and appending it to a ScheduledPayments table through an "insert into" sql
statement (append query.
Query works fine, problem is I'd like to be able to add an additional 12

May i know how to query all the jobnumber where it is in the same category ID?
Because I want to use this as my list in combo box

I have a web reporting application that uses an access db. Each time a user
requests data the report passes 1 parameter (wonum) and the query creates a
temporary table. How do I make sure that each temp table gets an unique
name?