By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,961 Members | 2,492 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,961 IT Pros & Developers. It's quick & easy.

i need your support to Dcount two filed at sma row at the same time

P: 2
hello all

i need your support to Dcount two filed at sma row at the same time
both filed at the same table

Table name: Drivers
field 1 : licenceID
Second filed : supplier number

form text name : LicenseID
and Suppliernumber

both filed format are numbers
3 Weeks Ago #1
Share this Question
Share on Google+
2 Replies


P: 2
i'm trying below line but i revivedsyntax error

If DCount("*", "[Drivers]", "[LicenseID] =" & Me.LicenseID & "' AND [SupplierNumber] = '" & Me.SupplierNumber & "'") > 0 Then
3 Weeks Ago #2

NeoPa
Expert Mod 15k+
P: 31,492
Before we try to understand what your question means there are some obvious problems that may resolve any issue you're having.

Check your spelling, and that your code actually matches the names of any fields you're using.

I assume "Filed" should be "Field" and License & Licence are not interchangeable. Licence is a noun (an object) while license is a verb (an action). You should probably be using Licence consistently but clearly you aren't.

Please fix these basic problems then report back.
3 Weeks Ago #3

Post your reply

Sign in to post your reply or Sign up for a free account.