Hi
i currently have a simple spreadsheet in Excel containgin the following fields.
## Date - not unique
simpy shows the date of the transaction
## Debt - who the debt will be paid to - unique per date (e.g. CompanyA)
## Type of debt - what service is it - not unique by date or debtor (e.g. Wages)
## Net Price before VAT (X)
## VAT (value added tax, a UK tax) (Y)
## Price of Service (Z = X+Y)
## Running total of Net Price before VAT (X + X + X...)
## Running total of VAT (Y + Y + Y...)
##Balance - (Z + Z + Z...)
The spreadsheet currently calculates this automatically using simple formulas.
I'd like to create a nice little interface for this data entry using MS access forms. From then I can easily create queries and reports etc.
can somebody please help me out!
I've tried to list my entities and create an ERD to no avail!
Many Thanks
Mike
i currently have a simple spreadsheet in Excel containgin the following fields.
## Date - not unique
simpy shows the date of the transaction
## Debt - who the debt will be paid to - unique per date (e.g. CompanyA)
## Type of debt - what service is it - not unique by date or debtor (e.g. Wages)
## Net Price before VAT (X)
## VAT (value added tax, a UK tax) (Y)
## Price of Service (Z = X+Y)
## Running total of Net Price before VAT (X + X + X...)
## Running total of VAT (Y + Y + Y...)
##Balance - (Z + Z + Z...)
The spreadsheet currently calculates this automatically using simple formulas.
I'd like to create a nice little interface for this data entry using MS access forms. From then I can easily create queries and reports etc.
can somebody please help me out!

Many Thanks
Mike