Can I format a field to only time interval so that I can use functions such
as average and sum to calculate average and total times.

How do I get data that does not display table when expresions are used in
Forms but the data is displayed in the form.

how many items may be placed in a drop down box?   Can it hold more than 25
items?

I have a database that I use to store job information.  The different type of
jobs consist of plan/spec, sheetmetal, design/build.  The plan/spec jobs are
bid to only one "owner".  The sheetmetal and design/build jobs may be bid to
several "customers".  I want to make sure the ...

I have two tables where one of the table's data is supposed to be a subset of
the other table.  In my particular case, the main table contains Specialties
(these are medical specialties, as in Cardiology, Dermatology,
Endocrinology, etc.).  The other table contains a subset of these ...

I currently use Access to produce letters to using send report to word RTF,
this is problematic as it does not use our Normal.DOT template, and our
formating is lost when text is removed - how do I overcome this?

I once asked (and received) help in this Newsgroup.  Now I'd like to recover
my question and the answers I had previously received.
Can someone explain how I search for my questions/answers?  Where would I do
this?  I'd like to search for all my previous questions.  An example ...

I currently have a database set up with one table of agents, one of
households, and one with actual accounts within the housholds.  In the past
we sent the agent the bill for their respective household accounts.  Now we
have more then one sales person being charged for one set of ...

how coul i link my database in crystal reports

I have created a new database but I want to continue the numbering from the
previous one AND I want the database to automatically fill in the next number
on the data entry form.  How do I do this?

is there a way to create a table using vb?
essentially, I want some specific table called tempT to be the rowSource of
a chart. but every time I open the chart I want to erase the table tempT and
re-create it differently using vb, so I actually want to erase an existing

In some (well-designed) programs one can input date by clicking the control
box (usually a combo box) and then selecting the date in a popped-up
graphical calendar. Is this possible in Access? And if it is, how? Thanks for
reading this and for the future answer.

We have a problem with an Access 2000 table where the KeyID field was
duplicated.  When we look at the table and attempt to append a record to the
bottom of the table, the KeyID number (Autonumber) that is generated already
exists in our table?  I thought this was not possible?

I have an address database.  Each member of a household has their own record.
Is there a way to link the two records (with the same address) in the table
or in a query? Or do I have to do it in code?

I'm considering creating my first database in Access 2003 and I am still
learning how to use it. I would be taking inventory of my belongings in my
home for insurance purposes. I would need to include photos as well. I would
like to be able to export the database to html and ...