Recent content by CK_1984

  1. C

    Converting 3 number fields into 1 date field?

    I thought it worked until I tried to set criteria. Criteria between [enter begin date] and [enter end date] Input 7/1/2009 and 8/15/2010 Answer all dates with 7 and 8 as the month regardless of day and year and no date in between those months. Can I not set criteria like a regular date field...
  2. C

    Converting 3 number fields into 1 date field?

    Thank you it work beautifully
  3. C

    Converting 3 number fields into 1 date field?

    I have 3 number fields [Month], [Day], [Year]. I would like to combine these 3 fields into 1 date field with the following format M/DD/YYYY. I tried DateSerial([Month], [Day], [Year]) without success. For example: When Month is 11, Day is 9, and Year is 1998 the DateSerial answer is...
Back
Top Bottom