Database query 2

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I use the query - SELECT COUNT(*) To count the number of records in our
database. I would like to filter this to ignore records where, for
instance,recordname = 'Ignore' therefore the DRW will count all the oteher
records except those where recordname = ignore.

Can you give me the code for this? Many thanks. You are all a terrific help!
 
SELECT COUNT(recordname) as RecordCount WHERE recordname<>'Ignore'

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


|
| I use the query - SELECT COUNT(*) To count the number of records in our
| database. I would like to filter this to ignore records where, for
| instance,recordname = 'Ignore' therefore the DRW will count all the oteher
| records except those where recordname = ignore.
|
| Can you give me the code for this? Many thanks. You are all a terrific help!
 
Back
Top