I just did a dcount and this is what I did and it works. Maybe you are missing the quotes on the last string
="Records on the report is " & " " & DCount("*","In CurrentVacEmplTable Not in TMA")
Jim Wagner
On Friday, October 25, 2013 3:45 PM, Graham Mandeno <graham@mandeno.com> wrote:
Hi Arthur
/Rental/ is a literal text value, so it must be enclosed in quotes like this:
=DCount("[UnitID]","tblUnit","[ClassificationType] = 'Rental' ")
Without the quotes, SQL would look unsuccessfully for a field named "Rental" to match with the field named ClassificationType"
Best wishes,
Graham
Graham
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of dbalorenzini@yahoo.com
Sent: Saturday, 26 October 2013 11:15
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Dcount with string
Sent: Saturday, 26 October 2013 11:15
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Dcount with string
=DCount("[UnitID]","tblUnit","[ClassificationType] = Rental")
But I keep getting an error. I think it has to do with =Rental" but not sure how to correct it. 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 (3) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar