tamount = DSum("[Invtotal]", "tblsalesinvoice", "[InvDate] >= #" & [Text150] & "# And " & "[invDate] <= #" & [Text152] & "#")
Hia all, I was wondering if any of you have come across an issue I am having with the code above.
It is simply calculating the total value of the field “Invtotal” between 2 dates. However when I run it I get a figure that it not correct. Nor can I fund where it is getting the figure from.
I ran A simple query as a test to get the “invtotal” with a criteria >= 1-1-19 and <=30-1-19 . this works fine, but when I put it in to the dsum as above I get a complete different value.. Any help, hints or such would be most greatfull AM I missing some thing so simple I cant see it
. Thank you all in advance
Brain dead
Hia all, I was wondering if any of you have come across an issue I am having with the code above.
It is simply calculating the total value of the field “Invtotal” between 2 dates. However when I run it I get a figure that it not correct. Nor can I fund where it is getting the figure from.
I ran A simple query as a test to get the “invtotal” with a criteria >= 1-1-19 and <=30-1-19 . this works fine, but when I put it in to the dsum as above I get a complete different value.. Any help, hints or such would be most greatfull AM I missing some thing so simple I cant see it
. Thank you all in advance
Brain dead