counting records

[Khalil Handal]

Thanks a lot, Tina

Khalil

hi Khalil.
James was right - i left a closing parens off of the expression. try

=Sum(IIf([CountryRegion] = "Jordanian", 1, 0))

if that doesn't work, then verify that you have a field named
CountryRegion
in the form's RecordSource, and verify that the field's data type is Text.

hth

Hi again
sorry to bother you Tina,
I ommitted the = sign at the begining and had no error but when I look at
the form I see: #Name?
can you still help.
Khalil

 

[Khalil]

Hi,
table name: tblEmployees
Query : qryNationality
Form: frmNationaliy

the query has two fields EmployeeID and CountryRegion fields.

When I open the form frmNationality have a text Box Text4 in whcih I want
to appear the number of record that have the nationality equal to
"Jordanian"
What VB Code I need?
Where is it going t be put? On the on open of the form or another place!

Khalil

 

[tina]

well, assuming that frmNationality is bound to qryNationality, you can put
an unbound textbox control in frmNationality's Footer section. in the
control's ControlSource property, enter the following, as

=Sum(IIf([CountryRegion] = "Jordanian", 1, 0)

hth

 

[James Arnold]

Hi Tina,
I tried but had the error:

expression containes invalid syntax
You ommited an oprand or operator, you entered an invalid character or
comma, or text without surrounding with cotation marks.

=Sum(IIf([CountryRegion] = "Jordanian", 1, 0)

I ommited the bracket ( after IIf :
=Sum(IIf[CountryRegion] = "Jordanian", 1, 0)

nad had an error asking that i must have brcakets for the IIf so added
another bracket at the end of statement but with no benefit.

Khalil

Looks like you missed a bracket at the end, try:

=Sum(IIf([CountryRegion] = "Jordanian", 1, 0))
[notice the double bracket to close]--------^

- James


---
avast! Antivirus: Outbound message clean.
Virus Database (VPS): 0531-3, 04/08/2005
Tested on: 05/08/2005 12:15:10
avast! - copyright (c) 1988-2005 ALWIL Software.
http://www.avast.com

 

[Khalil]

Hi Tina,
I tried but had the error:

expression containes invalid syntax
You ommited an oprand or operator, you entered an invalid character or
comma, or text without surrounding with cotation marks.

=Sum(IIf([CountryRegion] = "Jordanian", 1, 0)

I ommited the bracket ( after IIf :
=Sum(IIf[CountryRegion] = "Jordanian", 1, 0)

nad had an error asking that i must have brcakets for the IIf so added
another bracket at the end of statement but with no benefit.

Khalil

 

[Khalil]

Hi again
sorry to bother you Tina,
I ommitted the = sign at the begining and had no error but when I look at
the form I see: #Name?
can you still help.
Khalil

 

[tina]

hi Khalil.
James was right - i left a closing parens off of the expression. try

=Sum(IIf([CountryRegion] = "Jordanian", 1, 0))

if that doesn't work, then verify that you have a field named CountryRegion
in the form's RecordSource, and verify that the field's data type is Text.

hth

 

[tina]

you're welcome

Thanks a lot, Tina

Khalil

hi Khalil.
James was right - i left a closing parens off of the expression. try

=Sum(IIf([CountryRegion] = "Jordanian", 1, 0))

if that doesn't work, then verify that you have a field named
CountryRegion
in the form's RecordSource, and verify that the field's data type is Text.

hth

Hi again
sorry to bother you Tina,
I ommitted the = sign at the begining and had no error but when I look at
the form I see: #Name?
can you still help.
Khalil

 

[tina]

after seeing your separate post re this question, i reviewed this entire
thread. i noticed your remarks following:

I ommitted the = sign at the begining and had no error but when I look at

the form I see: #Name?

are you still leaving off the equal (=) sign? if so, DON'T. you need to
enter the *complete* expression, as i gave it to you earlier in the thread:

=Sum(IIf([CountryRegion] = "Jordanian", 1, 0))

as long as there is a field in the form's underlying table that's named
CountryRegion, the expression should work. there should be no need to use a
DCount() function.

hth

you're welcome

Thanks a lot, Tina

Khalil

hi Khalil.
James was right - i left a closing parens off of the expression. try

=Sum(IIf([CountryRegion] = "Jordanian", 1, 0))

if that doesn't work, then verify that you have a field named
CountryRegion
in the form's RecordSource, and verify that the field's data type is Text.

hth


Hi again
sorry to bother you Tina,
I ommitted the = sign at the begining and had no error but when I

look

at