I would like to create a delete query that uses a calculated value from
another query as the criteria.  When I set up the query initially as a select
query, it shows the correct records that I would like to delete.  When I turn
it into a delete query and run it, it will not ...

Is there any way to get the count of updates after running this?
strSQL = "UPDATE ..."
currentproject.connection.execute strSQL

I would like to know how to do the following as easy as possible.  Have a
list of unique business phone numbers about 2000 + can be more.   These phone
numbers can have several people listed with same number.  I need to split
this list by 5 or 6 lists as even;y as possible to ...

Maybe someone can help me out. First let me thank every one in
advance.
I need to make a query to out put the following
in table "A"  I have a field "Distance" this field contains a range of

I am trying to creat an update query that will take the decimal portion of a
number and multiply by 60, then create a new field with the result.  
Everything works fine until I have an end zero in the decimal places.
Example:  33.4680

I need to write a query that will strip parenthesis and the text
contained in the parenthesis.  Example:
current: The cow (jumped over) the moon
new: The cow the moon

I have a table of around 50,000 rows (table A) and another table of around
5000 rows (table B).
There is a foreign key in table A pointing to table B.
Periodically, table A records are archived leaving 'orphan' keys in table B.

I'm having trouble with a multiple INSERT statement:
INSERT INTO [Course Completion] (
[Course Completion].EID,
[Course Completion].Course,

I have an append query that has worked in the past but now when I run it I
get the long error message,"Microsoft Access can't append all the records in
the append query..." I have checked everything and cannot find the problem.  
Since I cannot attach the screen shot of the error ...

This is a little hard to explain, but here it goes.  I have a dataset with
weather data and I get data sent to me every 10 minutes.  The  date and time
is being stored together such as 14/MAY/2007 12:15:00 AM. etc.  However, I
want to base some summaries from say the 14/MAY/2007 ...

I have a table of scores and I'd like to obtain the most recent record for
each person, but not everyone has an entry for a particular day.  For
example, if I have three users with the following scores, entered on the
following days:

I need to summarise the financial transactions of our records from time to
time. Several tables are involved, many of them only remotely related, if at
all. Some tables are nearly up to 2000 records already.
I built a union query to capture all transactions of the affected tables. ...

I have a query that's probably far more complicated than it needs to be.  It
gets its parameters from a form where people can choose various criteria
they'd like to base their report on.  On the form you can choose from a list
box of Project Types, several check boxes of Services ...

Hello, can you please tell me what I'm doing wrong here?
I have a textbox (txtMonthYear) on a form (frmReports). The textbox has no
format, but has an input mask 00/0000
I want to run a variety of queries/reports off the value the user enters in

Hello. I have been trying to update a field using the value of the
same field in a different row. I have an policy table that has a
postal code field. There are several records per policy but not all
have the postal code filled in (the field was just recently added to