using IsOdd in a unbound field on a report?

[_Bigred]

I'm trying to make this work as the control source for a "Team"
unbound box in a report

=IsOdd([Week1],"A","B")

The [Week1] is another unbound field that is based on =Format
([Start1],"ww")

so example

[Start1]=3/1/09 then [Week1]=10 and since it's a even number "B"
if a odd number "A".

TIA,
_Bigred

 

[Allen Browne]

I don't recognise IsOdd() as a built-in function, so try:
= IIf([Week1] Mod 2 = 0, "something", "other")

Mod gives the remainder after division.
Dividing by 2 gives 0 (for even numbers) or 1 (for odd numbers.)

 

[_Bigred]

I don't recognise IsOdd() as a built-in function, so try:
    = IIf([Week1] Mod 2 = 0, "something", "other")

Mod gives the remainder after division.
Dividing by 2 gives 0 (for even numbers) or 1 (for odd numbers.)

--
Allen Browne - Microsoft MVP.  Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

I'm trying to make this work as the control source for a "Team"
unbound box in a report

=IsOdd([Week1],"A","B")

The [Week1] is another unbound field that is based on =Format
([Start1],"ww")

so example

[Start1]=3/1/09 then [Week1]=10      and since it's a even number "B"
if a odd number "A".

TIA,
_Bigred- Hide quoted text -

- Show quoted text -

worked like a charm Thank You very much