IIF condition for the date are not shown in the query (1 Viewer)

mansied

Member
Local time
Today, 01:16
Joined
Oct 15, 2020
Messages
98
Hello
I have a query that shows the correct details.
it should show 12-month data before the exact END DATE from exiting data .
for a specific case,I have just 2 2 month records to show.
How can I add a condition if the other months are not on the list put their value 1 or 100%.
this query :
1625073623333.png

change to this:

1625074087236.png
 

Attachments

  • 1625074021681.png
    1625074021681.png
    8.3 KB · Views: 203

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 22:16
Joined
Oct 29, 2018
Messages
18,962
You can use another table containing all the months to join with your existing data table and use an OUTER JOIN to show all the months in the result.
 

mansied

Member
Local time
Today, 01:16
Joined
Oct 15, 2020
Messages
98
You can use another table containing all the months to join with your existing data table and use an OUTER JOIN to show all the months in the result.
Thanks but it is not a table,it is a query that collects data from other queries.
 

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 22:16
Joined
Oct 29, 2018
Messages
18,962
Thanks but it is not a table,it is a query that collects data from other queries.
Either create a query to show all months or use a table.
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 13:16
Joined
May 7, 2009
Messages
16,393
see qryFinal.
 

Attachments

  • fleetwood.accdb
    464 KB · Views: 243

Users who are viewing this thread

Top Bottom