Calculate last time number drawn using VB

Reply #8

Littleoldlady — Sun, 13 Feb 2005 13:09:43 GMT

I don't know anything about this stuff but it is so-o-o interesting. I joined that site..

Reply #7

bowldog — Wed, 09 Feb 2005 06:09:58 GMT

I'm using Access 2000 as the database.

Reply #6

SirMetro — Tue, 08 Feb 2005 22:25:01 GMT

You may be able to get some additional assistance herehttp://www.talkaboutsoftware.com/They are very helpfull here. Only takes a minute to sign up and it's all free.Sir Metro

Reply #5

Todd — Tue, 08 Feb 2005 15:18:29 GMT

Are you using SQL Server? What version? (If you're using Access, it may not support the code I wrote.

Reply #4

bowldog — Tue, 08 Feb 2005 06:00:47 GMT

wrong number of arguments error message

Reply #3

Todd — Tue, 08 Feb 2005 04:41:18 GMT

Try this, and see if it's faster:SELECT A.ID, A.Picks, ISNULL((SELECT TOP 1 B.ID-A.ID FROM Pick3day B WHERE (B.ID<A.ID) AND (B.Picks=A.Picks) ORDER BY B.ID DESC),0) AS IntervalFROM Pick3day A ORDER BY A.IDAlso, make sure the column ID is set to be a primary key.

Reply #2

bowldog — Tue, 08 Feb 2005 04:14:49 GMT

I am using the following query but it takes too longID,Picks,IntervalSELECT A.ID, A.Picks,A.ID-Nz(Max(B.ID),A.ID) AS IntervalFROM Pick3day AS A LEFT JOIN Pick3day AS B ON A.ID>B.ID AND A.Picks=B.PicksGROUP BY A.ID, A.Picks

Reply #1

hypersoniq — Tue, 08 Feb 2005 02:50:07 GMT

could you copy the code in? easier to see what's going on that way...what version of VB

Calculate last time number drawn using VB

bowldog — Tue, 08 Feb 2005 00:18:46 GMT

I have 2 fields ID and Picks, I want to add another field(Interval) that calculates the interval the last time a number was drawn.