Re: SQL - Printing Dates With 0 "Count" Records

Tech-Archive recommends: Fix windows errors by optimizing your registry

Here is what implemented in the control:

=DCount("*","EmployeesActivity","[ActivityDate] > #3/1/2006#" & " AND
[DatabaseID] = " & [txt_DatabaseID])


The result I get is that the first person on the report has a value of
1. Then the numbers go as follows:


3
5
7
8
9
11
12
13
14
16
18


and there is only 1 person on the report that has two incidents for the
time period in question.

As for the identification of individuals, yes. I am actually using a
DatabaseID field from the table and the control on the form is called
txt_DatabaseID

Thanks for your time.

.

Relevant Pages

  • Re: PLEASE HELP....Properties and Methods
    ... I tried changing the control name of RecipeName on the report and I am ... You have to substitute the NAME property of your control in here... ... The properties window changes as you ...
    (microsoft.public.access.reports)
  • RE: Emailers and Add-ons
    ... So 222 333 444 etc are just to show you where to put the name of the control. ... The title of the report is rptAuditOnLine ... Is there a way that a macro can be written to ... The macro opens a form. ...
    (microsoft.public.access.gettingstarted)
  • RE: *REPOST* If then Else Statment in Report
    ... "Duane Hookom" wrote: ... when a main report doesn't return records. ... Earlier as we found I was confused about the name of the control ... which is the name of the subreport as seen in the database window. ...
    (microsoft.public.access.reports)
  • Re: RTF2 ActiveX control stretches text in reports
    ... Report Abuse ... The issue is that the control in the detail section is not formatting ... third seems to have an issue with the font pitch as "I am ge ttin g ou ... Stephen Lebans Feb 5, 12:39 am show options ...
    (microsoft.public.access.reports)
  • RE: Capture Table Name
    ... I thought this was a common enough report that some fairly direct way existed ... each control on the form gets its data from. ... No further edits by UserJSmith during the time period specified.” ... know how to capture username and date and time but I ...
    (microsoft.public.access.formscoding)