Viewing 4 posts - 1 through 4 (of 4 total)
Thanks Old Hand...this is fabulous
kevin
May 7, 2009 at 6:24 am
select distinct custno, currency, COUNT(currency) from tblSales
group by custno, currency having currency = 'USD' or currency='CAD'
order by custno
May 6, 2009 at 12:09 pm
it gives me the number of transactions for each currency not the customers that have two different currencies
0000104691USD41
0000104698USD450
0000104707USD4
0000104708USD266
0000104710USD35
0000104717CAD440
0000104724CAD3
I need to know if 0000104724 has orders in CAD and in USD...
May 6, 2009 at 9:23 am
thanks for the advice, i'll give it a go
May 6, 2009 at 9:19 am
Viewing 4 posts - 1 through 4 (of 4 total)