Comments by Ahmed Emad

Ahmed Emad 10-Jan-14 8:39am View

that means i can't use it to insert but use it to update or delete.
but if i want to insert data to multiple tables what should i do ??

Ahmed Emad 8-Nov-13 15:38pm View

Sorry guys this xps file for table result in date 2013-08-01
https://www.dropbox.com/s/ykqi4nbucu24i5l/ex.xps

Ahmed Emad 6-Nov-13 8:59am View

Say
I have 3 collectors in collector column {ahmed, mohamed, ahmed}
And I have balance columns content {1000, 500, 400}
So I want to get collectors count that is 2 collector {ahmed, mohamed}
And get sum balance that must be 1900

Ahmed Emad 6-Nov-13 8:19am View

https://db.tt/JYjTozYY
This excel example
Try to filter date as 01/08/2013
You I want to get collectors count without duplicate not so I get 6 when I write COUNT (Collector) but they 3 collectors

Ahmed Emad 6-Nov-13 3:10am View

Yes
I want to sum all column value (get total)
And get count for cell s without duplicate cells but calculate it in sum total
In one query

Ahmed Emad 6-Oct-13 10:46am View

Thanks its work as well

Comments by Ahmed Emad (Top 6 by date)