I need to summarise data from several diferent tables on
to a single unbound form. The db in question is slow now
so I'm looking to avoid slowing it any more. My first
choice was to use a series if DSUM's but then I thought

My computer will not let me install Microsft Access 2.0.
It comes out with message c:\windows\system32\autoexec.nt
and says this is not compatible with MS DOS -which seems
a bit odd seeing as I've installed all the other Microsft

I want to use outlook express for my email office 97 Windows XP defaults to
outlook even if I unistall outlook

I am setting up an Invoice report using a query. The query has a calculated
field, "Extended price" (UnitPrice*Quantity). So far so good, I can display
all of this in the detail of the report. I want to put the sum of all the
extended prices in the footer as "Subtotal". The Orders ...

I have a combo box with a drop down list with 3 columns
belonging to a table. What method can I use to address
all other remaining fields of this table  not listed in
the drop down list after the selection is made  I assume

I want the default value for a date field (short date format) to have the
same value as another date field.  I have tried entering this into
Expression Builder as variations on =[dteStartDate], but it always returns
an error.  How do I get the default value in one date field to ...

I want to add more characters into a field can can be
permitted.  Is there a way to do this in a searchable
format. ie can i insert a word document that can be
searched

Hello group
My cboBox is Bound to a table with the values First Applicant and Second
Applicant, respectively.
I would like to have the default value of the cboBox set to First Applicant.

I have one of 2 options.  Which would be the best to use?
Table:  Customers, CustomerID (PK)
Table:  Addresses, AddressID (PK)
                            CustomerID (FK)

Which relationships is the best one to use?  Would they
both work?
Each employee could be assigned many assets.  Each asset
will have a history of transactions.

I work for a not-for-profit healthcare organization. I am fairly new at
using Access and I'm trying to set up a database of other facilities in the
region, using Access 2000. I need some direction and advice.
The main table contains facility information: address and telephone ...

I had Win2K and Office 2K installed (our standard office build).
Access 97 is then installed.  I am unable to run the spell checker in
Access 97, says it is not installed.
Is it possible or not to get the spell checker in Access 97 to work?

Does anyone have any "how to reference" ideas where I could get this info?
-----------------------------------------------------------
Wow, thank you so much for the suggestion. Sounds great to me, only I'm not
entirely sure exactly how to do it.  If you have any sources of info on ...

i have a form for processing claims. if an employee has
already claimed, he/she can claim again after 2 years.
how can i calculate the date of next availment?
any help or suggestion will be highly appreciated.

This is probably very simple but it's defeated me! I've
got a table with two fields, one is a name and the other
is a nickname. I've made a form with a combo box which can
select one field and it returns that field ok, but I want