SQL statement problems

[Jon]

Hi all
I know this is not the preferred newsgroup, but you people are great with
SQL
MS ACCESS, VISUAL BASIC6

Hope you can see past my table, string definitions (Swedish), just ask
otherwise

Having some problem with a SQL statement
I need to be able to run strSQL3, but I get an error about sum and that I
don't have ArtikelNr.
I need to GROUP the 2 sums by week(InfogadVecka)

Any help at all would be appreciated
'this works fine
strSQL2 = "SELECT ArtikelNr, Förrådssaldo, Förrådsvärde, InfogadVecka" & _
" FROM tblData WHERE Artikelnr IN " & _
"(SELECT ArtikelNr FROM tblArtikelNrKundKanal WHERE KundKanalID=" &
KundKanalIdx & ")"

' Runtime error
strSQL3 = "SELECT ArtikelNr, SUM(Förrådssaldo) AS FSaldo, SUM(Förrådsvärde)
AS FVarde, InfogadVecka" & _
" FROM tblData WHERE Artikelnr IN " & _
"(SELECT ArtikelNr FROM tblArtikelNrKundKanal WHERE KundKanalID=" &
KundKanalIdx & ")" & _
" GROUP BY InfogadVecka"

--

Mvh
Jon

jo*************@comhem.se

[MacDermott]

Try this:

strSQL3 = "SELECT SUM(Förrådssaldo) AS FSaldo, SUM(Förrådsvärde)
AS FVarde, InfogadVecka" & _
" FROM tblData WHERE Artikelnr IN " & _
"(SELECT ArtikelNr FROM tblArtikelNrKundKanal WHERE KundKanalID=" &
KundKanalIdx & ")" & _
" GROUP BY InfogadVecka"
"Jon" <jr*@telia.com> wrote in message
news:Le********************@newsc.telia.net...

Hi all
I know this is not the preferred newsgroup, but you people are great with
SQL
MS ACCESS, VISUAL BASIC6

Hope you can see past my table, string definitions (Swedish), just ask
otherwise

Having some problem with a SQL statement
I need to be able to run strSQL3, but I get an error about sum and that I
don't have ArtikelNr.
I need to GROUP the 2 sums by week(InfogadVecka)

Any help at all would be appreciated
'this works fine
strSQL2 = "SELECT ArtikelNr, Förrådssaldo, Förrådsvärde, InfogadVecka" & _ " FROM tblData WHERE Artikelnr IN " & _
"(SELECT ArtikelNr FROM tblArtikelNrKundKanal WHERE KundKanalID=" &
KundKanalIdx & ")"

' Runtime error
strSQL3 = "SELECT ArtikelNr, SUM(Förrådssaldo) AS FSaldo, SUM(Förrådsvärde) AS FVarde, InfogadVecka" & _
" FROM tblData WHERE Artikelnr IN " & _
"(SELECT ArtikelNr FROM tblArtikelNrKundKanal WHERE KundKanalID=" &
KundKanalIdx & ")" & _
" GROUP BY InfogadVecka"

--

Mvh
Jon

jo*************@comhem.se

[Jon]

Hi MacDermott

Thanks for the help, works like a charm.

Regards
Jon