Insert trigger

Hi

I have a table - DebtorTurnover - consisting of 5 fields (ID, Date,
Turnover, VAT, Netturnover). I get a file which I have to import every
know and then, with new data. In this file I only get values for (ID,
Date, Turnover and VAT). The import is working fine with the import
wizard.

The problem is, that I want to have the Netturnover computed at the
time of insert to equal [Turnover-VAT], but I don't really know how to
as I'm new to these triggers.

Could anyone help me I would appriciate this.
BR / Jan

.

Relevant Pages

  • Re: Insert trigger
    ... Turnover, VAT, Netturnover). ... that I want to have the Netturnover computed at the ... CREATE TRIGGER DebtorTurnover_tri ON DebtorTurnover ...
    (comp.databases.ms-sqlserver)
  • Re: The Vat man
    ... I don't have much turnover so I don't charge VAT. ... Details of business premises held. ... How are your sales made? ...
    (uk.legal)
  • Re: VAT flat rate & bank interest
    ... >Query about whether bank interest received counts as income for vat flat ... >rate turnover (company client, so there is no argument that its "private" as ... >I've told a client that interest is subject to flat rate. ...
    (uk.business.accountancy)
  • Re: The Vat man
    ... I don't have much turnover so I don't charge VAT. ... Details of business premises held. ... The questions above seem to be testing whether you have a larger retail/warehouse facility than your turnover support, whether you do any cash sales, and they ask for suppliers so they can phone one at random to check whether the stock you *say* you buy matches their records. ...
    (uk.legal)
  • Re: VAT Registration
    ... I have a turnover of £35k pa and my future partner ... registered for VAT. ... April 2007 and voluntary register at that time? ... As plumbers, presumably the majority of your turnover arises ...
    (uk.business.accountancy)