does anyone know if access 2007 has increased the capabilities of their
queries? i have a query that was built in the 2003 version that keeps giving
me the subject line error message.  the query includes 7 fields that have a
criteria requirements. it works for about a month and ...

I have a report which I must Look like the following:
Country 1:
Factory 1:
               Date 1    Date2    Date3    Date4    Date5

We are in planning to upgrade a system that we're using for MRP soon, but
want to know what the differences are in table structures between the old and
the new versions. Is there a way that MsAccess can help with automating this
process without having to manually compare each ...

I have a form with a query as the record source.  The form has a
control (entercode) in the form header that is used as a seach field.
The user enters a code in the control and clicks a button to find that
code in the query.

I want to have a report that shows a bundle number, and the total amount of
records in the bundle, and then showing the completed records in the bundle
and the incomplete records in the bundle.    Is there a way to do this?
I tried to make a query for all the records which does a ...

Developed report with a sub report with the data coming from the same table.  
The Contract # is the linked field.
If a contract has no change orders I do not want it to print the original
contract info on the report.  If I go to query and put "is not null" in the

I've created a Table to hold various pieces of information, I also have a
table with addresses.
I would like to be able to enter the postcode in a form which would look up
the address table and return possible answers. Then I would like to be alble

How can you make Access field formats show up in a merged Word document?  
(For example, wanting a currency field in Access to show up in a Word
document as currency with 2 decimals)

I am getting the following error message
Your Engineering Work Request database or project contains a missing or
broken reference to the file 'PPCTL401.OCX' version 1.0
any idea what that means, I wrote the database in 97, people may have opened

I have been trying to figure this out for the last 14 hours and am
making almost no progress. Any help is greatly appreciated.
I have two tables: one is a large table of parliamentarians, dates of
their speeches in parliament, their party and other such info (many

I've written a database to take care of our company's invoicing each
month.  It works just fine, but I'm having trouble figuring out the
logic to get the summary reports to work.
What I have is:

We have many people within one town with a zip code beginning with zero.  We
can put in the Town, the State abbrviation, but can only create a field to
accept the last 4 digits (non-zeroes) in the field we are using for a zip
code.  Any ideas?

When creating tables in Access 2007, do you have to create indexes to
improve performance or are they already built in?
Thanks for your help,
Louisa Holt

I have an Access 2002 database, with tables linked to a SQL 2000 Server via
ODBC driver. What is the best way to append data (create a new record) to a
SQL table using data from a local Access table? I've tried append queries,
pass-through queries, and considered creating an ...

I am trying to connect to an ODBC table, which I have connected to many times
before. However, I am getting the error "The operation failed. There are too
many indexes on table "INVMST". Delete some of the indexes on the table and
try the operation again. If i try to link the ...