I have a time field that I want to store hh:mm:ss. I can set the custom
format to 99:00:00 and the user can input the time but no matter what I do
the table only displays hh:mm.
Thank you.

I'm trying to create a chart based on a series of data entered. I need it so
the data is entered into a series of fields, then those fields are put
through a calculation. If the calculation is over say 1000, another
calculation is used to determine the x,y of a scatter graph and ...

Is there a way (2000) to see or print a menu that will show the basis of a
Query and/or a Report?  I would like to see the structure of my Reports, i.e.
the Query(ies) they are based on; the structure of Queries, i.e. the Tables
and /or Queries they are based on?  

Access 2000 - query build example: I am multiplying 4.38 x $20,572.00.  I get
$90,105.36 and I want it to round to $901.05.  How do I get this result?
Thanks!
Sam

I am trying to set up combo boxes so that when I make a choice in the first
box, it narrows the choices that show up in the drop down box in the second
field? Anyone have any ideas - I am a novice.
PC

WHILE I AM CREATING A DATABASE IN ACCESS,
I NEED TO COUNT THE NUMBER OF REPEATED LETTERS FOR EACH ROW.
THE LETTER COUNT SHOULD BE PRINT IN SEPERATE FIELDS FOR EACH DIFFERENT LETTER.
I HAVE 12500 ROWS IN FIELD, CONTAINING A SEQUENCE OF LETTERS OF "A",

I have two tables, tbl_Student and tbl_DSSR. Each student needs to have
their own DSSR table, which means, a student John may have a tbl_DSSR_John.
Please show me some ways to do that. Thank you very, very much. This is such
an impossible task.

I am having problem with a table design. The table is for
Quality measures. A couple of the attributes for the
Quality measures table are the Company name and Group
name.

I defined an Input Mask entry as !LL0-00 to achieve entries in a text field
with a length of 6 to appear as EN1-80, etc. When I test the Input Mask in
the wizard, it appears ___-__ as expected. When I make entries in the
affected field in the table, the mask displays the hyphen ...

What is the difference between primary key and index in Access?
If I define an Index field which is Unique and Not allowed Null, is it a the
same as a PK?

How do I set up a series of combo boxes so that when I make a selection in
the first field, it narrows the choices in the second field?

I have a table that contains five categories of checkboxes which total 130
checkboxes.  Would it be better to have it designed this way or use a table
for each category, making one checkbox field and selecting from a combo box
which options are true?

I have Access 97. I have a "tmp" table that is created in code via a query
(or SQL statements), I then need to modify 2 of the fields to be index (dups
okay). I cannot for the life of me figure out how to do this in code.
The field is "Approved", it's a YES/NO field, the table is ...

I am creating a data base and want to add a formula to my table so that when
a form is filled out an automatic number is assigned to each new document.
The starting number will be 05-001. Is there a formula I can write? Or is
there another way to achieve this?

I have a database on Projects. I have PROJECTS that can have many
participants, and PERSONS that participate in many PROJECTS.
Therefor, I created:
- a PROJECTS table;