Hey Guys, I also tried this: =Nz(DLookUp("InvoiceTotal","InvoiceQ","ContractID=" & [ContractID] And " & [InvoiceStatusID]=313"),0)

Rewatch the DLookup video and other Dfunctions, your quotations/concatenations are all over the place.


=NZ(Dcount("*","InvoiceT","ContractID=" & [ContractID] & " and InvoiceStatusID=""InvoicePending"""),0)

Watch this one too Concatenation

Thanks Adam for the help, I will try this next.

Hey, here's what I came to use:

Number of Invoices: =Nz(DCount("*","InvoiceT","ContractID=" & [ContractID] & " AND InvoiceStatusID=313"),0)

Amount of Invoices: =Nz(DLookUp("InvoiceTotal","InvoiceQ","ContractID=" & [ContractID] And " & [InvoiceStatusID]=""313"""),0)

=DSum("Total","Invoices","[Invoice Date]>=Date()-60 &  [Invoice Date]<=Date()-30 & " AND [Invoice Status]='Overdue'")

Go look at the Common Formats on the DLookup page about half way down the page.
Depending on the data type (Number, Date, Text) the way your formula will be different.

Also on the page above.  You are missing your # symbols for the dates.

Hey Scott, I change the

Amount of Invoices, 'Overdue by 30 - 60 Days: =Nz(DSum("InvoiceTotal","InvoiceQ","InvoiceDate >=#" & Date()-30 & "# AND InvoiceDate <=#" & Date()-60 & "# AND InvoiceStatusID= 320"),0)

Number of Invoices, 'Overdue by 30 - 60 Days: =Nz(DCount("*","InvoiceT","InvoiceDate >=#" & Date()-30 & "# AND InvoiceDate <=#" & Date()-60 & "# AND InvoiceStatusID= 320"),0)

but I was change the 'Amount of Invoices, "Overdue by 30 - 60 Days" to a DLOOKUP and lookup the InvoiceTotal from the InvoiceQ?

No, don't change it to a DLookup, that is for looking up one value. But the dlookup page has a great color coded list of syntax on the page below the main paragraph "Common Formats"

Glossary