I'm a little problem and would like to know if you could help me with one hand.
I am making an application in vb6 with questions DataReport $$$.
Now I have to print some slips yet must show a short summary of the last approved invoices made to the customer by way of information.
I have my consultation with shape (somewhat simplified because it is quite extensive)
Expand|Select|Wrap|Line Numbers
- EjecutarShape rstReport, "SHAPE {SELECT id_albaran, nroAlbaran approved, Total tbl_albaran FROM ORDER BY 1 DESC} header as" & _
- "APPEND ({SELECT id_detalle_albaran, concept, cost, id_clienteFK, id_albaranFK FROM tbl_albaran_detalle} as detail" & _
- "RELATE TO id_albaran id_albaranFK) retail as"
the query to get the summary would be using TOP 3
Expand|Select|Wrap|Line Numbers
- SELECT TOP 3 id_albaran, nroAlbaran approved, Total tbl_albaran FROM ORDER BY 1 DESC
I need to do something rather like:
any ideas or suggestions are welcome.
thank you very much for your patience.