Search results

  1. F

    Omit Zero from default value deducting numbers?

    Hello, I have a default value in a form based on a DMin value -1 , so that the 'Week Number' in a new record is one number less than the existing values in that field. Is there a way that I can get it to exclude zero? I would like the numbers to only be positive or negative integers. So that...
  2. F

    Consecutive date in next record?

    I am building a Tour Booking Form and am trying to set the default value in the 'TourDate' field. I would like it to be the next consecutive available date from my 'TourDate' field in a table called 'CompositeKeySchedule'. I have previously done this using a =DateAdd ("d","1",DMAX()) expression...
  3. F

    Hello everyone!

    Hello, I'm a new member trying to do a very rapid zero to hero learn of Access for a new job. I work in theatre and since it's been so quiet this year my boss has got me developing his dream high tech database... with no developer experience at all. I think I will have a lot of questions for...
Top Bottom