> Hi,
>
> cant get to grips with this problem, need to select from dbo.booking_form
> all records that meet 2 statements. 1st allocated='completed' and 2nd
> account is not 'CASH' , i.e. all records that don't contain the word CASH in
> the field 'ACCOUNT'  Below is the beginning just don't know the syntax for
> NOT, have tried several option but to no avail.
>
> Pricing.Source = "SELECT *  FROM dbo.booking_form  WHERE allocated =
> 'COMPLETED' AND
>
> Thanks in advance.
>
> Simon

"Mike Brind" <paxton***@hotmail.com> wrote in message
news:1150655465.128335.231940@g10g2000cwb.googlegroups.com...
>
> Simon Gare wrote:
> > Hi,
> >
> > cant get to grips with this problem, need to select from
dbo.booking_form
> > all records that meet 2 statements. 1st allocated='completed' and 2nd
> > account is not 'CASH' , i.e. all records that don't contain the word
CASH in
> > the field 'ACCOUNT'  Below is the beginning just don't know the syntax
for
> > NOT, have tried several option but to no avail.
> >
> > Pricing.Source = "SELECT *  FROM dbo.booking_form  WHERE allocated =
> > 'COMPLETED' AND
> >
> > Thanks in advance.
> >
> > Simon
>
> Pricing.Source = "SELECT *  FROM dbo.booking_form  WHERE allocated =
>  'COMPLETED' AND accounts <> 'CASH'
>
> --
> Mike Brind
>