DSUM Date Criteria

[Rebeca]

could someone please tell me how to write the criteria for DSUM where
the first criteria is date1 < date 2 and the second critera is date 1

= date3

I'm getting Null for a total. This is what I have :

=DSum("total1","SN AR Log Query2","Physician = '" & [Physician] & "'"
& "AND [batch date] >= #" & [BeginningARDate] & "# AND #" & [batch
date]<[reportStartDate] & "#")

Thank you

 

[Douglas J. Steele]

=DSum("total1","SN AR Log Query2","Physician = '" & [Physician] & "'"
& "AND [batch date] >= #" & [BeginningARDate] & "# AND [batch
date]<[reportStartDate]")


--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

could someone please tell me how to write the criteria for DSUM where
the first criteria is date1 < date 2 and the second critera is date 1

= date3

I'm getting Null for a total. This is what I have :

=DSum("total1","SN AR Log Query2","Physician = '" & [Physician] & "'"
& "AND [batch date] >= #" & [BeginningARDate] & "# AND #" & [batch
date]<[reportStartDate] & "#")

Thank you

 

[Rebeca]

=DSum("total1","SN AR Log Query2","Physician = '" & [Physician] & "'"
& "AND [batch date] >= #" & [BeginningARDate] & "# AND [batch
date]<[reportStartDate]")

--
Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
(no private e-mails, please)

could someone please tell me how to write the criteria for DSUM where
the first criteria is date1 < date 2 and the second critera is date 1

I'm getting Null for a total.  This is what I have :

=DSum("total1","SN AR Log Query2","Physician = '" & [Physician] & "'"
& "AND [batch date] >= #" & [BeginningARDate] & "# AND #" & [batch
date]<[reportStartDate] & "#")

Thank you - Hide quoted text -

- Show quoted text -

One little ampersand....LOL, who knew. Anyway, I am getting #error on
this now. I am placing this in a text field on a report. I'm thinking
that the problem is [batch date] as according to my formula, it is
looking at the report. How do I rework this to look at the "batch
date" field in SN AR Log Query2 instead? Or am I offbase?

Thanks!

 

[Rebeca]

=DSum("total1","SN AR Log Query2","Physician = '" & [Physician] & "'"
& "AND [batch date] >= #" & [BeginningARDate] & "# AND [batch
date]<[reportStartDate]")

--
Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
(no private e-mails, please)

could someone please tell me how to write the criteria for DSUM where
the first criteria is date1 < date 2 and the second critera is date 1

I'm getting Null for a total.  This is what I have :

=DSum("total1","SN AR Log Query2","Physician = '" & [Physician] & "'"
& "AND [batch date] >= #" & [BeginningARDate] & "# AND #" & [batch
date]<[reportStartDate] & "#")

Thank you - Hide quoted text -

- Show quoted text -

One little ampersand...who knew, LOL! Works great thank you