Hi All,
"Balan
I have a form "Petty Cash Book" its Record Source is:
SELECT [Petty Cash].TransactionID, [Petty Cash].TransactionDate, [Petty Cash].Details, [Petty Cash].AmountReceived, [Petty Cash].Expenses, DSum("AmountReceived","Petty Cash","TransactionID <=" & [TransactionID])-DSum("Expenses","Petty Cash","TransactionID <=" & [TransactionID]) AS Balance
FROM [Petty Cash]
ORDER BY TransactionID;
Couple of days before i deleted some records manually, so now "TransactionID" field which is Auto Number is missing its sequence i.e. after TransactionID:131 i have TransactionID:157 and so on.
Today viewing the report for Petty Cash Book/Table "Petty Cash" i observed that field "Balance" is blank after TransactionID:131.
I can manually fill the Balance field, but i think this is not the right approach, so how could i manage it, and also for in future if i do manually delete any record this thing would again happen.
What is the solution for this OR am i bound not to delete any record manually?
Help for this would be highly appreciated with thanks.
Khalid
__._,_.___
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (1) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar