janith
CPA
- Local time
- Today, 12:36
- Joined
- Apr 11, 2012
- Messages
- 65
Hi,
Hope someone can help me with this problem. I've a DCount formula on a control source its purpose is to count number of records for a particular user logged on that system and the status field showing as "TBW" for them.
here's the formula:
=DCOUNT ("Status", "tblmain", "Citrix Ids = "&' [Forms]![qrymaintable]![npname]' And "[status] = 'TBW'")
for some reason its counting the total records in the table 'tblmain' and not based on the creteria status = 'TBW'
fyi...I'm using the =fosusername() to capture user ids which is stored on the text control 'npname'.
status is my field name , tblmain is the table name , citrix ids is the field name which has a list of ids
Any help to resolve this issue is highly appreciated....
thank you
Hope someone can help me with this problem. I've a DCount formula on a control source its purpose is to count number of records for a particular user logged on that system and the status field showing as "TBW" for them.
here's the formula:
=DCOUNT ("Status", "tblmain", "Citrix Ids = "&' [Forms]![qrymaintable]![npname]' And "[status] = 'TBW'")
for some reason its counting the total records in the table 'tblmain' and not based on the creteria status = 'TBW'
fyi...I'm using the =fosusername() to capture user ids which is stored on the text control 'npname'.
status is my field name , tblmain is the table name , citrix ids is the field name which has a list of ids
Any help to resolve this issue is highly appreciated....
thank you