I'm having trouble getting this to work:
delete A.* from A  where  exists(select * from A, B
where a.empno = b.a_empno and a.paycode = b.a_paycode and a.hours1 =
b.a_hours1 and a.date1 = b.a_date1 and a.pos = b.a_pos);

I'm trying  to find the differences between two tables, A and B.  There are
some records in A that are not in B, there are some in B that are not in A,
and there are some in both but with differences in the fields.  I'm not
getting everything. Does anyone have any ideas how I can ...

       I have a Query which filters out certain records from an existing
Table, how can I copy these filtered out records which were based on certain
criteria, to an existing Table which have exactly the same name of fields as
the Query?

Hi everyone.  Using A02 on XP.  This may be a dumb question but I have a
UNION ALL SELECT SQL query showing me all records from 3 tables
[tDistributions], [tDistributionsArchive] and [tDistributionsArchiveOld].  
Why can I not edit any fields?  

I have a need to make a table of date (1/1/2008 - 1/1/2018).
All I need is one field with each date for the next 10 years.  Can anyone
suggest a simple query that I could run to make such a table so I don't have
to manually type all the dates for the next 10 years?

I'll start out the question with what I'm trying to accomplish.  Basically,
I've created a form that populates data into a table (lets call it table 1).  
I want to be able to reference this table against a master table (call it
table 2) and return the matching results.  The form ...

I need to run a join query looking for all entries in Table B that correspond
to the same address is Table A.  The common fields are StreetNumber,
StreetName and StreetType.  It is a join showing ALL records in Table A, and
only those in Table with a match on all three fields (i ...

I'm running into an issue and was hoping someone could help.  I have a
query that I'd like to calculate the time between two dates.  There
are 3 date fields involved:  Received Date, Tasks Complete Date and
Closed Date.  If Closed Date exists, then it should calculate Closed

This is additional question from my post earlier:
I'm trying to use combo1  from existing open Form into  query builder
as criteria for row source of a listbox in another open Form using
"Like" to find all title_description has keyword found in combo1

       I have a query in the Design View, where I have grouped all relevant
fields like RESERVENAME ,ROOMNO, ARRIVAL and DEPARTURE.
I want to add a calculated field called DAYS which calculates the DEPARTURE
minus the ARRIVAL.

This is additional question from my post earlier:
I'm trying to do a subquery that uses "like" to find all companies in table2
that have a keword in their name that is found in table1.
The following returns the error "at most one record can be returned by this

Hello all.
I was curious if there was a hotkey that would execute a query in access
2003, and one that would toggle back to the sql editor? I ask this because I
have a lot of testing to do and the extra clicking is becoming tedious...

I have two tables with all most the same information. How can I update from
one table to another
using an update query. I am trying to replace missing data from one table to
another.

Hello.  I'm using Access 2k.
I have a table that contains a field with single parts of a company name
that I would like to compare to another table's field values that contain
full company names.

I am using a simple "between 01/01/08 and 01/31/08" criteria in a query.  It
is returning records with dates of 01/01/08 and 01/30/08.  I've never seen a
query include one date and not the other.  (I have seen other query tools
exclude both dates and return only records 'between' ...