Sum

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Barcode - 23 Mar 2008 20:07 GMT

Hello

Please can you make it correct or if there is other way for RESULT2.
I convert query to SQL and copy it to use on Visual Basic.
The code will be so:

RESULT2 =

SELECT Sum(Tillgangar.Anvand) AS SumOfAnvand, Tillgangar.Mobiltelefon
FROM Tillgangar
GROUP BY Tillgangar.Mobiltelefon
HAVING
(((Tillgangar.Mobiltelefon)=[forms]![Kontaktinformation]![Mobiltelefon]));

Thanks a lot

Reply to this Message

Allen Browne - 24 Mar 2008 01:48 GMT

You cannot use a query statement directly in code, nor in the Control Source
of a text box.

Try the DSum() function instead, e.g.:
=DSum("Anvand", "Tillgangar", "Mobiltelefon = """ &
[forms]![Kontaktinformation]![Mobiltelefon] & """")

Omit the extra quotes if Mobiltelefon is a Number field (not a Text field.)

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Please can you make it correct or if there is other way for RESULT2.
> I convert query to SQL and copy it to use on Visual Basic.
[quoted text clipped - 9 lines]
>
> Thanks a lot

Reply to this Message