Sintax to DSUM (?)

I would like to know sintaxe to =DSUM...

To Sum in Main Form Textbox, all numeric values of fields
with same Id.

(Bad sample):

=DSum([EndKm]-[StartKm] Where [IdX]=[Forms]![F_MainForm]!
[IdX])

Thanks in advance.
an

The syntax is in the help file.

DSum(expr, domain, [criteria])

Using what you have:
=DSum("[EndKM]-[StartKm]", "TableOrQueryName", "[IdX]=" &
[Forms]![F_MainForm]![IdX])

This assumes that IdX is numeric, if it isn't, you'll have to concatenate in
quotes as well.
=DSum("[EndKM]-[StartKm]", "TableOrQueryName", "[IdX]=""" &
[Forms]![F_MainForm]![IdX] & """")

--
Wayne Morgan
MS Access MVP


"an" wrote in message
...
I would like to know sintaxe to =DSUM...

To Sum in Main Form Textbox, all numeric values of fields
with same Id.

(Bad sample):

=DSum([EndKm]-[StartKm] Where [IdX]=[Forms]![F_MainForm]!
[IdX])

Thanks in advance.
an

Ok, WM

Many thanks for your help.
Is exactly what I would like.
Have you a good weekend.
an


-----Original Message-----
The syntax is in the help file.

DSum(expr, domain, [criteria])

Using what you have:
=DSum("[EndKM]-[StartKm]", "TableOrQueryName", "[IdX]=" &
[Forms]![F_MainForm]![IdX])

This assumes that IdX is numeric, if it isn't, you'll
have to concatenate in
quotes as well.
=DSum("[EndKM]-[StartKm]", "TableOrQueryName", "[IdX]="""
&
[Forms]![F_MainForm]![IdX] & """")

--
Wayne Morgan
MS Access MVP


"an" wrote in
message
...
I would like to know sintaxe to =DSUM...

To Sum in Main Form Textbox, all numeric values of
fields
with same Id.

(Bad sample):

=DSum([EndKm]-[StartKm] Where [IdX]=[Forms]!
[F_MainForm]!
[IdX])

Thanks in advance.
an



.