Hi.  I have a table column with entries like the following
TO-123
XO-234
TO-345

I have a database that imports monthly files generated out of a medical
system for specific services on clients.  The first service for this patient
is not something I need to create an invoice/payment from, but subsequent
services for that same patient I do.  My first problem is ...

I have a query as shown below that is getting the wrong match.  The Lead ID
from Combine (which is a query itself) is getting a wrong match from the Lead
ID from Join LeadSP (which is a table).  And the wrong answer is consistent,
so that if Combine.[Lead ID] is a 3 then [Join ...

One Table, One Query - Want to delete multiple lines from table with criteria
from query:
Table Fields:  Serial Number, Date Shipped, Qty Shipped, Qty Avail
                    1234               1/1/2006         100             400

If criteria is null return all
That all I want to do but after trying several ways I can't get any to work.
Here is what I have tried so far for the criteria
Like [forms]![search]![name] & "*"

I'm trying to produce a list box with a most recently used list at the
top. I've got a working query to extract the 5 most recent, and another
to extract the complete list, but when I try the two together, the
ORDER BY from the original list applies to the entire query, not just

When checking field data for a match in an update query, I need to ignore the
padding (0s).
example: T1  Field1(Primar Key)              T2 Field1 (Primary Key)
                  362957                                   00362957

I have two Tables; table2005 and table2006, and want to find all entries in
table2006 which do not occur in table2005. The SQL statement
SELECT DISTINCT *
FROM table2006 LEFT JOIN table2005

I need to create a query. I have 3 columns. "Match column", "Date
column", and "field 1" which counts from 1 to 1000. The numbers in the
"match column" are jumbled around. I need a query that looks through
the match column and matches the number it finds with the field 1

I know this is going to be a simple solution but I can't figure it out.... I
want this query to automatically run this equation and not have to enter the
date each time.
I want to query a table that displays all records 3 months prior to the

I have a query called "qryContactsList1", which has the SQL:
SELECT CDB.*
FROM CDB
WHERE (((CDB.Company) Like '*richland*') AND ((CDB.listdisplay)=True))

Hi - I am writing a passthrough query with a nested query in Access and am
trying to create an outer join. However, the outer join is not working as
expected and I am loosing a couple of records. MY SQL syntax is:
select

My current job is to convert a ADP into a MDB.
Because of storing the queries of ADP in SQL-Server, the conversion of
queries, witch contains 'full outer join' between to tables, to MDB seems not
work.

I am running a series of queries that use a date range ([Beg Date] and [End
Date]).
I want to only enter the dates once instead of reentering for each query. Is
there a simple way to enter the date only once?

I am 99% there in implementing the code on
www.mvps.org/access/datetime/date0012.htm but get a 'data type mismatch in
criteria expression' when I specify holiday dates.  This is the query I have
built in the query design grid: