473,472 Members | 2,124 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

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

2 New Member
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
Sep 22 '19 #1
2 903
mahmoudhegazy
2 New Member
i'm trying below line but i revivedsyntax error

If DCount("*", "[Drivers]", "[LicenseID] =" & Me.LicenseID & "' AND [SupplierNumber] = '" & Me.SupplierNumber & "'") > 0 Then
Sep 22 '19 #2
NeoPa
32,556 Recognized Expert Moderator MVP
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.
Sep 22 '19 #3

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

Similar topics

0
by: Prasad Patil | last post by:
Hi I am working on ASP.Net / C# web application, i need to fine the time taken to complete the request for a page in web browser. e.g. http://www.anyurl.com/default.aspx I need to find the...
3
by: Loďc | last post by:
Hello, I have created a simple webcontrol named MyControl tahat contains one single property. The property name is Columns , his type is ColumnCollection ( inherits from CollectionBase). this...
3
by: ButtMonkey | last post by:
Please help! How do I extract mm/dd/yyyy hh:nn from a timestamp field located in an MS SQL 2000 database table? I can do this in MS Access where , for example only, I can convert 56323938 to...
1
by: דורון חסידים | last post by:
Hellow, I am a techer, and trying to install a copy of visual studio .net that received from my school. I insert CD1, klick setup, klick the only option available siprerequites, and than there...
0
by: animatix | last post by:
this is how far i have gotten. <pathtoslides>www.animatix.us/slides/multi/VAR PIC</pathtoslides> <pathtoproj> pop up path to fullproj, syntax flash to trigger embedded javascript to load new...
2
by: Alfred | last post by:
I need a calendar + time picker tool that is: * public domain * non-AJAX (at this time) * javascript * works in IE 6 and Firefox 1.5 and up * div-based * uses CSS too * permits not just...
7
by: Jankie | last post by:
I have an application with 2 pages form . If there is an error,I set the action to the same page to display the errors .If no errors,I set the action to page2.php(that both processes and echoes a...
5
by: Charles May | last post by:
Anyone have a simple concept for the best way to store timeclock information in a database. I currently have my table set up like this with a typical daily entry. tcID empID Type ...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
1
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
muto222
php
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.