Dear All,
I am not an expert of Access.
I have the following query:
SELECT [Ordine_Versamento] & ";;" & [Material] & ";" & [Quantità] & ";;;" AS A, [Ordine_Versamento] & ";" & "V" & ";;;;" AS B
FROM TABELLA_IPOS_VERSAMENTO;
Where I obtain the following result:
A B
PREL_LL;;28LR078921;2;;; PREL_LL;V;;;;
PREL_LL;;28LR078921;5;;; PREL_LL;V;;;;
PREL_LL;;28LR117066;1;;; PREL_LL;V;;;;
PREL_LL;;28LR069697;1;;; PREL_LL;V;;;;
PREL_LL;;28LR032329;1;;; PREL_LL;V;;;;
PREL_LL;;28LR078921;10;;; PREL_LL;V;;;;
PREL_LL;;28LR072650;1;;; PREL_LL;V;;;;
PREL_LL;;28YWX101220;1;;; PREL_LL;V;;;;
PREL_LL;;28LR069697;1;;; PREL_LL;V;;;;
PREL_LL;;28LR069697;4;;; PREL_LL;V;;;;
PREL_LL;;28LR002189;1;;; PREL_LL;V;;;;
PREL_LL;;28LR027666;1;;; PREL_LL;V;;;;
PREL_LL;;28LR027664;1;;; PREL_LL;V;;;;
PREL_LL;;28LR078921;2;;; PREL_LL;V;;;;
PREL_LL;;28LR060915;1;;; PREL_LL;V;;;;
PREL_LL;;28MSC000030E;1;;; PREL_LL;V;;;;
PREL_LL;;28LR078921;4;;; PREL_LL;V;;;;
PREL_LL;;28LR023889;1;;; PREL_LL;V;;;;
PREL_LL;;28LR013005;1;;; PREL_LL;V;;;;
PREL_LL;;28LR078545;1;;; PREL_LL;V;;;;
PREL_LL;;28LR078545;1;;; PREL_LL;V;;;;
What I need is:
PREL_LL;V;;;; (first record)
PREL_LL;;28LR078921;2;;;
PREL_LL;;28LR078921;5;;;
PREL_LL;;28LR117066;1;;;
PREL_LL;;28LR069697;1;;;
PREL_LL;;28LR032329;1;;;
PREL_LL;;28LR078921;10;;;
PREL_LL;;28LR072650;1;;;
PREL_LL;;28YWX101220;1;;;
PREL_LL;;28LR069697;1;;;
PREL_LL;;28LR069697;4;;;
PREL_LL;;28LR002189;1;;;
PREL_LL;;28LR027666;1;;;
PREL_LL;;28LR027664;1;;;
PREL_LL;;28LR078921;2;;;
PREL_LL;;28LR060915;1;;;
PREL_LL;;28MSC000030E;1;;;
PREL_LL;;28LR078921;4;;;
PREL_LL;;28LR023889;1;;;
PREL_LL;;28LR013005;1;;;
PREL_LL;;28LR078545;1;;;
PREL_LL;;28LR078545;1;;;
The issue seems simple, but I don't how to proceed.
DB attached: View attachment VERSAMENTO_PRELIEVO_LL.accdb
Thanks.
Best regards,
Georg
I am not an expert of Access.
I have the following query:
SELECT [Ordine_Versamento] & ";;" & [Material] & ";" & [Quantità] & ";;;" AS A, [Ordine_Versamento] & ";" & "V" & ";;;;" AS B
FROM TABELLA_IPOS_VERSAMENTO;
Where I obtain the following result:
A B
PREL_LL;;28LR078921;2;;; PREL_LL;V;;;;
PREL_LL;;28LR078921;5;;; PREL_LL;V;;;;
PREL_LL;;28LR117066;1;;; PREL_LL;V;;;;
PREL_LL;;28LR069697;1;;; PREL_LL;V;;;;
PREL_LL;;28LR032329;1;;; PREL_LL;V;;;;
PREL_LL;;28LR078921;10;;; PREL_LL;V;;;;
PREL_LL;;28LR072650;1;;; PREL_LL;V;;;;
PREL_LL;;28YWX101220;1;;; PREL_LL;V;;;;
PREL_LL;;28LR069697;1;;; PREL_LL;V;;;;
PREL_LL;;28LR069697;4;;; PREL_LL;V;;;;
PREL_LL;;28LR002189;1;;; PREL_LL;V;;;;
PREL_LL;;28LR027666;1;;; PREL_LL;V;;;;
PREL_LL;;28LR027664;1;;; PREL_LL;V;;;;
PREL_LL;;28LR078921;2;;; PREL_LL;V;;;;
PREL_LL;;28LR060915;1;;; PREL_LL;V;;;;
PREL_LL;;28MSC000030E;1;;; PREL_LL;V;;;;
PREL_LL;;28LR078921;4;;; PREL_LL;V;;;;
PREL_LL;;28LR023889;1;;; PREL_LL;V;;;;
PREL_LL;;28LR013005;1;;; PREL_LL;V;;;;
PREL_LL;;28LR078545;1;;; PREL_LL;V;;;;
PREL_LL;;28LR078545;1;;; PREL_LL;V;;;;
What I need is:
PREL_LL;V;;;; (first record)
PREL_LL;;28LR078921;2;;;
PREL_LL;;28LR078921;5;;;
PREL_LL;;28LR117066;1;;;
PREL_LL;;28LR069697;1;;;
PREL_LL;;28LR032329;1;;;
PREL_LL;;28LR078921;10;;;
PREL_LL;;28LR072650;1;;;
PREL_LL;;28YWX101220;1;;;
PREL_LL;;28LR069697;1;;;
PREL_LL;;28LR069697;4;;;
PREL_LL;;28LR002189;1;;;
PREL_LL;;28LR027666;1;;;
PREL_LL;;28LR027664;1;;;
PREL_LL;;28LR078921;2;;;
PREL_LL;;28LR060915;1;;;
PREL_LL;;28MSC000030E;1;;;
PREL_LL;;28LR078921;4;;;
PREL_LL;;28LR023889;1;;;
PREL_LL;;28LR013005;1;;;
PREL_LL;;28LR078545;1;;;
PREL_LL;;28LR078545;1;;;
The issue seems simple, but I don't how to proceed.
DB attached: View attachment VERSAMENTO_PRELIEVO_LL.accdb
Thanks.
Best regards,
Georg