473,397 Members | 1,972 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,397 software developers and data experts.

Dcount field

36
Hi People

I need to count different products in a report textbox or put the expression in a query for example:

=Dcount([productsID]).

¿How i can't this?
Mar 26 '08 #1
2 1158
PianoMan64
374 Expert 256MB
Hi People

I need to count different products in a report textbox or put the expression in a query for example:

=Dcount([productsID]).

¿How i can't this?
If you look in Help file in Access there is an example of how to use DCount() and all it's parameters.
Mar 29 '08 #2
ElTipo
36
Thanks! Sorry I can't explain clearly.

Here is the real example issue:

I have a table named [products]. I need to count only one in list.

[ID] [ProdName] [price]
1 paper $1.00
1 paper $1.00
2 pencil $2.00

=Dcount([tblproducts],[ID], [ProdNamed]="Papaer") - This is correct? I need to count in the text box report only the paper product. But no work the Dcount to diference count.

¿How?

Thanks for your time. Excuses for my english.
Apr 1 '08 #3

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

Similar topics

7
by: jdph40 | last post by:
I posted this problem previously and received excellent help from Wayne Morgan. However, I still have an unanswered question. My form (frmVacationWeeks) is opened from the OnClick event of a...
1
by: Megan | last post by:
Hi Everybody- I've been reading some of the posts about DCOUNT, and I haven't yet found an answer; so, I'm posting this question. I have a report that I'm trying to use DCOUNT on to compute...
6
by: Mike Conklin | last post by:
This one really has me going. Probably something silly. I'm using dcount for a report to determine the number of different types of tests proctored in a semester. My report is based on a...
11
by: N J | last post by:
Hi, I was given this code by a member on here but I am still stuck...I want to be able to see if there is other orders in the table based on the email address. But I keep getting #Name? what does...
7
by: kaosyeti | last post by:
hey.. i have a control in a report that needs to count the records from a table that match the parameters that the user selects when creating the report. the report is created with...
2
by: Kaspa | last post by:
Hello I am trying to create dcount field but is not working I have tried every way possible and I can't get it to work. here is my code: =Dcount("","qryTotalscratched"," in (6,7,8,9) and ...
7
by: Michael R | last post by:
Good afternoon. I'm stucked in composing the syntax for DCount expression in a select query. The query qryCustomers has CustomerID field, the DCount function uses tblLoans with LoanDate and Id fields...
4
by: ashitaka65 | last post by:
hey, i'm writting a database and in my report am tryin to have dcounts count some diffrent fields i would like to know if there is a way to have your dcount skip or not count a field or if there is...
5
by: Wayne | last post by:
I'm using the following code to check for duplicate names when I exit the field "MemberName" on a form: If DCount("*", "tblMembers", " = '" & Me! & "'") <0 Then DoCmd.CancelEvent MsgBox "This...
16
by: zeusspandex | last post by:
Hello everyone I have been useing Access for a while now and have attempted useing DCount a number of times but with varying results. I am currently trying to have a field in a form that will...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
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
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
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
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

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.