Prev: how do I import data in excel form SQL server?
Next: How do I recover a forgotten password?
From: Casper on 14 Apr 2010 17:39
Hi Max,

I have a similar case, can you please help. Below is the data table I have.
On the 4th column "Status", I need to know which invoices remain outstanding
and which ones cancel off (squares with Credit amount). Will appreciate very
much if you can teach me a quick way to do it.

Customer Doc No. Amount Status
Susan Inv3355 893.10 Cancels off
Nelly Inv3356 250.14 Cancels off
Tom Inv3357 462.91 Cancels off
Nelly Cre1221 -250.14 Cancels off
Nelly Inv3358 350.14 Outstanding
Susan Cre1222 -893.10 Cancels off
Susan Inv3359 793.10 Outstanding
Tom Cre1223 -462.91 Cancels off
Tom Inv3360 462.91 Outstanding
Burt Cre1224 101.99 Outstanding

--
Many thanks,

Casper


"Max" wrote:

> Welcome, George.
> Good to hear that.
> --
> Max
> Singapore
> http://savefile.com/projects/236895
> xdemechanik
> ---
> "checkQ" <checkQ(a)discussions.microsoft.com> wrote in message
> news:63F37073-B601-45E2-98F8-8B46AB997B09(a)microsoft.com...
> > Awsome!!
> > It worked perfectly Max. Thanks
>
>
>
 | 
Pages: 1
Prev: how do I import data in excel form SQL server?
Next: How do I recover a forgotten password?