We are trying to design a table that has a look up field.  
We want it to look up from another tables look up field,
which is a list. Can we do this?

I would like to obtain a sum total on reports for billing
codes that identify patient charges.I have various codes
so i want to specify them by their respective code to
obtain totals for each.Is this possible in reports?

I want to design a table to store data on labtest aquisitions, to
print out labels later. It will be a list with 100  different tests,
every test with its own checkbox which you can select. Is it possible
to store only the "Yes" values and discard the "NO's ?

I'm wanting to set this up but am unsure of the best way to go about it. All
I have is basically a 'service' which will belong to particular areas i.e.
service a, suburb a, suburb b, suburb c etc.
Service b, suburb a, suburb d, suburb n etc.

My company is in the middle of XP deployment, including
Access 2002 upgrades.  Part of the people have Access 97,
part Access 2002.
My problem is that the Access 1997 users of an Access 97  

When I originally designed my table, I used one field for the Witness name,
called [WitName].  Now, I would like to divide that field into two fields:
[WitFirstName], [WitLastName].  Is there a way to do it without a lot of
manual data entry?  If it has to be done with VB code, ...

I am trying to set up a field in a database i'm creating
to generate a specific format the same way Autonumber will
generate a 1 then a 2 and so on.  I want my format to come
out as J624C-742 then J624C-743 then J624C-744 and so on

How can i query/get the following in an MS Access 2002
Database: -
1. List of Indexed Fields in the MDB
2. All the Primary Key Fields in the MDB

Does any one know if there is any bug in Access that makes
some of its tables lose their relationship to one another?
this happend to me couple of times without any reason.
thanks

On my form, i have tried the steps with the command button to open an excell
worksheet  on event but the results are it opens a workbook and then i have
to use file open on the workbook to open a sheet.Is there a way i can use the
command button to open a saved worksheet(for ...

Hello All Experts,
I have been after this for quiet some time now :-(.  I want to design a
database for a Restaurant.  As I am a newbie on the learning curve I need a
helping hand to guide me thru.

HELP!
I have an access 02 database, split frontend/backend
(backend is tables only) being run on an NT 2000 server
in a multiuser environemnt.

Is there a way to set up an Auto Number field that will start at 10,000 instead
of 1?
Thanks in advance for any help!

I copied an access .mdb from a friend's website to do some development on
my development server, but I'm having a little trouble getting the database  
opening up correctly. I get this error;
"Microsoft OLE DB Provider for ODBC Drivers (0x80004005)

I have numerical data that can be categorized, among
other things, by a structure like:
GROUP      Value
113100     $1,000