Hi. I am trying to make a cashbook in Access for my fathers business.. I am new to Access and Bytes. I made a table with the following fields: ID (primary key), Supplier, Date, Invoice Number, Details, Zero Rated (this is a check box with a yes/no data type), Amount, VAT. I highlighted the VAT column in design view and went to default value and put this in
- IF([Zero Rated]=0,[Amount]*0.14,0)
BTW the name of the table is Purchases. I am getting errors with this formula though. Please help me where I am going wrong and also tell me what I am doing wrong.. I am keen to learn Access. :)
dayav07