Hi all,
I have a form where I want to show three numbers:
- Competitors who are member (they have Memnr) =Textfield 1
- The ones without Memnr =Textfield 2
- Total of competitors =Textfield 3
In Access2003 this os working fine. in 2007 the second field is displying
"Name?"
Textfield 1 has property :
Name = Teller
=(Aantal([MEMNR]=Onwaar)) Translated: = Number([MEMNR]=FALSE))
Textfield 2:
Name = Tekst68
=[RecCnt]-[Teller]
Textfield 3:
Name = TotaalTeller
=Abs(Aantal([MEMNR] Is Not Null Or ""))
Who can explain why this is not working in 2007? And help me get it working.. ;-)
Thanks
I have a form where I want to show three numbers:
- Competitors who are member (they have Memnr) =Textfield 1
- The ones without Memnr =Textfield 2
- Total of competitors =Textfield 3
In Access2003 this os working fine. in 2007 the second field is displying
"Name?"
Textfield 1 has property :
Name = Teller
=(Aantal([MEMNR]=Onwaar)) Translated: = Number([MEMNR]=FALSE))
Textfield 2:
Name = Tekst68
=[RecCnt]-[Teller]
Textfield 3:
Name = TotaalTeller
=Abs(Aantal([MEMNR] Is Not Null Or ""))
Who can explain why this is not working in 2007? And help me get it working.. ;-)
Thanks