I have a append query
INSERT INTO style ( Job, [Order], Qty, c, Item, [Size], Avl, Type, Due, Age,
[Req'd], [Curr Routing], Sts, Days, Field17, Field18, Field19, [Left],
Field21, Field22, Field23, Ordered, Field25, Style )

I'd like to remove records where the status is either "D", "K", "W" or "C".  
The "status" field contains a single letter.
Thanks in advance for your help,
Ellen

I have a union query that unions two other queries. I checked the output of
the other queries and my memo column is intact. After the union query my memo
column is truncated. How do I fix this? Hope someone can offer a solution as
my users are complaining their data is missing.

Need help with the criteria portion of a Dlookup.
This dlookup is in the "Field" portion of a query.
The query is a single table query pulling from the orders table.
There are reasons I can't pull other tables into this query.

Can someone help me to figure what is wrong with my syntax?
Thanks...
How to open with this ( " ) and sometimes with this ( ' )?
SQLString = "insert into WIPRawDetails (JobNumber, PartNumber, W_KittedQty) "

Hi expert
I got this ""Data type mismatch in expression" error message while running my
queries.
SELECT qrymaxallca1.NE, qrymaxallca1.Date, Sum([qrymaxallca1]!

hi,is it possible to run another search for records without closing the 1st
search in query?hope you guys understand what i m trying to say,thanks

I'm trying to build a query that will show records where ANY of three
different yes/no values have been selected. Any suggestions?

I am using Access 2002.
I have a project that uses the "Find Duplicates" query to display duplicate
records in a table, using "Part Number" as the field that determines whether
the record is a duplicate. I use the trick of creating a copy of that table

I have a Union Query that combines two tables with identical
fields/data types. The problem I am having is trying to get the
resulting recordset to display the names of the organizations instead
of the OrgID value. The recordsets that display when running the

I have a table, tblScores, containing Student_id and score_date and another
table, tblAttendance, containing student_id and att_date.  Is there a way I
can select all of the rows in tblScores which have no match in tblAttendance
on BOTH student_id and date?  (score_date = ...

I am a self taught Access user and have created a Licence and Permit
Database.  For Report I require a full date ie 12 January 2007 however, I
also require to measure time with it how can I achieve this?  Your help would
be much appreciated. Thanks

I am trying to put a criteria into a xtab
query via the Combo on a  form.
I use the builder to get
"Forms![FrmPopupCustProd]![Combo]0"

I have a date field that is part of an aging report which i would like the
text to turn red if the date is 90 days from current date.Is this done
through conditional format and how would it be done.

I have a table where the users would like to use the ampersand and “ ‘ “.  
For example; in a field named "Company", they would like to be able to use
company names like "Joe & Max's garage".  Using the replace command, I can
work with the " ' ", but the "&" is causing real ...