I'm building a medical case management database in which the patient will be
asked a series of questions to assess their current situation, with
additional questions asked depending on their answers.
The two main tables are:

I need to store the web visitor's IP in a field. I thought of creating a
numeric field but I've been told that because the IP has numbers and dots
should be stored as text. However, if I choose text I cannot group by it.
What's your opinion?

i have a database where i am trying to store information about 5 different
types of machines by using a table that holds the common information, with
relationships to tables with the uncommon information in a one to one
relationship.

after i  changed the name of one of our computer, we got a shared Access
database, when i tried to open the database in another computer, it says
invalid pasth......, so what is the problem?

I did what was suggested below- and it worked and grabbed the RATE field in
the query from the rates table.  However I  needed to add the delivery yard
Name and the pickupd yard name to both tables because there could be the same
deliv yd number with a different name.  

My table is on a sql server ,
all works fine, but in a form i have to make a newrecord
i want to say that my date field in my table shall be

I am fairly new to Access.
I have two tables with a one-to-many relationship.
TABLE1
Model Number (primary key)

I have several tables that are all connected by Entity Relationships in a
reasonable fashion.
I want to pull data from 4 tables (already in sub-datasheet design) and put
them as sub-datasheets on one Sub-Form, but Access is not recognizing the

I'm working on a project where the student is advised.  I've came up with
several tables but not sure how to link them.  I have a STUDENT table which
has a subtype of undergraduate and grauate, ADVISOR table, MAJOR, DEPARTMENT,
COURSE, a linking table of STUDENTCOURSE, DEGREE, GRADE ...

I'm distributing a program using Developer extensions which is packaging the
Access Runtime with it.  I need to turn off the record changes and action
query confirmation pop-ups.  How do I do that in the distributed versions?

I have found some advice in regard to DateAdd which seems to be a good way of
generating a date in the future.
What I have been unable to find is whether this can be used in a table or
only in a form as the help on the subject is limited in this respect.

am a new user and not a programer or anything of the like.  I have taken a
user course on Access.  What I want to be able to do is have a contact
database for our company.  I work for two accountants that are partners. I
figure on one database per partner and one for joint clients. ...

I've created a database for all students enrolled in a university science
program and now I'm having great difficulty extracting the information I need
without having to create a lot of queries.  
The database must include contact information about every student ever

I need to analyze supplier data from a third party internet purchasing site.
I am going to dowload the purchase data to access. I  have then been tasked
to evaluate supplier compliance. The fields dowloaded are;
supplier name [10k active suppliers, 100 contracted suppliers]

I tried to add a new column for my table in dsign view. I get this message
when i open it for design.
The database was actually converted from Access 97 to 2003.
Please help. it urgent.