Another Stumper

  • Thread starter Thread starter JimS
  • Start date Start date
J

JimS

You'll probably get this one right away...

I have a table with 66000 rows. 57000 rows have a Proj# column that is of
the form "C00000". Three rows have spurious stuff in the Proj# column like
"Total" and "Report Run...." 9,000 or so rows have a null in that column.

I ran a query that couldn't be simpler:

DELETE AllMatreqIssues.[PROJ #]
FROM AllMatreqIssues
WHERE (((AllMatreqIssues.[PROJ #]) Not Like "C*"));

It only deletes the three rows with spurious characters. It does not delet
the rows that are null. Why?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Simple SUMIF, I think... 7
Too hard to do? 1
Maybe too hard to do? 2
excel 07 Dynamic copy certain cells if criteria is met onto next s 1
how to set up group header as column header in a report? 1
Accommodate Variable Number of Columns 2
Keep Column Information Together--Possible? 3
Hyperlink function fails when using variable row number 5

Back
Top