Looking at the picture I can clearly see the problem.
Two options:
i) Normalise your database - this might mean going back to the start and designing it better. This is advantageous as it can prevent problems in the future and is advised.
ii) Don't normalise your database - this way you can do what you want but has the disadvantage that the data is stored messily, harder to calculate upon, and can waste space if some fields remain without data.
You may, however, not have time to perform the former option.
On your query, you have put the formula I initially suggested on the same row for each appointment which is saying:
Show me all appointments where App1 is equal to five days from now AND App2 is equal to five days from now AND App3 is equal to five days from now, etc
when what you want to use is the OR argument.
Show me all appointments where App1 is equal to five days from now OR App2 is equal to five days from now OR App3 is equal to five days from now, etc.
In your query builder grid there are numerouse rows for putting criteria - drop the criteria along your appointments so that it is stepped.
Appointment1 Appointment2 Appointment3
DateAdd(etc)..................................................
........................DateAdd(etc).......................
...............................................DateAdd(etc)