I have imported data from Excel into a table, the fields are essentially all
numbers.  However some of the cells where no value existed would have a zero,
others are blank.
When I did a calculation in a select query, (sum of 3 fields), the

Happy Holidays Peace on Earth Goodwill toward ALL !!!!!
I have a access .mbd that is on a win 2k3 server. When one user attempt to
open the db she gets a msg "Access will not open the db because it is being
accessed outside your intranet, or on an untrusted sight.".

I was just wondering how well Access databases work with ArcView 8.0?
Does anyone have feedback, suggestions, comments.
Can you us MDB with older versions of ArcView?
I am using both and have not yet integrated a MDB into either one and was

when I run my application I get message:
Run time error 2136
(to set this property open the form or report in design view)
When I press 'Debug' Access crashes.

In Access 2000, I have a VBA procedure that creates an Outlook mail message.
Creating the email is not a problem, but now I would like to insert a
hyperlink. I am using .HTMLBody to insert the message, so I would think
inserting a hyperlink would not be a problem.

I am compiling a database which has a cell for telephone numbers. I cannot
add long foreign numbers, as it won't type the last two digits?

I have a form used to enter data into 4 tables.  For some reason unknown to
me, the autonumber for the primary key (order details : order number) doesn't
change from "autonumber" to an actual number.  I must have done something to
it at some point to change this because it used ...

I am interested in developing a form which is conditional. I'll explain. I am
a doctor and I want to design a database to keep my billing from various
hospitals. I wanted to design a form , where  when I enter "hospital A" then
one particular subform opens up and when I enter ...

I have a table with the following data
month       reading
Jan             100
Feb             200

Mail merge problems...word cannot read the information I have in exel.

How can I or can you migrate Access forms and reports into SQL Server 2000?

I need to know if anyone would have already created a file or template for
the help desk in access.
I am using access 2003 pro ed

I have a membership table where date of joining is recorded.
I need to count how many joined each week and prepare the result to
show in a graph.
Please advise best method.

When my organization updated from Windows 98 to Windows
XP, our Access 97 Membership Files date of birth field
changed.  Some members now have birthdays in the year
2000 something.  This affected those born prior to 1935.