I have some sku data that is all grouped together with sku and sku
description. I want to seperate it out and account for the Discontinued data
as well which is designated with a (D), (D1), (D2), or (DD) symbol in the
text.

So I have the below pass through query of an oracle database that runs in
about 3 minutes and contains over 1 million records.  I am using a regular
make table query in access to try create the records in my local database but
I keep getting the ORA-01013 error.  I have ODBC ...

I have a query with 3 fields:
description
count
y1

To anyone that can offer some assistance,
I am looking to find a more efficient way of processing the following query...
SELECT EMP_NAMES_CHAS.[Associate Director], EMP_NAMES_CHAS.Supervisor,
EMP_NAMES_CHAS.Name, EMP_NAMES_CHAS.EMP_ID, nz((Select Count(*) from

anyone know if there is a way using sql to return min effective date and max
end date for every change in a value in another column.
for example
effective_date    end_date     indicator

under the Tools>Options>Edit/Find. I have all under Confirm unchecked. and I
also have the Warnings in the VBA Editor to false. Docmd.setwarnings(false).
but when i run my code and I have some make table queries the warnings still
pop up. I have access 2003.

I have the following Union query set up as a pass through query:
SELECT Host, "Service_Tier" AS Missing FROM dbo.table WHERE service_tier Is
Null AND created In (SELECT Max([created]) FROM dbo.table)
Union SELECT Host, "capacity_type" FROM dbo.table WHERE capacity_type Is Null

I need to get a query to pull from my database any date 6 months or less into
the future (ex. The query would pull up any orders which have a date of
10/2/08 or sooner).  Any help would be greatly appreciated.  Thanks!!

I am new to access so you will have to bear with me. I need to adjust a query
that I have. I am editing an exsiting database that was created to control
company tools. I added a proprietary column in order to see if the tool is
personal or company. I had the query to state only ...

I have the following table:
Grade  ResourceCode  Name     2008  2009  20010
Engr1  Codex              Jones    $1.11 $2.22  $3.33
Engr4  Codey              Smith    $1.12 $2.23  $3.34

My data as follows;
Asset_Name    Asset_Type     Property     Generated_At                   Value
Widget1           Press           CoreTemp    1/1/2008 08:05:00AM        123.1
Widget1           Press           CoreTemp    1/1/2008 08:06:35AM        154.0

I am trying to run the most simple of update queries to update one
field in a table. Here is my SQL
UPDATE 22_LifeCoRoll INNER JOIN (CASH_CASH_SUMMARY INNER JOIN
[22_LifeCoRoll - Current] ON CASH_CASH_SUMMARY.CASH_CNTL_ID =

Eg data
Live month    Current month      next month      Percentage
Aug 06                   5                     1                   -80%
Sep 06                   1

New to access so please bear with me.
I have a table used for the pricing of window blinds, to obtain a price we
need the width x drop. so i created a table with fields named drop, 610,914,
1219,1524 etc etc.

I have applied the condition below graphically (shown i SQL-statement)
HAVING (((Sesam.TRN_START_DATE)>#1/31/2008#)
It does not work. I understand that you need to do some kind of conversion,
but what and how? There are several different functions in the access built