I am very new to Access and am having difficulty doing the following:
In an access table, I have a set of approximately 3000 tree diameters from
300 plots. I want to classify the diameters into increments of 2, and then
count the number of values in each class for all plots ...

I am been trying to think of a way out on this situation but I can not
clearly see one. Can anyone help?
I have tblOrder and tblOrderDetails along with a main frmOrders and subform
frmOrderDetails and I go along and process an order like normal... but what I

I've been sorting out my design for this and I *think* I have come up with
something that should pass the test! As far as I can see, none of the fields
or information is duplicated.
Please tell me if there is anything wrong with this (I hope it can be

Earlier in the year I devised a database to hold working hours information
for members of staff. Because I didn't know any better I used a 1:m
relationship between two tables.
In time for use after Christmas, I have decided to redesign it. I am using

how do I transfer the addresses or remane the personal file as the contacts
file'

I have a contact table that has the contacts company name, I want to use that
field to link my purchasing and inventory information. Any suggestions and or
comments that may help me ensure data integrity between all information would
be greatly appreciated. I guess my concern is the ...

The database I am using now has a 1:m relationship. Employee info is in the
main form and the records are in the subform. I know that for each employee,
dates are being repeated.
This database needs to be improved upon and  how the date information is

I am running Access 2002 and have created a Data Access Page that I wanted to
be a fillable form that would be used by other members of an intranet group
to record customer inquiries.  Although other members NOT having Access 2002
can view data entries in the database they are ...

I have 3 tables:
orders
---------------
order_id

Hi, I am sure I am being THICK, but I am trying to solve a problem with a
database I have created.
I am using Access 2000 (thanks to the NHS and its inability to provide
up-to-date equipment) and have managed to create a database which will now

I have six tables with autonumber key fields, that I have linked together. No
I need to add new record. How do I make it so tjat each table have the same
autonumber value. I am using form, but I need to make it also in tables.

Novice/WinXP/Access 2003
Good Evening
With good advice from this forum, I have a normalized db with one-to-ones,
one-to-manys, and many-to-manys.

I need to add a new field to a table.
I receive the warning prompt that I can't change the table design because
the table's pre-existing relationships.
The table change/add is very minor...but I see they have a alot of queries

I am writting a program in access but i would like to create my company's
logo to use as the program's icon.  How can i create my own icon

I have a relationship that I'm trying to set up nut I get the error "Invalid
field definition 'ProjectID' in definistion of index or relationship."  Using
the Help topic, I have noted that my field names are spelled correctly, and
it isn't a Memo field.