How to Subtract columns in Access 2007

  • Re: How to Subtract columns in Access 2007


    In Access(Jet) you have not COLUMN as in Excel, but Fields in Tables.
    If your 2 Fields are both FieldType=DateTime you have to use DateDiff(...<F1 for Help>...), here you could chose if you want the difference in second or minute.
    If your 2 Fields are some different Type... pleas think about this and convert them to DateTime, or just for calculation...!