[AccessD] Count multiple columns

Even if it's a text field, just test for IsNumeric and use a sum.  Too much
work otherwise.

Charlotte

On Tue, Dec 4, 2012 at 8:49 AM, Gustav Brock <gustav at cactus.dk> wrote:

> Hi Lembit
>
> So you are still with us? Great!
> I hope all is well and your video lab is running smoothly. Not to mention
> your beer tab!
>
> /gustav
>
>
> -----Oprindelig meddelelse-----
> Fra: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] På vegne af Lembit Soobik
> Sendt: 4. december 2012 15:20
> Til: Access Developers discussion and problem solving
> Emne: Re: [AccessD] Count multiple columns
>
> Hi John,
> won' a sum give you the count if all to be counted are 1s?
>
> Lembit
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>