0 |
Subject: SQL query help
Posted by: RecycledSpinalFluid
- Dude [204401122] Thu, Dec 31, 2009, 00:39
Access/SQL is not my strong point, so I'm asking for some help.
In an Access MDB, I have a table (tblHistory) that looks like this:
dDate (a date/time field) iIdentNumber (integer) iCount (integer)
Now, what I want to do is make a query that shows the iIdentNumber where the iCount has incremented over a 1 day period (from [date - 1] to [date].
Make sense? I swear I've done this before, but its escaping me now.
Any help is appreciated. |
1 | Dr. Doom
ID: 430271612 Thu, Dec 31, 2009, 15:27
|
Assuming iIdentNumber is the key field.
One way might be
select iIdentNumber from foo t1 join foo t2 where t1.iIdentNumber = t2.iIdentNumber and t1.dDate = t2.dDate -1 and t1.iCount > t2.iCount ;
Not sure if the syntax is exactly right but the idea should be close.
|
2 | RecycledSpinalFluid Dude
ID: 204401122 Thu, Dec 31, 2009, 17:34
|
Ah! Many thanks. Wasn't thinking JOIN the table to itself. Built it with the Query Wizard in Access after looking at your suggestion and its good to go now (and rather bloated looking)!
Thanks again!
|
|
|
Post a reply to this message:
|