I have a query that is based on 5 tables. Each table has data about skills
employees have performed. However each table does not have information on
all of the employees. My problem is that the query only returns records for
employees that have data in all the tables. Anyone have ...

Access 2000
I've been trying to create a query that will show me the names of all
employees who have completed ALL training topics required by their job
titles.

I am searching for a way to remove all non-letters (i.e. slashes, periods,
spaces, commas, etc.) from words in Access running a query.
ex. remove periods, forward slashes, spaces, and tildas from
"32.HCGS.974 23/NW~MP" to get "32HCGS97423NWMP"

I am getting this error:
Compile error. in expression ".
while trying to save this query:
SELECT dupelist.*

I have 2 tables, let's call them Table1 and Table2.  Each have about 5
columns that are similar.  Project Number, Project Name, Project Manager, Due
Date, and Status.  Is there a way where I can have a query join those
together whenever I click on that query?  So I will have one ...

How do I take a field in access that contains both first and last names of
clients, and split them into two new fields, first name and last name?

OK I have a query that pulls records from a linked Oracle table. When pulling
these records they all look the same in the query even if they are different
in the table i.e.
Record 1: 5 3N 6W SESE

Hi.  I have a query that brings back Contacts (and contact info) for Contacts
that meet certain criteria.  I need to add Board Members into the mix.  Some
of the Contacts are Board Members.  I don't want to have Contacts/Board
Members on the list twice.  I made a union query of ...

I'd like to now how can I use a bitwise
I want the result of [Tb_COM].[ID_COM] & 1
                           [Tb_COM].[ID_COM] & 4    
Thanks

I have the following SQL query:
nsert into employees values ('SCHLESINGER',
'KATHY',
8,

All,
Do I gain any speed by assigning a query that is already created with the
proper sort order to the record source of a form vs. using the orderby on a
form (recordset)? I'm wondering if I should create multiple queries with the

Please see following.
pTemp is pointer to _Connection. _Connection Class of ADO
CComVariant vd;
hr = pTemp->Execute(bstrSql, &vd, adExecuteNoRecords, NULL);

I know this has been covered before, can't seem to make it work.  What's the
SQL?
I've got 2 tables:
   Table Criteria

I am getting this error:
Compile error. in expression ".
while trying to save this query:
SELECT dupelist.*

I have two tables.  One that has a list of suppliers and another that
lists a list of products.  In tbl_suppliers there are 5 rows and in
tbl_products there are 10 rows.  I now have created a query to show me
all the possible permutations of each supplier against each product (in