How do I get Access to recognise when a result is exactly divisible by a number.

I need to get VBA to produce a msgbox when the number of records in
the background query is exactly divisible by 5.

re: How do I get Access to recognise when a result is exactly divisible by a number.

On 3 Mar 2005 03:14:58 -0800, colin.mardell@btopenworld.com (Colin Mardell)
wrote:
[color=blue]
>I need to get VBA to produce a msgbox when the number of records in
>the background query is exactly divisible by 5.[/color]

Well, I don't know what "background query" means in this context, but to
determine if an integer is divisible by 5, as if <number> Mod 5 = 0. The
modulus (Mod) operator returns the remainder of an integer division.

re: How do I get Access to recognise when a result is exactly divisible by a number.

Many thanks for the help Steve that worked fine.