IsNull[Field] Problem

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

Guest

Hello.
I am using Access 2000 and I am having trouble with an IsNull control box.
Could you please tell me what is wrong with this picture?

=DCount("[InitiateDate]","tbl_Main","[Office] = 'LO' and [TrackType]='CWQT'
and (IsNull([TransCompleteD])")

I want to count all Initiate Dates in table tbl_Main that have "LO" as the
office and TrackType of "CWQT" and have a null field for the TransferComplete
field.
If I take out the TransCompleteD part the code works fine.
This is in a report.

Thanks.
Iram/mcp
 
Hello.
I am using Access 2000 and I am having trouble with an IsNull control box.
Could you please tell me what is wrong with this picture?

=DCount("[InitiateDate]","tbl_Main","[Office] = 'LO' and [TrackType]='CWQT'
and (IsNull([TransCompleteD])")

I want to count all Initiate Dates in table tbl_Main that have "LO" as the
office and TrackType of "CWQT" and have a null field for the TransferComplete
field.
If I take out the TransCompleteD part the code works fine.
This is in a report.

Thanks.
Iram/mcp
Click to expand...

Your parentheses are incorrect.
You have 3 open parentheses and 2 closing.

Try:
=DCount("[InitiateDate]","tbl_Main","[Office] = 'LO' and
[TrackType]='CWQT' and IsNull([TransCompleteD])")

If that still doesn't work try:

=DCount("[InitiateDate]","tbl_Main","[Office] = 'LO' and
[TrackType]='CWQT' and ([TransCompleteD] Is Null)")
 
Thanks Fredge. It worked beautiful with the first code you supplied. Could I
put a name of a report or query where the table name is i.e. tbl_Main?
Would it work or does it have to be a table name?

Thanks. You are the man.
Iram



fredg said:
Hello.
I am using Access 2000 and I am having trouble with an IsNull control box.
Could you please tell me what is wrong with this picture?

=DCount("[InitiateDate]","tbl_Main","[Office] = 'LO' and [TrackType]='CWQT'
and (IsNull([TransCompleteD])")

I want to count all Initiate Dates in table tbl_Main that have "LO" as the
office and TrackType of "CWQT" and have a null field for the TransferComplete
field.
If I take out the TransCompleteD part the code works fine.
This is in a report.

Thanks.
Iram/mcp
Click to expand...

Your parentheses are incorrect.
You have 3 open parentheses and 2 closing.

Try:
=DCount("[InitiateDate]","tbl_Main","[Office] = 'LO' and
[TrackType]='CWQT' and IsNull([TransCompleteD])")

If that still doesn't work try:

=DCount("[InitiateDate]","tbl_Main","[Office] = 'LO' and
[TrackType]='CWQT' and ([TransCompleteD] Is Null)")
Click to expand...
 
Thanks Fredge. It worked beautiful with the first code you supplied. Could I
put a name of a report or query where the table name is i.e. tbl_Main?
Would it work or does it have to be a table name?

Thanks. You are the man.
Iram

fredg said:
Hello.
I am using Access 2000 and I am having trouble with an IsNull control box.
Could you please tell me what is wrong with this picture?

=DCount("[InitiateDate]","tbl_Main","[Office] = 'LO' and [TrackType]='CWQT'
and (IsNull([TransCompleteD])")

I want to count all Initiate Dates in table tbl_Main that have "LO" as the
office and TrackType of "CWQT" and have a null field for the TransferComplete
field.
If I take out the TransCompleteD part the code works fine.
This is in a report.

Thanks.
Iram/mcp
Click to expand...

Your parentheses are incorrect.
You have 3 open parentheses and 2 closing.

Try:
=DCount("[InitiateDate]","tbl_Main","[Office] = 'LO' and
[TrackType]='CWQT' and IsNull([TransCompleteD])")

If that still doesn't work try:

=DCount("[InitiateDate]","tbl_Main","[Office] = 'LO' and
[TrackType]='CWQT' and ([TransCompleteD] Is Null)")
Click to expand...
Click to expand...

You can use a query or a table:

=DCount("*","QueryName","[Office] = 'LO' and
[TrackType]='CWQT' and IsNull([TransCompleteD])")
will work.

Reports do not actually contain data, they display it, so it will not
work.
 
Back
Top