Hi,
I am having a problem of displaying output in the following format:
Invoice Date Amount Invoice Date Amount
12345 04/02/17 200.00 12361 04/02/21 100.11
12346 04/02/18 200.00 12365 04/02/22 200.00
12347 04/02/19 200.00
12349 04/02/19 200.00
12350 04/02/20 200.00
OR
Invoice Date Amount Invoice Date Amount
12345 04/02/17 200.00 12365 04/02/18 200.00
12346 04/02/19 200.00 12350 04/02/19 200.00
12347 04/02/20 200.00 12361 04/02/21 100.11
12349 04/02/22 200.00
And the information comes from single table "Invoce".
Can someone tell me how to do this.
Thanks for any help I get.
I am having a problem of displaying output in the following format:
Invoice Date Amount Invoice Date Amount
12345 04/02/17 200.00 12361 04/02/21 100.11
12346 04/02/18 200.00 12365 04/02/22 200.00
12347 04/02/19 200.00
12349 04/02/19 200.00
12350 04/02/20 200.00
OR
Invoice Date Amount Invoice Date Amount
12345 04/02/17 200.00 12365 04/02/18 200.00
12346 04/02/19 200.00 12350 04/02/19 200.00
12347 04/02/20 200.00 12361 04/02/21 100.11
12349 04/02/22 200.00
And the information comes from single table "Invoce".
Can someone tell me how to do this.
Thanks for any help I get.