Dsum() funktion

as far as I know Dsum is NOT a part of the VB Language but the Access VBA language!

I have no idea as to how you are using your Access database from VB but you could create a query in Access with paramters. Then you can open then query filling in th eparameters necessary!

You can also make a select statement to do what you want without using DSUM.

But I have no ideas as to your capabilities!

Well, actually I am just running an VB code which opens the database. Ex.:

db.OpenDatabase(dblink)
rs.OpenRecordset(\"SELECT bla bla DSum(\'[test]\';\'[tbl]\';\'\') FROM [blabla]\")

There is no difference from opening it from Access, only VB doesn\'t seem to have that DSum function... or what? Can I find some text anywhere about this?

Well about using other statements, I first tried making multiply Select statements, and implementing those into eachother... this way it sucked up all the CPU in no time.

Cant you just use SUM?

Try altering your query in Access to a totals query.

I dont think I can. See this:

SELECT [tbl-brugerlogin].[bruger-id], Sum([spil-min])-Sum([tidstyring-min]) AS tid
FROM [tbl-tidstyring] RIGHT JOIN ([tbl-brugerlogin] LEFT JOIN [tbl-spilstat] ON [tbl-brugerlogin].[bruger-id] = [tbl-spilstat].[spil-brugerid]) ON [tbl-tidstyring].[tidstyring-brugerid] = [tbl-brugerlogin].[bruger-id]
GROUP BY [tbl-brugerlogin].[bruger-id];

This code should sum the time a user has played. The problem is that it dublicates the posts a lot of times because there is 2 tables in the query. I can\'t explain exactly, as I don\'t know the exact error..., only that the above doesnt work

DSum dosn\'t exist in regular VB. But writing the equivalent in SQL i easy.

DSum(\'[test]\';\'[tbl]\';\'\') can also be written as:
SELECT SUM(test) FROM tbl

or
DSum(\'[test]\';\'[tbl]\';\'some condition\') =
SELECT SUM(test) FROM tbl WHERE some condition

Well I can see that you have no WHERE .... in the query so just make a query in access as you have been doing and then in VB use

SELECT * FROM yourQuery

instead of from yourtable

Kichian>> So how can I make multiply SELECT statements in one Query? Could u give an example




Terry>> I tried, but it seems as if the query is just being runned in VB anyway. It same error appears....

I found another way around without using DSum.

Thanks for the input