I want table of nominations which includes the Nominee, Nominator, and reason
for the nomination. The database allows for multiple Nominees per nomination,
so I used a UNION query to deal with that.
I want to be able to count how many nominations a each person recieved, so

My main table is called Activity with key field ActivityID.  I want to link
activities to other activities with a many to many relationship through a
table I have called Activity2PostActivity with fields ActivityID and
PostActivityID.  I want to create a subforms on my activity ...

I have been trying to import an Excel spreadsheet into Access but I have ran
into a problem.  Everytime I try to do this I get the error:
An error occurred trying to import file "the file path".  The file was not
imported.

I have the following expression  in a query. I would like to sort the
account # ascending however when I choose ascending in the grid it
groups all the 1's , then the 2,' and so on. I would like it to show
in numerical order. Any ideas.

Can someone tell me why my Autonumber which started with 5 digits all of the
sudden is going to seven digits and not in succession? It even has negative
numbers.!

Hi,  I have two tables "Client" and "Projects" that are related by ID number.
In the Client table there is a field named "TaxForm".
In the Projects table, I have a field named "TaxDeptNotified", which is a
text field.    Normally I would create a combo box on a form to select ...

I am trying to create a database to track product defects and yeilds. It
seems to be more time consuming than it should. I cannot find a template
anywhere. Can someone please point me in the right direction?

I have a list box that has several "business rules", maybe 20, they are short
phrases such as " you have to do this when...", " you can't do this
when....". I have set the list box up so users can select multiple "rules"
which is what I need. Now my problem is that I need to take ...

I am reading a lot about Access 2007 and the general consensus seems to be to
wait for SP1 to come out.  Does anyone have any idea when it is due to be
released?
thanks

I have a "Main Menu" switchboard style form that has numerous buttons that
open forms.  Each button opens a form, and each form has a menubar/toolbar
that has a "Exit", "Main Menu", "Filter", etc. buttons at the top.  Once I
open a form and press the "Main Menu" button, the ...

Could someone please tell me why the following section of code gives -317
days average dwell when there is only one part, (for info [Date Raised] is
24/11/2000 and [theMonth] is 01/11/200)?
DwellAvg: CInt(DAvg("datediff('d',Dateserial(year([Date Raised]),month([Date

I have a union query which brings together Process/Quality Costs, the
problem im having is that i need the first "Start Cost" to come through into
the second part of the query, so i can apply that cost to the second process
- for a total. this needs to go on for 5 to 6 processes.

I have a link file excel but I can't add or modify records.
How can I ?
I have Access 2002.

How do I calculate an average for a field in a table?
I have a form linked to a table and it measures an individuals progression.
the scoring is 1a, 1b,1c 2a, 2b,2c and the same up to 6c. It measures a
persons progress in learning the saxophone. As it is a group i need to work

Hello all...
I trying to do some validation of a record before it writes to be database.
Here's the scenario:
My table includes the following fields: