My database allows the user to enter "Reason for visit" and "Next Visit" up to 3 times each. A client can be seen for more than one reason. The next visit must be associated with the reason for visit:
Reason for Visit 1
Next Visit 1
Reason for Visit 2
Next Visit 2
Reason for Visit 3
Next Visit 3
Is there a way to take all of this and combine it some way so that I can query a "month" for next visit and anyone needing to be seen that month will display.