Got a sample of MS's "Advisor Guide To Microsoft Access" in the mail today -
accompanied by a sample "Advisor Guide To Microsoft SharePoint".
I skimmed both, but the SharePoint explanation is too abstract - it's going
right over my head.

I hope someone is out here who can help me with a simple calculation...
I have a sales data base in access with monthly sales history by
product. to make future predictions I need the slope (representing
growth) of monthly sales.

I know that this is not the rule but need some help. My datbase has
three tables:
MASTER
TEMPLATES

I am using the following command but it doesnt seem to work. Can any one
tell me why:
Insert Into PAT_MAIN (MRN, PAT_LNAME, PAT_FNAME, PAT_MI, PAT_BDATE, PAT_SEX,
FACILITY_ID) Select MRN, PAT_LNAME, PAT_FNAME, PAT_MI, PAT_BDATE, PAT_SEX,

I have a two part question:
First I want to insert data into a table and I am using the following
command:
   INSERT INTO tblmain

I would like a user to input a time from a dropdown menu and have the
three other fields update to the corresponding time zone. For example: a
user in PST selects 0800 from the menu. The other three field then
automatically update to 0900 MST, 1000 CST, and 1100 EST.  Thanks for

SELECT  distinct  b.t_orno, b.t_pono
FROM tblMonthlyBooking AS b, tblFilterDate, tblFilterDate AS
tblFilterDate_1
WHERE (((b.t_yearMonth) Between [tblfilterdate].[fromDate] And

I am creating a simple project information database. In the project
information form 1 have two subforms. one contains organization
involved - many organzation can be involved - and another list of
people; they are from the organization choosen, To help me select the

       Does anyone have a formula for calculating the number of days a
stock was owned?  Of course its real easy if you buy 100 shares on
April 1 and sell 100 shares on July 1 but what about multiple buys and
sells of different number of shares.

Is there a way of searching a sub-form (reading from a query) without
writing what is exactly contained in the query field.
For example if I had a 'Finance Manager' in the query but just wanted
to type 'Finance' in the text box to search or 'Admin Manager' in the

I am using access 2000. I have created a database and have applied the
security feature available as Ive got 2 different groups of users. I
have a 'managers options' and 'users options' forms in the database.
Is there any way that when the database starts up that I can open one

I have recently bought a new laptop (running XP Home) and wanted to
install my old, trusted copy of Office 97.  As it was, it seemed to
install OK and Word and Excel worked fine but when I tried to start
Access 97, I got the message "Out of Memory".

I hope this is the right group... if not, a pointer would be appreciated.
Our club is setting up a web site (HTML & ASP) with some information that
will be provided by an Access database. The problem that I've run into is
that the application fails because the Access driver is ...

At my work, there are multiple MS Access forms being used, all linked
to the SYSTEM.MDW file.  I, however, need to also create a form which
will be distributed to more than just my coworkers; some of these I
will not even have direct contact with.

I have the following code:
Dim strSQL As String
Dim DB As DAO.Database
Dim RS As DAO.Recordset