BAQ: Get row count for table

I just added the company table to the BAQ.
The count works now.



--- In vantage@yahoogroups.com, "cooner_55421" <cooner_55421@...> wrote:
>
> E9 9.04.506
> I got thata error too.
> Never had any trouble with COUNT on other tables.
>
> Calc field zCount
> Integer
> ->>,>>>,>>9
> Count( InvcHead.InvoiceNum )
>
> --- In vantage@yahoogroups.com, Joe Rojas <jrojas@> wrote:
> >
> > Hello,
> >
> >
> >
> > I was trying to get a row count for InvcHead to compare to my
> > replication server and I can't figure out what I'm doing wrong.
> >
> > I created a BAQ with just InvcHead and the added a calculated field that
> > has the formula COUNT(InvcHead.InvoiceNum).
> >
> > When I check syntax, I get " ** Unable to understand after -- "for".
> > (247)"
> >
> >
> >
> > Is it possible to get a row count from a BAQ?
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > Joe Rojas | Director of Information Technology | Mats Inc
> > dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
> > jrojas@ | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring
> >
> >
> > This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
Hello,



I was trying to get a row count for InvcHead to compare to my
replication server and I can't figure out what I'm doing wrong.

I created a BAQ with just InvcHead and the added a calculated field that
has the formula COUNT(InvcHead.InvoiceNum).

When I check syntax, I get " ** Unable to understand after -- "for".
(247)"



Is it possible to get a row count from a BAQ?










Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring


This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.


[Non-text portions of this message have been removed]