Can anyone tell me what is wrong wi 2

[tqd123]

Can anyone tell me what is wrong with this statement? I kept getting TYPE MISMATCH error.

TotalQty = (DSum("[QtyOrdered]", "Load Query", "[ProductCode] = '" & TPC & "'" And "[CDueDate] = #" & PCDate & "#"))

If I put the criterias seperately then the statement works, but if I use the AND to use the criterias together, then I get the TYPE MISMATCH.

Thanks,

TD

 

[THWatson]

TD
I think the problem lies in the Where clause...
"[ProductCode] = '" & TPC & "'" And "[CDueDate] = #" & PCDate & "#"))

Try removing the quote mark (") before [CDueDate]

Tom

 

[mp9]

Try this.

TotalQty = DSum("QtyOrdered", "Load Query", "[ProductCode] = '" & TPC & "' And CDueDate = #" & PCDate & "#")

http://www22.brinkster.com/accessory/

 

[tqd123]

Thanks....That Worked!!!!!