In my design, i have two dates which will stand for date
of credit request received and date for credit request
done.Is there a way in either query or reports, that an
average time can be calculated to determine how long it

I am about to split my database for two users on a shared
folder on the network.I would like to confirm that once i
split it and link the front end from the users desktop to
the backend on the shared folder, both users can key in

In 10 years with Access, I've never run into this before.
The relationships in my database disappear! If I create a
relationship between 2 tables on the Relationships page,
then save any changes and reopen Relationships, the

I have a database that manages hot ait balloon flights.
I have a pilots table, a passengers table, and a flights
table to tie the info together.  
I had the system all set up and needed to add a notes

 I am setting up an invoiceing table with a form/subform.
My invoice numbers start with KI-then a number (I.E. KI-
100).
 I want to set up an autonumbering sytem that will add a

I have been tasked with entering excavation data from our archaeological project into an Access database.
The unique ID for each entry will be spacial (Excavation Unit Number)
Then I have a list of over 50 ceramic types commonly found at our site.  I need to input:
(a) raw count ...

Hi, I am a sales rep and am trying to track Demonstrations, Expenses, Miles,
and Receipts.
Without recreating all four tables, the thing they all have in common is a
Date field.  Of course I can enter many separate records per day so the date

I have an excel spreadsheet that has contact data in one
colume as follows:
name1
company1

I have an order form in which I have an order date and my
due date is 90 days after the order date. How would I set
this up in my table?
Thanks,

I have a user who changed the order of items in her table
using design view and saved it, and now is missing the
data that was in 3 of the columns.  Any ideas?
Thanks,

I have a very specific question.
I have a table with numeric values in field 3 & 4.  I
need to multiply these fields to create an additional
field in the same table.

The data extracts I work with are in Julian (2004214
equals August 2, 2004).  I'm wondering if anyone has a
way to convert this number into a value that Access can
format as a date?

I have a database with several fields and with 5 character fields. I want to use a Memo field to replace the character fields because the lack of space
How can I import the character field to the new memo field?
Thanks you
Valentin

I have three tables. The first table has a field called
INDEX. The 2nd table has a field called FUND and a field
called REFERENCE INDEX where I have a look up function to
the first table on the field INDEX. The 3rd table has

I have an employee table with EmpID.  I now need to create another table
that would use the EmpID information.  How can I easily? get the EmpID from
the employee table into the new table. Any help will be appreciated.
hanksor