Hi there ... I want to DROP a PRIMARY KEY from an access table before I can
add a new one ... The code I have now is ...
ALTER TABLE info DROP PRIMARY KEY
but that doesn't seem to work ... Can anyone please help me with this?

I was pointed to the following to merge a current record to a Word document
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html
I worked out how to do this on one database because my information source
was a single table.

I want a list of all the queries in an Access 97 database. Is there anyway of
listing the names of all the queries?

I want to add a field to my query that displays "Approved" if the [Note]
field contains certain verbiage and "Review" for anything else.  
IIf([Note] Like "*Cost*","Approved","Review") works except that I want to
add several more conditions.  I thought about setting up a second ...

I created an Access 97 database a year ago and it always worked fine. Since
this morning, it does not work anymore.
I received the error : This expression is typed incorrectly, or it is too
complex to be evaluated. For example, a numeric expression may contain too

Either i have a problem with this query or i am the problem. i have query
that combines data from two tables.
but somehow, when i try to add another column to the query, i am not getting
anything. even though there is not data associated with the new column,

I want to create a form on my website but do not know which program to
use. Should using html be adequate for the purpose?

I have the following 3 fields in an Access 2 query
Under: ([Nett1]-[CCR1])
Sort Ascending
Criteria < 0

I am trying to build a query based on 2 tables.  Main Table has Entry#, Date,
Location, Product1, Amount1.  Product Table  has ProductID, Content, and
Catagory.  I am trying to add the Content and Catagory for the product that
is selected in the main table.  Because later on i need ...

I have two queries that I want to join.  I want to use SQL so that I can
eliminate the queries how would I do this?
Query 6
SELECT tblChecks.ChkTabID, tblChecks.ChkAlias, tblChecks.CheckID,

I have a table that has 20 date fields for each record. I need to select any
record that has a matching date in at least one of those fields so it becomes
a huge OR in a query and I have noticed that I am limited to 9 in a query. Is
there a way to do this efficiently or will I need ...

The database has a form which feeds into a table. The table has been
set up so that it contains a persons ID and then five fields in which
there is a choice of training course. The range of courses that can be
chosen for each field is exactly the same (from a combo box). There

I would like to be able to calculate distance from a specified location to
other locations in my database based on Latitude and Longitude. Any ideas?
Terry Schawe

I have a combo box that lists returns. The returns can be open or
closed. I want the user to be able to restrict the data in the combo
box if they check the [ckOpen] check box. I've tried several ways but
none of them work. Any help would be appreciated.

Help!  I am trying to write a query in access VBA.  The query is doing
a count and inserting the figures into lots of different sub tables.
After all the counts are done, I want an update statement to update
one big table with all the figures.