---
title: "Resultat från \"detta året\" (2006)"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/144992-resultat-från-detta-året-2006"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "Eclipse"
published: "2006-04-03T07:53:21.000Z"
updated: "2006-04-03T10:04:34.000Z"
replies: 2
views: 268
page: 1
pages: 1
language: "sv-SE"
site: "webForum — webforum.nu"
rights: "Upphovsrätten till varje inlägg tillhör dess författare."
attribution: "Citera som: webForum, https://www.webforum.nu/amne/databaser-sql/144992-resultat-från-detta-året-2006"
---

# Resultat från "detta året" (2006)

## #1 — Eclipse, 2006-04-03T07:53Z

Jag använder Access + ASP och jag ska lista resultat från detta året. Denna koden fungerar och resultatet blir som jag vill. Min fråga är om det går att lösa datum-frågan på ett lite smidigare sätt!?

```
SQL = "SELECT COUNT(*) " _
	& ", (SELECT COUNT(*) FROM [starts] WHERE strP = '1' AND dteCreated >=#2006-01-01# AND dteCreated <#" & date() & "# AND bolView = TRUE) " _
	& ", (SELECT COUNT(*) FROM [starts] WHERE strP = '2' AND dteCreated >=#2006-01-01# AND dteCreated <#" & date() & "# AND bolView = TRUE) " _
	& ", (SELECT COUNT(*) FROM [starts] WHERE strP = '3' AND dteCreated >=#2006-01-01# AND dteCreated <#" & date() & "# AND bolView = TRUE) " _
	& ",  SUM(intPrissumma) " _
	& " FROM [starts] WHERE dteCreated >=#2006-01-01# AND dteCreated <#" & date() & "# AND bolView = TRUE ;"
```

Permalänk: https://www.webforum.nu/p/144992

## #2 — LarsG, 2006-04-03T09:57Z

```
SQL = "SELECT COUNT(*) " _
	& ", sum(iif(strP = '1',1,0)) " _
	& ", sum(iif(strP = '2',1,0)) " _
	& ", sum(iif(strP = '3',1,0)) " _
	& ",  SUM(intPrissumma) " _
	& " FROM [starts] "  _
        & " WHERE dteCreated >=#2006-01-01# " _
        & " AND dteCreated < date() " _
        & " AND bolView = TRUE"
```

Permalänk: https://www.webforum.nu/p/1793046

## #3 — Eclipse, 2006-04-03T10:04Z

Oj....!! Det var skillnad!

Permalänk: https://www.webforum.nu/p/1793048

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/144992-resultat-från-detta-året-2006