I need to have 1 of 5 different values added to a field in a table based on
the value of another field. eg. if X is between 1 and 100 make Y=1 OR if X is
between 101 and 200 make Y=2 OR if X is between 201 and 300 make Y=3 OR if X
is between 301 and 400 make Y=4 OR if X is ...

Hello!  I need someones help INCREDIBLY BAD!!!!!
I have a class that I have to design a database to document
collection so that you can retreive and report information about th
items, costs/value, etc ....

Help to design a database

I'm looking for an attendance chart in which I can input the name, date of
absence, reason of absence, and the service level of my company that day.  I
would like a form to enter the info in and the ability to run a report on
individual reps.  Thanks for any help you can give!

Problem
In a multi-use database, how do I restrict a user from having access to certain records and allow it for others.
The scenario is as follows:
The database handles records for a mental health organization.

I am using Access 2000 on a computer running Win 2000.  I have created a
database with all the tables in a seperate database.  All the
forms/macros/queries reside together in another database.  The databases are
accessed by my biomed group via a WAN.  As I upgrade features in the ...

I am about to split a large Access 2000 DB. The BE end will reside on a file
server with 4 versions of FE distributed to a variety of users on their
desktops. What should I expect from the FE when the server is off line? Will
the FE still function and update tables when the BE is ...

Is there a way to set up a "flag" that notify's you of a potential issue?  
For example, a field was not filled out in a number of fields and its been
past 30 days since the last activity.

Hey everyone...for some reason i cant seem to figure out how to link a table
to display my subdatasheet.its really imp...n ive been trying but the links
with the fields.cant get it right....can someone please reply

how do convert the first letter of a name to capitals in access

how do I add a header and/or footer to a table in datasheet view in Access 2000

Guys/Girls,
Just thought you might be interested in an article I wrote yesterday...
'How to undelete Tables and Queries in Access' - includes VBA code.
http://www.everythingaccess.com/tutorials.asp?ID=13

Do field names have to be unique even if they are in different tables?
I have 10 tables and the first field in each table is ID; while it makes
sense that is what it is called, do I have to go further with the field
name?

This has worked in older versions of Office Professional but it doesn't work
in this version.  Any suggestions?

How to return unmatched items in a database to give total picture instread of
just matched items