Is it possible to set up a register system in access and
if so how?

the problem i have is that the in tblAbsOccuranceLine the
primary key AbsLineID does not increment every time an
absence is recorded for a member of staff. In other words
an AbsLineID is never given to an absence, only an

can i use the access 2002 to make a databease which can be display all data while i input some key value
for example, i put the name of company and it will display all information about that company?I can make a list, but it's not that i want..please

Firstly, I'm no expert - but thanks to help from the group I have now
established a club membership database that can do most of what I
need. The bit I'm stuck at now is this:-
I have a numeric field that contains a 4 digit code. I want the form

Lets say I have four text fields 1, 2, 3, 4. I always
enter new information into field 1 but I need to have the
old Field 1 information automatically (or close to it) be
written to Field 2. Like wise old field 2 info to go to

We have a Database which we have recently converted from
Access 97 to Access XP.  Since then when merging it with
Word the dates have been giving us a problem.  
In Access the dates all display correctly as Medium Date

I have two different fields that I would like to
sequence.  Field 1 is an alphanumeric field and is unique
within the table. The format is "4E-##".  I simply would
like to increment + 1 for each record entry.

I am fairly new to Access from Excel - I realise that its
a totally different mindset so I'm asking for a little
advise.    
I have created a sample database that uses dummy data and

I'm thinking of changing my StudentID numbering from a 3-digit number
(650 students approx.) to a 9-digit number.
Can someone tell me if there would be any hit on the speed of
processing queries and reports with these larger numbered ID's?

in a text field, is each character/space 1 byte in size? so 7 characters
stored in the field in one record would take up 7 bytes of space? and 20
characters stored in the field in another record would take up 20 bytes of
space?

This may be the wrong subgroup for this question but perhaps someone can
recommend a better one.
I have a table that looks like:
Sample     Lab     Analyte     Result

I have a table that includes information about client projects that assist
them with finding a new service provider through a bidding process. I have a
field for the winning provider (related to the Providers table) but I'd also
like to have information about the 4-5 finalists, all ...

I'm wanting to use the Julian date format (YYDDD - common to the military) for use in my tables and forms.  The fields will return the format, however, I am unable able to enter the date in Julian format - I have to enter it in a standard format.  What do I need to do to resolve ...

I need to convert dates that are in the format of
yyyymmdd to just year and month.  How can I do this?  
Please be specific - as my VBA needs some work!
Thank You,

I volunteer for a charity where we have several databases
of patrons and contacts, all with different structures,
tables, forms, etc.  I am working on a new database
structure so that we can eliminate all the redundancy.