Access 2000 expression

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DELETE FROM a table WHERE... 1
Expression in query 2
Expression in query 2
Extract first four letters from string.... 9
Divide Currency Number 1
Extra digit in Table 3
Percentage question 8
Excel Sumproduct 0

Back
Top