|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 18th, 2005, 04:19 PM
|
|||
|
|||
#Error
I have a report based on a crosstab query. I added a text field to the detail
section of the report that does the following: =Nz(DSum("[InvoiceAmt]","tbl_Invoices","[InvoiceDate] Between #1/4/05# And #31/3/06#]"),"$0.00 "). I would like the sum of the invoice amount between the dates above. I get an error when I try and run this? 
|
|
#2
March 18th, 2005, 05:07 PM
|
|||
|
|||
|
Use US format for the dates (m/d/yy):
=Nz(DSum("[InvoiceAmt]","tbl_Invoices","[InvoiceDate] Between #4/1/05# And #3/31/06#]"),"$0.00 "). -- Ken Snell MS ACCESS MVP "Tina" wrote in message news  I have a report based on a crosstab query. I added a text field to the detail section of the report that does the following: =Nz(DSum("[InvoiceAmt]","tbl_Invoices","[InvoiceDate] Between #1/4/05# And #31/3/06#]"),"$0.00 "). I would like the sum of the invoice amount between the dates above. I get an error when I try and run this?
|
|
#3
March 18th, 2005, 06:19 PM
|
|||
|
|||
|
I still get an error
"Ken Snell [MVP]" wrote: Use US format for the dates (m/d/yy): =Nz(DSum("[InvoiceAmt]","tbl_Invoices","[InvoiceDate] Between #4/1/05# And #3/31/06#]"),"$0.00 "). -- Ken Snell MS ACCESS MVP "Tina" wrote in message news I have a report based on a crosstab query. I added a text field to the detail section of the report that does the following: =Nz(DSum("[InvoiceAmt]","tbl_Invoices","[InvoiceDate] Between #1/4/05# And #31/3/06#]"),"$0.00 "). I would like the sum of the invoice amount between the dates above. I get an error when I try and run this?
|
|
#4
March 18th, 2005, 07:15 PM
|
|||
|
|||
|
Sorry... I didn't delete a ] character that was in your original expression:
=Nz(DSum("[InvoiceAmt]","tbl_Invoices","[InvoiceDate] Between #4/1/05# And #3/31/06#"),"$0.00 ") -- Ken Snell MS ACCESS MVP "Tina" wrote in message ... I still get an error "Ken Snell [MVP]" wrote: Use US format for the dates (m/d/yy): =Nz(DSum("[InvoiceAmt]","tbl_Invoices","[InvoiceDate] Between #4/1/05# And #3/31/06#]"),"$0.00 "). -- Ken Snell MS ACCESS MVP "Tina" wrote in message news I have a report based on a crosstab query. I added a text field to the detail section of the report that does the following: =Nz(DSum("[InvoiceAmt]","tbl_Invoices","[InvoiceDate] Between #1/4/05# And #31/3/06#]"),"$0.00 "). I would like the sum of the invoice amount between the dates above. I get an error when I try and run this?
|
|
#5
March 18th, 2005, 07:43 PM
|
|||
|
|||
|
thanks, that worked. But is there a way to specify 2 criteria. =Nz(DSum("[Allocation_Amt]","qry_allocation_partner_equip","[InvoiceDate] Between #1/4/06# and #3/31/07# AND "[Partner_ID] = " & [Partner_ID]),"$0.00 ") I've tried only having one of each and they work but when I but both of them together it just ignores the criteria. Any ideas why? "Ken Snell [MVP]" wrote: Sorry... I didn't delete a ] character that was in your original expression: =Nz(DSum("[InvoiceAmt]","tbl_Invoices","[InvoiceDate] Between #4/1/05# And #3/31/06#"),"$0.00 ") -- Ken Snell MS ACCESS MVP "Tina" wrote in message ... I still get an error "Ken Snell [MVP]" wrote: Use US format for the dates (m/d/yy): =Nz(DSum("[InvoiceAmt]","tbl_Invoices","[InvoiceDate] Between #4/1/05# And #3/31/06#]"),"$0.00 "). -- Ken Snell MS ACCESS MVP "Tina" wrote in message news
I have a report based on a crosstab query. I added a text field to thedetail section of the report that does the following: =Nz(DSum("[InvoiceAmt]","tbl_Invoices","[InvoiceDate] Between #1/4/05# And #31/3/06#]"),"$0.00 "). I would like the sum of the invoice amount between the dates above. I get an error when I try and run this?
|
|
#6
March 18th, 2005, 07:54 PM
|
|||
|
|||
|
Just need to get the " characters in the right places:
=Nz(DSum("[Allocation_Amt]","qry_allocation_partner_equip","[InvoiceDate] Between #1/4/06# and #3/31/07# AND [Partner_ID] = " & [Partner_ID]),"$0.00 ") -- Ken Snell MS ACCESS MVP "Tina" wrote in message ... thanks, that worked. But is there a way to specify 2 criteria. =Nz(DSum("[Allocation_Amt]","qry_allocation_partner_equip","[InvoiceDate] Between #1/4/06# and #3/31/07# AND "[Partner_ID] = " & [Partner_ID]),"$0.00 ") I've tried only having one of each and they work but when I but both of them together it just ignores the criteria. Any ideas why? "Ken Snell [MVP]" wrote: Sorry... I didn't delete a ] character that was in your original expression: =Nz(DSum("[InvoiceAmt]","tbl_Invoices","[InvoiceDate] Between #4/1/05# And #3/31/06#"),"$0.00 ") -- Ken Snell MS ACCESS MVP "Tina" wrote in message ... I still get an error "Ken Snell [MVP]" wrote: Use US format for the dates (m/d/yy): =Nz(DSum("[InvoiceAmt]","tbl_Invoices","[InvoiceDate] Between #4/1/05# And #3/31/06#]"),"$0.00 "). -- Ken Snell MS ACCESS MVP "Tina" wrote in message news
I have a report based on a crosstab query. I added a text field tothe detail section of the report that does the following: =Nz(DSum("[InvoiceAmt]","tbl_Invoices","[InvoiceDate] Between #1/4/05# And #31/3/06#]"),"$0.00 "). I would like the sum of the invoice amount between the dates above. I get an error when I try and run this?
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Backing Database | GOL | General Discussion | 4 | January 28th, 2005 03:32 PM |
| Error message different in MDB and MDE | david epsom dot com dot au | General Discussion | 1 | September 21st, 2004 12:47 AM |
| Help, i'm gettiing error: Access has encountered a problem and needs to close... | betsy | General Discussion | 0 | September 14th, 2004 08:20 PM |
| Expression - calculating running total | Kathy | Running & Setting Up Queries | 26 | June 22nd, 2004 10:14 PM |
| Custom Error Messages | DMc2004 | Database Design | 4 | June 11th, 2004 11:16 PM |
Linear Mode
