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("[callid]","qryTotalscratched","[resultid] in (6,7,8,9) and
[calldate] between #01/01/2001# and " & [calldate])
I also tried:
=Dcount("[callid]","qryTotalscratched","[resultid] in (6,7,8,9) and
[calldate] <= " & [calldate] 2 1775
> =Dcount("[callid]","qryTotalscratched","[resultid] in (6,7,8,9) and [calldate] between #01/01/2001# and " & [calldate])
I also tried:
=Dcount("[callid]","qryTotalscratched","[resultid] in (6,7,8,9) and [calldate] <= " & [calldate]
I suppose that if you remove the date-part filter from every dcount instruction,
it works ok, not?
It that is your case, check the [calldate] control date format: it could
be different from what you aspect.
--
PBsoft di Gabriele Bertolucci www.pbsoft.it
skype: pbsoftsolution
I don't understand your reply. but this is the end result that I am
looking for in my report:
3/1/06 Calls: 10 contacts: 3 Scratched: 1 Cummulative: 1
3/2/06 Calls: 15 contacts: 4 Scratched:2 Cummulative: 3
Cummulative is the tricky part, and I am trying to do a dcount on that
field. Thanks for any help in advance.
Gabriele Bertolucci wrote: =Dcount("[callid]","qryTotalscratched","[resultid] in (6,7,8,9) and [calldate] between #01/01/2001# and " & [calldate])
I also tried:
=Dcount("[callid]","qryTotalscratched","[resultid] in (6,7,8,9) and [calldate] <= " & [calldate]
I suppose that if you remove the date-part filter from every dcount instruction, it works ok, not? It that is your case, check the [calldate] control date format: it could be different from what you aspect.
-- PBsoft di Gabriele Bertolucci www.pbsoft.it skype: pbsoftsolution This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Dan Leeder |
last post by:
stroccur = DCount("", "empnotes", " = " & Chr(34) &
Me.Rpt_Card_Type & Chr(34) & " And = " & Me.SSN & " And #" &
& "# > " & DateSerial(Year(Me.datetime) - 1,
Month(Me.datetime),...
|
by: Alec |
last post by:
Hi All,
I am trying to use the DCount and DLookup functions with the WHERE
expression set to: "DateToDo <= #" & Date & "#" to display all items
with their DateToDo set to the current date or...
|
by: Alec |
last post by:
Hi All,
I've asked about this before, and people were very helpful, and I have
used the advise quite a bit, however I have run into a spot of
trouble...
I have a form that the users uses to...
|
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...
|
by: jstaggs39 |
last post by:
I want to create a Dcount and an If...Then...Else statement to count
the number of records in a table based on the date that is entered to
run the form. The If....Else statment comes in because if...
|
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...
|
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
...
|
by: psuaudi |
last post by:
I am trying to use the following code, but I think there is an error in my syntax:
Count = DCount("", "Change Dates", " = '" & !! & "' AND CVDate(Int( #" & & "# )) = #" & (Date) & "#")
I...
|
by: ringer |
last post by:
I am trying to add a functionality into a db I use for my checkbook that will help me plan for and save money for future large expenses. Into a table called tblFutureTransactions I want to enter...
|
by: DolphinDB |
last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation.
Take...
|
by: DolphinDB |
last post by:
Tired of spending countless mintues downsampling your data? Look no further!
In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: jfyes |
last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
|
by: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
by: af34tf |
last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
| |