Maybe its something with Access 2013 because some are displaying the 0 and some are not.
With Warm Regards,
Arthur D. Lorenzini
IT System Manager
Cheyenne River Housing Authority
Wk.(605)964-4265 Ext. 130
Fax (605)964-1070
alorenzini@crhanetwork.org
"Only those who will risk going too far can possibly find out how far one can go."
________________________________
From: "wrmosca@comcast.net" <wrmosca@comcast.net>
To: MS_Access_Professionals@yahoogroups.com
Sent: Tuesday, September 3, 2013 3:36 PM
Subject: [MS_AccessPros] RE: Displaying a zero in an expression
Art
DCount returns zero if no records match the criteria. Are you not getting that now?
Regards, Bill Mosca, Founder - MS_Access_Professionals http://www.thatlldoit.com/ Microsoft Office Access MVP https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E My nothing-to-do-with-Access blog http://wrmosca.wordpress.com/
--- In mailto:MS_Access_Professionals%40yahoogroups.com, <mailto:ms_access_professionals%40yahoogroups.com> wrote:
I have the following expression in a unbound field called txtHistoryRecCount: =DCount("*","[WeatherProofing]","UnitID = " & [Forms]![UnitDetails]![UnitID]) If the count returned is 0 then I would like to display a 0 in the field. Any ideas? Thank you, Arthur Lorenzini Sioux Falls, SD
[Non-text portions of this message have been removed]
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (3) |
Tidak ada komentar:
Posting Komentar