Search results

  1. N

    Sum consecutive rows with values > 0 in a field

    Hi all I have a access table which I hopefully have correctly attached a snapshot of here The dates will always be consecutive and span from current date - 13 to current date +13 I am looking for something that, in a report, will sum consecutive days worked only, regardless of the year week...
  2. N

    CreateTableDef - Autonumber

    Could someone please advise how when creating a new Table using a CreateTableDef function I woud set the first field as a Autonumber field. Thank You
  3. N

    Time & Date problem

    Hi All I am looking for a formula that will calculate the Actual Arrival Date in column in D of the examples below. I have been searching this forum for quite a while now and have tried many different if statements of my own without success. Columns A – C are imported in from an Access table...
  4. N

    Can I use a Variable In a SQL Statement

    This is my first posting on a forum so I hope it makes sense. I would appreciate any help available I run the SQL shown below from a form button using DoCmd.RunSql without any trouble. Table A is a yearly rota for team A. I also have table B for team B, table C for team C etc. INSERT INTO...
Back
Top Bottom