Below is my SQL Code - Confirmation Entries such that if PalmHeight1 =
PalmHeight2 then Delete that entry in the second table.
DELETE PalmHeight.Height, PalmHeightSecond.*, PalmHeight.RDate
FROM PalmHeight INNER JOIN PalmHeightSecond ON (PalmHeight.Palm =

HELP!!!  I have a created a database to monitor all of our account
investment guidelines and test for compliance.  I have 2 main tables.
One contains a list of 118 accounts (the acct # is the primary key)
and 65 guidelines.  Some of these guidelines are specific to only a

Hi, I am trying to create an accident report that is grouped by year and
severity type and my select query result have fields,[Year],[Severity
Type],[Total Accidents] and my report should look like this:
Year

I have a table (tbl_Table).  It has the following fields and example data.  
I typed this in a table in MS Word so I trust you can copy it into word to
make it more legible.

Hi all! Hope you can solve my mystery guests!  If I put my pc on standby
when I later go to turn it off it tells me other people are using the pc and
they will lose data etc.
I'm the only user. Whats going on?

yea basic what the title says running a query by month. Currently im useing
the between criteria

I wonder if it is possible to create a query that returns only those rows in
a table where the number of characters is => 250 in the LastName field. If
so, can I have the code?
Thank youl

I am trying to create a macro or expression for a database that is a
little confusing.
In my database I have a column with a date of hire.  There are three
different rows with three different initials for Legal, Pension, and

Ok, this is a bit hard to classify, but it uses SQL and references
queries, so here goes...
I completed a database last thursday, and went to back it up and make
several copies.  Unfortunatly in my rush to backup, I backed up the

Hello.  Would anyone know of an easy method in trying to find unmatching
records in 2 different tables that have the same table structure?  A user
had been updating a different copy of the same .mdb file and now have to try
to find which records and how to merge the data in ...

    I have 3 tables Table_A, Table_B, Table_C. Each month I need to compare
tables A & B and copy the differences to table C and update 2 fields on table
C, one with current date, and a second field with a status either NEW or
REMOVED.

I have a query that is simply a combination of 3 other queries (joined by 1
common field in each).
Each of the 3 "sub queries" will execute fine, Individually....
But....that final query which simply combines them all will display an ODBC

  I am having some issues with the logic on the below SQL formula, and
wanted to see if one of you guru's could help me out ;).
  First off, I do know that reverse logic would work a little better here,
but for my own learning, I would like to see how this would work with normal ...

I want to make a date query.  I have multiple records that are the same
except with different dates.  How would I write a query that would display
the last date?  So in the query table there would be a single record with the
latest date.

Employees send in reports every month,
I want to create a query that will show whether or not they have sent the
report for that month!
When they send the report in the reports are distinguished by the the fields