Search results

I have a table containing 1.6 million reacts. I want to take the date in the table and populate another field in the same table. The table is index. I was going to use an append query but I can not get it working This is what I want to do. Date field example 12/10/2021 = DayMonth field 12/10

I need to populate the DayMonth field using the date field. The "Day/month" will be used in combination with the T\week table (please do not think week but period instead) The 01/01/yyyy = day one in period one.

Thanks for that. It would be best to sort the period at mm/dd, The period attached to this field is numerical sorted. The thing I am trying to sort is a smoothed biological period of 7 days. do not think week. It is a way of assign a date to a period. Animals do not use a calendar. if a bird...

OK a normal year has 365 and a leap year 366. If you want to smooth your data in periods similar to weeks that relate to the biological year instead of the commercial week, which has either 52, 53 and every 30 years a 54 weeks. If you use 7 day periods (because people relate to weeks) you end...