I have a database which I import emial addresses from several sources then
remove duplicates by using a Select Distinct query (before sending product
bullitens etc by email).  
I also have another table in the same database which I hold "unsubcribe"

Windows XP Pro
Access 2002 (XP)
I am getting this error everytime I try to run this query.  This query is
simply ouputing a total of all services along with each order number.

I am having trouble writting a query to compute the average quarterly cost
for the data set below.  
MONTH    COST
4    67

When I type a letter & find I have inserted the wrong letter or replace the
complete word insted of just replacing word or letter it wirtes over the next
letter or word so there is no space between removed or replaced but over
writes all so I have to start from begining again & ...

My regional settings are UK English. Im looping through a recordset using
some of the values as criteria to run an query in each iteration. My
problem is that Access is interpreting the date differently for no apparent
reason. Below i have the basics of the loop. Note that i haven;t ...

I have to process a large table with column names that are not fixed.
Each record contains digits. Some columns will have digits from 1 to 5,
some 1 to 6, some 3 to 5 etc. I want to count the number of each type
of digit in each column eg.

I am working with Access 97 data.  One field was used to enter an amount of
time in minutes using the number format.  The number 15 was entered for 15
minutes.  In totaling these figures, I would like to separate it by hours and
minutes.  I currently sum and then divide by 60 for ...

I am trying to implement  a flexible query form by which the user can select
multiple fields or all fields to be searched and create a list of
values("keywords") to search on.
I already have my form with combo boxes that allow the user to select the

I have a field called case_detail into which several paragraphs can be typed.
When the case is ready to be summarized, the assistant adds her summary
paragraph to the beginning of this field, separated from the other paragraphs
by a hard return.  I need to create a new field ...

I have to write a query that describes the tables in a given database.
In mysql it is something like this: "describe tables".
Can anyone tell me how it is written in access?
Thank you

I'm trying to find a function in Access that allows me to look at the prior
record and create an if statment off of that record. Is there such a
function??

I have Microsoft Office 2003 Professional installed on my computer and I have
two different books on Access 2003 "Programming Microsoft Office Access 2003"
by Rick Dobson and "USing Microsoft Office Access 2003" Special Edition by
Roger Jennings.  Both books reference Design ...

I usually work with FoxPro using SQL.
Now I have to use Access to make some queries.  
Could any of you tell me if I need to install some libraries to use group
by, etc.

I have myTtable and I have ClassID field, now I want to bring myTtable.* for
at most 10 students for each ClassID. There might be more/less than 10 per
ClassID, if there is 10 different ClassID in the database I should be seeing
at most 100 records. How can I write this query?

I have an application that requires data to be updated after reports are
created.  The user is prompted from form for a report type needed via
drop-down list (Combo13).  User selects option(s) = 10 - Hearing Letters, or
13 – Cancellation Letters, or 20 – Finding Letters.  Upon ...