Access 2000 expression

M

Marcello

I am looking for a way to tell an if statment to disregaurd a number from a
table but sum and and divide the rest taking out the disrequrded number from
the count of the id any ideas?
 
D

David Lloyd

I am not sure I completely understand what it is you are trying to do, but
you may want to investigate the DSum and DCount functions that would allow
you to choose the records (probably through a query which removes the
records with the unwanted number) that will be summed or counted,
respectively.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


I am looking for a way to tell an if statment to disregaurd a number from a
table but sum and and divide the rest taking out the disrequrded number from
the count of the id any ideas?
 
Top