I have a table of statistical data points per part number.  I would like to
use the statistical functions accross the fields in the same record, but the
function wants a string expression for the name of a field.  How do I
represent 10 fields in the same record, each with a ...

I'm importing a file ech month.
Currently the entire contents are saved in a table populated with an append
query.
However, lots of the data (over 100 of 200 columns) is used very seldom.

I am looking to use a value entered into a form in a text box by the user,
that uses that value for query Criteria (Enter Parameter Value:). This query
will then be put out for a report. Is there an easy way of doing this?
Your help would be greatly appreciated.

I want to filter out specific cities within a field named CITY through a
query.  I have used NOT and <>.  For example NOT "city1" or "city2" or
"city3" in a query line and then in a column format.
I have also tried NOT "city1" or Not "city2".  Only the first listed city is

I have a query that creates a table with 7 total columns. What I would like
to do is create that table so that if 4 specific fields of a record are null,
they will not appear in the table.
For example:

I have a table that has customer summary info with [Totals] for 4
years(2002,2003,2004,2005).  I need to create a query that gives me the top
10 [Totals] for each year. Is this possible?  Any help will be appreciated.

I am a beginner in Access.  I was wondering step by step if someone could
help me?
I made a report that is based off of a query.  The query has in total 15
queries and a main query that sets the parameter.  So the parameters carry

I am having trouble creating totals in Access queries.  I have read all the
help, but still cannot get the totals to appear on the View query.  Can you
help?

I have a query and returns error "query is too complex" if I run it in
Access 2000. But the query runs well in Access 97 environment. Please guide
me to solve this problem.
Thanks.

I am using mail merge to populate a form in microsoft word.  I have a
query that is based on multiple tables in Access.  Essentially, the
query locates one specific record, gets corresponding information on
that record from numerous other tables, all linked by exclusive ...

I have a query with the criteria [Last Name].  It prompts us enter the last
name.  However, If I type Adams, and the last name is Adams Lovett, it won't
bring up the entry.  I would like to form a query that pulls up any entry
with any or part of the last name that I type in.   I ...

If I follow the instructions below and create a PK from a table created by a
make-table query, will the PK eliminate any duplicate records (ie - only
allow one of each value)?
I want the Customer ID to become the PK, but unfortunately, there are

How can I change in a Data Access Page the data query which is delivering the
data to the page?
Thanks for a quick reply.
Klaus

My question sounds simple but I really had a hard time to figure out it as I
am quite new to Access. I need join two tables. The two tables has two common
values (company and product) and I need both table's records to match both
common value before they can merger together. Here ...

I'm getting the message "The search key was not found" when running a delete
query. The on;y criteria I have is where the date field is not null. Anyone
knoe what this means?