Hjælp til forespørgsel med dato

er der kun 1 dag forskel mellem Dato1 og dato2

THis question has been up at least three times within the last couple of days and all users have ALSO been created within the last couple of days.
Try asking Kim for an answer http://www.eksperten.dk/spm/359881

overmind, or is it Kim?
Just a thought! What your asking is very likley possible but if this is a school project then your not going to learn ANYTHING if we do this for you. Next, it seems you havent learnt much at school :o) Where is the primary key for example? If the dates are NOT in Ascendig order then it is not possible to find the next record, which IS necessary, unless you have a primary key or something so we can put the records in order!

Hi Terry - Hvem Kim ???, der efterhånden mange der hedder Kim - En HEL skole.

Niels

Hi Niels, I think we are just waisting our time here! They havnet learnt much at all this season, least of all placing an understandable question:o)

Sorry, but I'm not the same person.

Jeg kan godt se at nogen har udnyttet det her sted samt jeres tid, men som en anden skrev er vi en hel skole som har fået stillet en opgave. Og NEJ jeg er ikke den samme! Så kan nogen hjælpe eller ej?! Det er vel derfor vi er her inde, ik?

Terry --> The dates is in order, and I just want to know if it's possible to get date 1 not to be there in tabel 2 and date 4 to be there 2 times.

yes I would think it is

But can somebody tell me how do Í remove dato 1? And how do I add dato 4 (the last date)one more time?

What do you mean Remove date1?
Th problem is that you want to show the NEXT date in column two IF ther is one and in th ecase of the LAST date you repeat it, IKKE?

I'll tell you what I will do, which is just to make sure I dont waste more time! I'll make a solution and BEFORE I place it here then you can give the points. Take it or leave it :o)

yes, you have right, date one is not supose to be removed but just not included in that tabel.

when you say table, you do mean column?
You have ONE table and want a query (SQL) to show two columns?

Yes column, and yes to the other thing! Du er dansk ik?

Har du en mail, så kan jeg sende det til dig og på den måde kan du måske bedre forstå hvad jeg mener?

eksperten@santhell.dk

Dansk med et navn som Terry :o)

Jeg kan dansk

jeg bliver lige nødt til at løbe 1 times tid, men er snart tilbage, har sendt dig en mail

Ok, will answer as soon as I get time and find a solution :o)

as always, when other information is made available then the picture changes :o)
and your dates are NOT in order:

Dato
01/11/2002
03/11/2002
06/11/2002
01/11/2002
07/11/2002
08/11/2002
08/11/2002
01/11/2002
12/11/2002
14/11/2002
17/11/2002
17/11/2002
19/11/2002
19/11/2002
19/11/2002
22/11/2002
23/11/2002
24/11/2002
25/11/2002
25/11/2002
26/11/2002
26/11/2002
27/11/2002
27/11/2002
27/11/2002

SELECT A1.AnnonceNr, A1.Dato, Nz((select TOP 1 Dato from Annoncer A2 WHERE A2.AnnonceNr > A1.AnnonceNr),[A1]![Dato]) AS NextDate, DateDiff("d",[dato],[NextDate]) AS Elapsed
FROM Annoncer AS A1;

Output>
AnnonceNr    Dato    NextDate    Elapsed
1    01/11/2002    03/11/2002    2
2    03/11/2002    06/11/2002    3
3    06/11/2002    01/11/2002    -5
4    01/11/2002    07/11/2002    6
5    07/11/2002    08/11/2002    1
6    08/11/2002    08/11/2002    0
7    08/11/2002    01/11/2002    -7
8    01/11/2002    12/11/2002    11
9    12/11/2002    14/11/2002    2
10    14/11/2002    17/11/2002    3
11    17/11/2002    17/11/2002    0
12    17/11/2002    19/11/2002    2
13    19/11/2002    19/11/2002    0
14    19/11/2002    19/11/2002    0
15    19/11/2002    22/11/2002    3
16    22/11/2002    23/11/2002    1
17    23/11/2002    24/11/2002    1
18    24/11/2002    25/11/2002    1
19    25/11/2002    25/11/2002    0
20    25/11/2002    26/11/2002    1
21    26/11/2002    26/11/2002    0
22    26/11/2002    27/11/2002    1
23    27/11/2002    27/11/2002    0
24    27/11/2002    27/11/2002    0
25    27/11/2002    27/11/2002    0

YOU ARE A GOD! :-)

Problemet er bare at:
Annoncer.Overskrift='Porsche til salg'

Og det DATEDIFF imellem de datoer jeg skal bruge

But this is NOT at all clear from your original question! I will take a look at see what I can do.

cool

If you use this one you get a column of the dates there is needed:

SELECT Annoncer.Dato AS IndrykDato
FROM Annoncer
WHERE Annoncer.Overskrift LIKE 'Porsche til salg' AND Annoncer.Dato LIKE '*-11-2002';

TAK TAK TAK...det virkede. mange mange tak

Have you learnt ANYTHING about normalizing your dB?

One of the reasons for this is to eliminate this:

Overskrift
Mercedes benz til salg
Mercedes Benz til salg
Mercedes Benz til salg

Anyway, this should help although it DOESNT have many records with values >0

SELECT A1.AnnonceNr, A1.Overskrift, A1.Dato, Nz((select TOP 1 Dato from Annoncer A2 WHERE A1.overskrift = A2.overskrift AND A2.AnnonceNr > A1.AnnonceNr),[A1]![Dato]) AS NextDate, DateDiff("d",[dato],[NextDate]) AS Elapsed
FROM Annoncer AS A1;

it's okay I allready found out my self :-)

But you have been a big help!!!