antique3S13's latest activity
-
Aantique3S13 replied to the thread Debit and Credit Entries in Table.Hi Ken, I appreciate your contribution, your kind is requested to elaborate following points, please. 1. Why "Cleared" field is created...
-
AAn example of your current layout may help with providing you with a solution and if you can let us know what version your using as the...
-
Aantique3S13 replied to the thread Debit and Credit Entries in Table.Hi Isaac, I have asked could you help me to how to create database, please.
-
Aantique3S13 replied to the thread Debit and Credit Entries in Table.Hi GPGerorge, Unfortunately, my concepts are very limited about creating database, so far, I know only that data is stored in tables...
-
Aantique3S13 replied to the thread Debit and Credit Entries in Table.Hi Ken, I really appreciate your work and regrettably I am not good in coding. So far, I have know that tables are used to store data...
-
Aantique3S13 reacted to Ken Sheridan's post in the thread Debit and Credit Entries in Table with
Like.
In the file attached to my last reply I'd omitted to amend the form's query so that the DSum function call was restricted to the the... -
Aantique3S13 reacted to Ken Sheridan's post in the thread Debit and Credit Entries in Table with Like.
You might find the attached file helpful. It contains a simplified version of the original form whose RecordSource query I posted...
-
Aantique3S13 reacted to Ken Sheridan's post in the thread Debit and Credit Entries in Table with Like.
To record transactions in one or more current accounts you'd just need the one table, whose definition is as in the following image...
-
Aantique3S13 replied to the thread Debit and Credit Entries in Table.Hi Ken, Much appreciated your profound response, I have asked could you help me to try this by using MS Access. I shall be grateful for...
-
Aantique3S13 reacted to Ken Sheridan's post in the thread Debit and Credit Entries in Table with Like.
If you do decide to use Access rather than Excel you can then base a form on a query like the following: SELECT Format(...
-
AYou may need a database instead, as implied in George's observation. Don't try to make Excel a database. 'Table' was the silliest...
-
AWell, when I have had to insert a row, I found excel adjusted the formulae to suit, so without seeing a workbook, hard to say. Plus...
-
AInterestingly enough, the limitations you have encountered are some of the strongest arguments for using a database, not a spreadsheet...
-
ANot enough to go on. :( Why not upload an example and state what you need and where?
-
AGreetings All, I want to create MS Excel Table to perform debit and credit entries in a single table. I have tried but works only in...