"ae" wrote:

> 7000
> i counted them, do you think access is limited?
>
> "Adam Machanic" wrote:
>
> > How many rows does this return:
> >
> >
> > SELECT *
> > FROM [table store]
> > WHERE discount = 0
> >
> >
> > --
> > Adam Machanic
> > SQL Server MVP
> > http://www.sqljunkies.com/weblog/amachanic
> > --
> >
> >
> > "ae" <ae@discussions.microsoft.com> wrote in message
> > news:28EF0C65-9550-4A29-B3FC-B467987AF9D2@microsoft.com...
> > > I can't.
> > >
> > > It's in Microsoft Access, and I tried everything I can think of and what
> > it
> > > does it updates it to the field at the end of the equal such as the field
> > > quantity becomes quantity and not discount
> > >
> > > i.e.
> > >
> > > update table store
> > > set quantity = quantity - discount
> > >
> > > here it sets it to quanity and does not follow up with the subtraction.
> > > sometimes it works and sometimes it doesn't. anybody?
> > >
> > > "Adam Machanic" wrote:
> > >
> > > > Can you post DDL and sample data to reproduce whatever problem you're
> > > > having? That syntax is valid.
> > > >
> > > > http://www.aspfaq.com/etiquette.asp?id=5006
> > > >
> > > > --
> > > > Adam Machanic
> > > > SQL Server MVP
> > > > http://www.sqljunkies.com/weblog/amachanic
> > > > --
> > > >
> > > >
> > > > "ae" <ae@discussions.microsoft.com> wrote in message
> > > > news:EFD429C4-A3E1-4540-AEEA-C96BD8E69B5F@microsoft.com...
> > > > > Can someone show me how to get the proper syntax working on this? It
> > > > doesn't
> > > > > update correctly, and I'm thinking it the Commision updates to
> > > > PaymentAmount,
> > > > > but it's real erractic and can't troubleshoot. TIA
> > > > >
> > > > > UPDATE [Revenue Processing]
> > > > > SET [Revenue Processing].[Commission] = [PAYMENTAMOUNT]-[Commission]
> > > > >
> > > >
> > > >
> > > >
> >
> >