Dsum problem

[biskra]

why my Dsum query not work

i use his code

total: DSum("[inv_amt]";"invoices";"[inv_no]<[inv_no]")

 

[KenHigg]

Where exactly do you need to use the sum? In a report or form?

kh

 

[biskra]

in a form.

 

[KenHigg]

I don't know that I've ever seen a domain function used in a query like you posted, but it may be usefull somewhere...

Anyway, I think maybe I would put a text box on the form and set its control source using the domain function.

This would sum all records:

DSum("[inv_amt]";"invoices")

However, I think maybe you need to do all invoices for a customer (or something along those lines?)

This of course is all a qualified response to your issue as I don't think I get the entire picture...

???
kh

 

[biskra]

thank you for fast reply.

 

[KenHigg]

You're welcome. Did you get it to work?

kh

 

[biskra]

yet it work.
sorry for my bad english.

 

[KenHigg]

How ironic - Someone apologizing to a redneck from Alabama for bad English ...

 

[Rich]

How ironic - Someone apologizing to a redneck from Alabama for bad English ...

"Sweet Home Alabama" great song by the way

 

[KenHigg]

"Sweet Home Alabama" great song by the way

?!? Anyone makes that kind of statement can't be all bad.