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

mansied

Member
Local time
Today, 01:12
Joined
Oct 15, 2020
Messages
99
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: 250

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 22:12
Joined
Oct 29, 2018
Messages
21,322
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:12
Joined
Oct 15, 2020
Messages
99
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:12
Joined
Oct 29, 2018
Messages
21,322
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:12
Joined
May 7, 2009
Messages
19,094
see qryFinal.
 

Attachments

  • fleetwood.accdb
    464 KB · Views: 286

Users who are viewing this thread

Top Bottom