Hi
I am back with my bizarre questions.
What I want now is to create a query which would include fields from two Tables. The problem is as follows.
Table 1 has fields: Date_abs as date; Cons_abs as string
It returns datasheet:
06/01/2019 LS, NC, AW am, EK
07/01/2019 TW, CK, AW am, EK
08/01/2019 LS, CM, MP pm, EK
09/10/2019 LS, NC, AW am, EK
10/01/2019 LS, NC, AW am, EK
Table 2 has fields: Date_abs as date; SPR_abs as string
It returns datasheet:
06/01/2019 EOH, IJ
08/01/2019 LJ, LJ, RK
10/01/2019 EOH pm
When I create a simple query including Date_abs; Cons_abs; SPR_abs with date_abs related, I get the result with 3 dates only:
06/01/2019 LS, NC, AW am, EK EOH, IJ
08/01/2019 LS, CM, MP pm, EK LJ, LJ, RK
10/01/2019 LS, NC, AW am, EK EOH pm
and I understand why. Because there are only three dates in Table 2.
But I want this datasheet as a result of my query:
06/01/2019 LS, NC, AW am, EK EOH, IJ
07/01/2019 TW, CK, AW am, EK
08/01/2019 LS, CM, MP pm, EK LJ, LJ, RK
09/10/2019 LS, NC, AW am, EK
10/01/2019 LS, NC, AW am, EK EOH pm
I wand all dates included and where there is no record for SPR_abs it should be left just empty of blank.
Is it possible at all?
I am back with my bizarre questions.
What I want now is to create a query which would include fields from two Tables. The problem is as follows.
Table 1 has fields: Date_abs as date; Cons_abs as string
It returns datasheet:
06/01/2019 LS, NC, AW am, EK
07/01/2019 TW, CK, AW am, EK
08/01/2019 LS, CM, MP pm, EK
09/10/2019 LS, NC, AW am, EK
10/01/2019 LS, NC, AW am, EK
Table 2 has fields: Date_abs as date; SPR_abs as string
It returns datasheet:
06/01/2019 EOH, IJ
08/01/2019 LJ, LJ, RK
10/01/2019 EOH pm
When I create a simple query including Date_abs; Cons_abs; SPR_abs with date_abs related, I get the result with 3 dates only:
06/01/2019 LS, NC, AW am, EK EOH, IJ
08/01/2019 LS, CM, MP pm, EK LJ, LJ, RK
10/01/2019 LS, NC, AW am, EK EOH pm
and I understand why. Because there are only three dates in Table 2.
But I want this datasheet as a result of my query:
06/01/2019 LS, NC, AW am, EK EOH, IJ
07/01/2019 TW, CK, AW am, EK
08/01/2019 LS, CM, MP pm, EK LJ, LJ, RK
09/10/2019 LS, NC, AW am, EK
10/01/2019 LS, NC, AW am, EK EOH pm
I wand all dates included and where there is no record for SPR_abs it should be left just empty of blank.
Is it possible at all?