Hi.  I’m relatively new to working out how to structure tables, so hope
someone can help me
I need to set up a case tracking database which tracks leads and where they
come from and then when they turn into actual cases, the progress of the case

Is there a template available for Access 2000 to use for design for analysis
of a questionnaire??
I'm stumped...can't seem to make heads or tails of what I thought was a good
model (but I am having trouble translating the model to Access design...I

MS Access 2002 SP3
Building a fairly complex financial forecast model.
Several nested queries. Well into the nested query ran
into Error 3190. Anyone know a workaround other than

I need to set the field size in a field which's data type is:
-AUTONUMBER
-NUMBER
I've been told it is possible, but I don't know how.

I need to set the field size in a field which's data type is:
-AUTONUMBER
-NUMBER
I've been told it is possible, but I don't know how.

Further to my post of yesterday titled 'best way to display' in Forms, I
received a helpful reply but in trying to implement this, I got confused!
What I am trying to do is to list training requirements of a particular
position (post) in the company. The training required depends ...

I need to set the field size in a field which's data type is:
-AUTONUMBER
-NUMBER
I've been told it is possible, but I don't know how.

Good morning!
My team is considering building forms in code so they will dynamically open
and close upon exiting the database. The question is, "is creating dynamic
forms from code better than housing static forms in the database in terms of

I have a problem with my Access program. The problem is that I would like
took calculate time differential and i do not know how to do it. I wrote in a
query this formula and did not work:
  New Time: [TIME]-[PREVTIME]

I have a problem with my Access porgram. The problem is that i whant to
calculate time differential and I do not know how. I wrote a simple formula
bot did not work. The formula was as follows:
Time Frame: [TIME]-[PREVIOUS TIME]

I am designing a mortgage aplication form that will be shared across a network.
I want to create a data access page that the users can use for data entry.
I had to create 3 tables for all the feilds. I have linked the tables
primary keys together using a one to one relationship. ...

I have a serial number table contains Serial numbers.
I have a field on a form lookup the serial number in the serial number
table. The selected serial number and other info on a form are recorded in
another table.

I need to design a database that will store set customer details, but that i
can change weekly to record sales figures. i need to keep record of past
dates and figures, without having to key in all customer details weekly.
i have the general jist of what to do but am getting stuck ...

I need help setting up a data base that will track leave for 270 employees in
10 different sections over the fiscal year

I often need to send the same email to multiple clients and would like to
know whether I could store all of their email addresses within one contact to
make it quicker and easier. I would like to just be able to click on the
general contact named "clients" and for the email to go ...