error window says "Microsoft Access couldn't find file 'system.mdw'  This is
required for startup."  I insert MS Office 2000 SR1 to let it look for it
there.....
No help.

I have a table which holds students answers to multiple choice examination
questions (A, B, C, etc).  I need to select records according to the subject,
make a table of these records and then format the table according to the
requirements of a third party system to which the data ...

I have a table like this:
System  (Text)
SeqNbr (Nbr)
KillFlag (Boolean)

Hi! i need help on left outer join! when i use two table and with outer join
it works. i want to know if i could use another table (t3) wich i don't need
any outer join, just to import the table where i could use it WHERE
statement. i get an errror msg. i don't know how to import ...

I have a date field in my query.  I need to create a new field in the query
that extracts the month and year only.  I can create a new column in the
query and change the property format to mmm/yy, which looks good and sorts
correctly, but why when I click on a date in the query ...

I have a pretty serious problem which is completely repeatable:
Resizing a subdatasheet column that is based on a query, and saving the
query when closing the datasheet erases the query definition (seemingly
only if the query is defined in SQL mode). Meaning the query definition

A query is created from a Texas University in an Access 2000 mdb.  The name
of the Query does not appear.
I have the Hidden Boxes checked so that all tables and queries will be
displayed.  When a Query is created using the execute.connection "Create Proc

Problem: I can set criteria for querys no problem, BUT when I use a field
that I create from a list the criteria doesn't work....

I have a table with about 125,000 records.  The fields consist of Customer
Number, Item Number and Price.  Each record indicates a purchase by a
customer.  Many of the purchases are for the same item, at the same price;
however, there are occasional price increases.  Here is what ...

I am using mail merge to do a large project.  The letters have printed fine.  
I cannot get the "envelopes" to use the database names and addresses in the
database.  The envelopes print with only the return address.  How do I get
the envelopes to print with my mailing addresses ...

I have developed a query that will run okay standalone, but when I run the
query from within a sub-form the results are bogus. It appears there is some
sort of linkage issue when running  the query from within the sub-form. I
used the wizard to create the sub-form with the query.

I have an alpha numeric field with entries of varying length and would like
to just keep the numbers
C/O NICK W MANFIELD9653 W BLACKJACK RIDGE
would become 9653

I have four columns in my database; 1, 2, and 3 contain numbers. Column 4 is
where the smallest number out of the other three should go.
I need Access to compare three fields (1, 2, 3) and return the smallest
value to me in a separate field (4). The catch is, I need it to return ...

How do can you write a query to show a running total.  If I had a table with
employee, date, amount how would I get a additional column to show the
running total
Row 1 - Smith, 1/1/05, $500, $500

I have the following SQL which I need to amend to do the following
1. Exclude all records where [GL Codes].[GL Account] = 4301005 and [SAP ESS
Line Items by Exp Cat].LocCurrAmt is less than 75
2. Exclude all records where [GL Codes].[GL Account] = 4301001 and [SAP ESS