Hi all I have A table like this
No |Payee |SLaccoun |Debit |Credit |CKCode |Date
1 |ARCEGA |Expenses |50 |0 |0 |10/4/2019
1 |ARCEGA |Remittance |0 |5 |0 |10/4/2019
1 |ARCEGA |Cash |0 |45 |1 |10/13/2019
1 |ARDIENTE |Expenses |50 |0 |0 |10/4/2019
1 |ARDIENTE |Cash |0 |50 |2 |10/12/2019
Now I wanted to make a Query inorder to generate another table like this
No |Payee |SLaccoun |Debit |Credit |CKCode |Date |Fdate
1 |ARCEGA |Expenses |50 |0 |0 |10/4/2019 |10/13/2019
1 |ARCEGA |Remittance |0 |5 |0 |10/4/2019 |10/13/2019
1 |ARCEGA |Cash |0 |45 |1 |10/13/2019 |10/13/2019
1 |ARDIENTE |Expenses |50 |0 |0 |10/4/2019 |10/12/2019
1 |ARDIENTE |Cash |0 |50 |2 |10/12/2019 |10/12/2019
Ive been Trying a DlookupFunction but it ends up to 10/13/2019
fDate: DLookUp("DATE","DV","CKcode > 0")
No |Payee |SLaccoun |Debit |Credit |CKCode |Date
1 |ARCEGA |Expenses |50 |0 |0 |10/4/2019
1 |ARCEGA |Remittance |0 |5 |0 |10/4/2019
1 |ARCEGA |Cash |0 |45 |1 |10/13/2019
1 |ARDIENTE |Expenses |50 |0 |0 |10/4/2019
1 |ARDIENTE |Cash |0 |50 |2 |10/12/2019
Now I wanted to make a Query inorder to generate another table like this
No |Payee |SLaccoun |Debit |Credit |CKCode |Date |Fdate
1 |ARCEGA |Expenses |50 |0 |0 |10/4/2019 |10/13/2019
1 |ARCEGA |Remittance |0 |5 |0 |10/4/2019 |10/13/2019
1 |ARCEGA |Cash |0 |45 |1 |10/13/2019 |10/13/2019
1 |ARDIENTE |Expenses |50 |0 |0 |10/4/2019 |10/12/2019
1 |ARDIENTE |Cash |0 |50 |2 |10/12/2019 |10/12/2019
Ive been Trying a DlookupFunction but it ends up to 10/13/2019
fDate: DLookUp("DATE","DV","CKcode > 0")
Last edited: