PMC
Mon Dec 29 07:18:01 CST 2003
Thanks Mike, that worked.
Peter
"MD WebsUnlimited.com" <none@none.com> schreef in bericht
news:etZA4YbzDHA.1996@TK2MSFTNGP12.phx.gbl...
> Hi Peter,
>
> You can use SQL and the aggregate verb count.
>
> SELECT Count([SKU]) AS [JBP-04 Purchased]
> FROM product_orders
> WHERE (((product_orders.SKU)="JBP-04"));
>
>
> --
> Mike -- FrontPage MVP '97-'02
>
http://www.websunlimited.com
> FrontPage Add-ins Since '97 2003 / 2002 / 2000 Compatible
> --------------------------------------------------------------------------
--
> --------------------
> If you think I'm doing a good job, let MS know at mvpga@microsoft.com
>
> "PMC" <pmuldernospam@bigfoot.com> wrote in message
> news:OZPV6sWzDHA.1412@TK2MSFTNGP11.phx.gbl...
> > Hi,
> >
> > Probably answered many times, but here it is.
> > I have an simple Access database. I would like to display the number of
> > records found in the database and display it on the result page.
> > So, a text that says: "Search results xx records"
> > Can I do that with a separate results table and a custom SOL, or do I
need
> > to study more in Jim Buyens excellent books?
> >
> > Your help is appreciated.
> >
> > Peter Mulder (NL)
> >
> >
> > ---------------------------------------------------------------------
> > "Are you still wasting your time with spam?...
> > There is a solution!"
> >
> > Protected by GIANT Company's Spam Inspector
> > The most powerful anti-spam software available.
> >
http://mail.spaminspector.com
> >
> >
> >
>
>