Search results

Hi I have a Calculated Query Table name DataQuery like Date / RJournal / AMount where Rjournal is a calculated field Rjournal : DLookUp("REFjournal","DV","ChckID > 0 and Payee = '" & [Payee] & "' and Dvnumber = " & [Dvnumber] & "") And it works fine. But since MS Access is my Database and...

Hi Im making a Excel Form in which my Database is an access. First I Encode data in Excel then Using Command Button to Post these data. The code within the Command Button.. first get the Max Number from Access and use that Number to Complete the Data in Excel to be exported to Access. The...

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...