Search results

  1. E

    Automatic Job Numbers

    I have made a table for all our new jobs and every time we get a new project we make a new job number. Is there a way to set a default value in the table so that every time we add a new entry the Job Number coloum automatically adds the next number in sequence? And can I do this without...
  2. E

    Extract Year From Date Field?

    I am new to Access to please forgive me if the answer to my question is simple. I have created a new table with the companies Job numbers, Date Entered, Client Name, and Project Name. I really want to add a field at the end which automatically extracts just the year from the Date Entered...
Top Bottom