Recent content by Netassess

  1. N

    Counting not null values in 3 columns, storing each row count in a 4th column.

    Thanks heaps, I am re-doing the structure to suit. Really appreciate your advice..
  2. N

    Counting not null values in 3 columns, storing each row count in a 4th column.

    Thanks so much. The app is to record up to 3 random weighs out of 15-20 loads each day for each of 12 trucks. The objective is to ascertain the average load weight for all 12 trucks over a period of approx. 6 months. This average is then used to calculate approx. how much product has been...
  3. N

    Counting not null values in 3 columns, storing each row count in a 4th column.

    Thanks for that. So, with only the Weigh columns in a seperate table? I need to also record the Date of the Weighs and the Registration Number of each truck being weighed. Please forgive my ignorance on this...
  4. N

    Counting not null values in 3 columns, storing each row count in a 4th column.

    Thanks for your reply. I understand that Access is not Excel. Can you give me a tip on where I haven't normalised the data? Thanks.
  5. N

    Counting not null values in 3 columns, storing each row count in a 4th column.

    Thanks Jon, have read the information on the link above.
  6. N

    Counting not null values in 3 columns, storing each row count in a 4th column.

    Hi, I have a datasheet I use for checking weights of various trucks once loaded. I have a Date, Registration Number, 1st Weigh, 2nd Weigh, 3rd Weigh Column. I need to average the weigh data of each row into a 4th column. Sometimes there is only 1 or 2 weighs conducted so i can't simply Average...
  7. N

    Introducing myself

    Hello, greetings from Queensland, Australia.
See more
Top Bottom