I have a table for Equipment in a plant that contains all information about
the machine in general such as Production Number, Serial Number, Date
Purchased ect. Each machine has several sections that make up the whole such
as Feed section, Print Section and Cut Section. I want to ...

I'm trying to store a 1 or 0 in the field but don't seem to understand how. I
made a filler feedback linked table with input form.  I'm want to grade
several items, then total and come up with a % of failures.
Any help would be appreciated

I have a table with two columns, one with a number and one with text. Some
numbers are repeated owing to the text line being too long. I want the text
to appear on one single line for each number in the first column. Is there a
way to fix this?/Ove

has anyone got an example of a micro database ?
that i could use e.g. coli, e-coli, tbc etc

the ingredients of my situation consist in three tables
a) Audit Reports (parent): PK = "IRB Number"
b) Evaluations: PK = "IRB Number" and "Date of Audit"
c) Patients: PK = "IRB Number", "MedRecNum" and "Date of Audit"  (where

I am trying to create a database that will allow users to login and go right
to a form customized for them. They should only be able to modify data on
their form, and no one else's. Any ideas?

I am setting up a table that includes the field "First Name" and "Familiar
First Name"  I want the default for the second field to be the first since in
most cases, it's the same-I cannot find out how to do this anywhere!!  There
must be an expression or something???

hi,
I have a question that I hope one of you with more exensive knowledge on db
design can shed some light on.
I'm working on a db in access '02 that stores daily constituents of a

In Access, can you set a field that will flash or blink if certain parameters
are met,  for example, the number entered is less than 10?

This may be more suitable for the new users section since I'm a new user, but
it's about design, so I'll try here first.
I've got a monster spreadsheet I'd like to put into Access. It's becoming a
bit unmanageable, so I'm thinking Access is the way to go.

I AN DOING A DONKEY DERBY FOR CHARITY AND NEED TO MAKE A PROGRAMME FOR THE
RACE BUT DONT KNOW HOW TO CAN YOU HELP THANKS

I'm new at database design and I'm trying to make my first real program.
Administration /reservation of numberplates to be used in car garage
now the following fields are in the database
-user who made the input

I have a table TBL_Tech that has its PK as the TechID.  This is the FK for
two other tables.  I just found out that after a tech is terminated, the
supervisor will then assign his "old TechID" to the next "new hire" that
comes along.  Now that ID is no longer unique.  In the tables ...

I have a table populated by an append query. The append query appends those
records from the source table whose 'model-Nr' field has changed. I want my
append query to compare the record in the destination table with the same
'index key' field and that which was appended most ...