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!" (-;
_____________________________________________


"Raymondo" <(E-Mail Removed)> wrote in message news:FBB3B745-93BE-4029-A6B6-(E-Mail Removed)...
|
| 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!

Of Course! Thanks again

"Stefan B Rusynko" wrote:

> SELECT COUNT(recordname) as RecordCount WHERE recordname<>'Ignore'
>
> --
>
> _____________________________________________
> SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
> "Warning - Using the F1 Key will not break anything!" (-;
> _____________________________________________
>
>
> "Raymondo" <(E-Mail Removed)> wrote in message news:FBB3B745-93BE-4029-A6B6-(E-Mail Removed)...
> |
> | 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!
>
>
>