It is necessary to determine the occurrence of the date in the week. For this, I created a separate table with numbers (names, they are text-type 2017-w-1) weeks.

Week table: name, home_data, end_data.

I create a query on the basis of the main Result table, in which there is a [Completion Date] field, on the basis of it, I create a calculated field with the condition - Week: IIf ([Completion Date] Between [Week]! [Home_data] And [Week]! [ End_data]; [Week]! [Name]; 'Out of Range').

And as a result, instead of 1000 records I get 54,000, as in the table Week 54 records. It turns out that one calculation is correct, and 53 'Out of range'.

How to establish a connection, or how to work without communication? I will then need grouping by week ...

    1 answer 1

    Fortunately, I myself found the answer to my question, or rather I suggested it on another resource:

    Week: DatePart ("ww"; [Completion Date]; 2; 2)

    And that's all, do not reinvent the bicycles, create extra tables. Why I didn’t find it anywhere, I don’t understand, decisions are too complicated everywhere.