Recent content by ismafoot

Thank you very much Mark

I absolutely agree. However im not trying to build an accounting software because the project is more of a data entry database which is not required to be compliant in anyway. Its purpose is more for recording transactions we made (money coming in and money coming out). So it doesn't need to...

Thats exactly what I am trying to do. The companies can have between 2-10 different accounts and I need to have a table for each account. Each account is in essence a journal entry : debit = payment ; credit = advance. So for each table (i.e. account), there must be a query and a report...

Unfortunately, I can not have it all in one table. I must have a table for each account: For example : one for canadian $ , another for euro, another for USD and so on.

Thats exactly what I am trying to do. The companies can have between 2-10 different accounts and I need to have a table for each account. Each account is in essence a journal entry : debit = payment ; credit = advance. So for each table (i.e. account), there must be a query and a report...

Hi all, Im having difficulty trying to map out the ideal table composition for accounts of companies. Basically a company usually has 4 accounts, and each account must have the following column headers: Account 1: Manufacturing Facility in US dollars. - date - advances (positive amounts) -...