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 MS_Access_Professionals@yahoogroups.com, <ms_access_professionals@yahoogroups.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
__._,_.___
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar