Hi
I am trying to create a query but couldn’t figure out the logic.
I need your help
I have tow tables:
Table A:
Item
Start date
End date
Table B :
Item
Date (first date of each quarter)
I want to create a query to get me something like
Column heads are the list of first date of each quarter for the next 10 years
The data in the first column represent all the items from table A
Complete means: two things :
1- the item was active in this quarter (based on start and end date in Table A
2-the item for that quarter was found on Table A
Incomplete means: two things :
1- the item was active in this quarter (based on start and end date in Table A
2-the item for that quarter was NOT found on Table A
Not required means:
the item was not active in this quarter (based on start and end date in Table A
Example of output
I am trying to create a query but couldn’t figure out the logic.
I need your help
I have tow tables:
Table A:
Item
Start date
End date
Table B :
Item
Date (first date of each quarter)
I want to create a query to get me something like
Column heads are the list of first date of each quarter for the next 10 years
The data in the first column represent all the items from table A
Complete means: two things :
1- the item was active in this quarter (based on start and end date in Table A
2-the item for that quarter was found on Table A
Incomplete means: two things :
1- the item was active in this quarter (based on start and end date in Table A
2-the item for that quarter was NOT found on Table A
Not required means:
the item was not active in this quarter (based on start and end date in Table A
Example of output
Items | 1-1-2023 | 1-4-2023 | 1-7-2023 | 1-10-2023 |
Item 1 | Complete | |||
Item 2 | Incomplete | |||
Item 3 | Not required |