Compare current record to previous record

[Guest]

I am using Office 2003 on Windows XP.

I need a SQL string that selects records from a table (

) such that
the [High_Balance] for today ([Run_Date]) is greater than the [Low_Balance]
as recorded in the previous day's record ([Run_Date] minus one day) for each
[Acct_Number] in the

.

This should yield a list of [Acct_Number]'s where today's high balance is
greater than yesterday's low balance.

Can someone please help me out on this one?

Many thanks in advance.

 

[giorgio rancati]

Hi, quartz
if I understood well .....
----
SELECT T1.*
FROM Tables AS T1
INNER JOIN
Tables AS T2 ON T1.Run_Date-1=T2.Run_Date
WHERE T1.High_Balance>T2.Low_Balance

 

[Guest]

Thanks Giorgio,

Only, shouldn't [Acct_Number] figure into the SQL somewhere? I only want to
compare like accounts...how would that be included?

Hi, quartz
if I understood well .....
----
SELECT T1.*
FROM Tables AS T1
INNER JOIN
Tables AS T2 ON T1.Run_Date-1=T2.Run_Date
WHERE T1.High_Balance>T2.Low_Balance
----

Bye
Giorgio

I am using Office 2003 on Windows XP.

I need a SQL string that selects records from a table (

) such that
the [High_Balance] for today ([Run_Date]) is greater than the [Low_Balance]
as recorded in the previous day's record ([Run_Date] minus one day) for each
[Acct_Number] in the

.

This should yield a list of [Acct_Number]'s where today's high balance is
greater than yesterday's low balance.

Can someone please help me out on this one?

Many thanks in advance.

 

[giorgio rancati]

ops..
I forgot [Acct_Number]

----
SELECT T1.*,T2.Low_Balance AS Yesterday_Low_Balace
FROM Tables AS T1
INNER JOIN
Tables AS T2 ON T1.Run_Date-1=T2.Run_Date
AND T1.Acct_Number=T2.Acct_Number
WHERE T1.High_Balance>T2.Low_Balance
----


Bye
Giorgio

Thanks Giorgio,

Only, shouldn't [Acct_Number] figure into the SQL somewhere? I only want to
compare like accounts...how would that be included?

Hi, quartz
if I understood well .....
----
SELECT T1.*
FROM Tables AS T1
INNER JOIN
Tables AS T2 ON T1.Run_Date-1=T2.Run_Date
WHERE T1.High_Balance>T2.Low_Balance
----

Bye
Giorgio

I am using Office 2003 on Windows XP.

I need a SQL string that selects records from a table (

) such that
the [High_Balance] for today ([Run_Date]) is greater than the [Low_Balance]
as recorded in the previous day's record ([Run_Date] minus one day)

for
each

[Acct_Number] in the

.

This should yield a list of [Acct_Number]'s where today's high balance is
greater than yesterday's low balance.

Can someone please help me out on this one?

Many thanks in advance.

 

[Guest]

Thanks much Giorgio, I will give this a try tomorrow when I return to work!

ops..
I forgot [Acct_Number]

----
SELECT T1.*,T2.Low_Balance AS Yesterday_Low_Balace
FROM Tables AS T1
INNER JOIN
Tables AS T2 ON T1.Run_Date-1=T2.Run_Date
AND T1.Acct_Number=T2.Acct_Number
WHERE T1.High_Balance>T2.Low_Balance
----


Bye
Giorgio

Thanks Giorgio,

Only, shouldn't [Acct_Number] figure into the SQL somewhere? I only want to
compare like accounts...how would that be included?

Hi, quartz
if I understood well .....
----
SELECT T1.*
FROM Tables AS T1
INNER JOIN
Tables AS T2 ON T1.Run_Date-1=T2.Run_Date
WHERE T1.High_Balance>T2.Low_Balance
----

Bye
Giorgio

"quartz" <[email protected]> ha scritto nel messaggio
I am using Office 2003 on Windows XP.

I need a SQL string that selects records from a table (

) such that
the [High_Balance] for today ([Run_Date]) is greater than the
[Low_Balance]
as recorded in the previous day's record ([Run_Date] minus one day) for
each
[Acct_Number] in the

.

This should yield a list of [Acct_Number]'s where today's high balance is
greater than yesterday's low balance.

Can someone please help me out on this one?

Many thanks in advance.