I have a query that I think may be too much for access to handle (unlikely) or is poorly designed and causing Access to work too hard to find the information (most likely).</SPAN>
The 2 tables involved with this query are tblAlphaList and tblSchedule</SPAN>
What I want the query to do is do some date math and see if there are any appointments that fall on that day. (all this data is in the tblSchedule) and then link them with an individual by their SSN.</SPAN>
The way it is set up now is there are 31 daily queries (qrySchedule01-31) to see if any appointments are “due” that day and one massive query that does the linking.</SPAN>
Appt1: [qryScheduleDay01]![Apptcomment]</SPAN>
through</SPAN>
Appt31: [qryScheduleDay31]![Apptcomment]</SPAN>
When this is run for the 7 and 14 day reports, the data is displayed (albeit somewhat slowly) but when I added more data to take it out to 31 days Access locks up. Is there a better/faster way to perform these calculations?
</SPAN></SPAN>
The 2 tables involved with this query are tblAlphaList and tblSchedule</SPAN>
What I want the query to do is do some date math and see if there are any appointments that fall on that day. (all this data is in the tblSchedule) and then link them with an individual by their SSN.</SPAN>
The way it is set up now is there are 31 daily queries (qrySchedule01-31) to see if any appointments are “due” that day and one massive query that does the linking.</SPAN>
Appt1: [qryScheduleDay01]![Apptcomment]</SPAN>
through</SPAN>
Appt31: [qryScheduleDay31]![Apptcomment]</SPAN>
When this is run for the 7 and 14 day reports, the data is displayed (albeit somewhat slowly) but when I added more data to take it out to 31 days Access locks up. Is there a better/faster way to perform these calculations?
</SPAN></SPAN>