Skip to Content
0
Former Member
Oct 12, 2007 at 07:24 PM

Needs to add a new column and sort the fileds in a query

30 Views

Hi Gurus

I am working on a query (SQ01) using 2 tables, the output is working fine. I need to add a new column (percentage) which should be like dividing from tax amount to net invoice value (TAX Amount/Net Invoice Value *100).

Can you please let me know how to add and do this.

Please let me know how to sort the fields in the particular mannar.

I will assign points

Thanks for your help

Prashanth