Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
"Can't open any more databases"
Actually, you are right. I've recreated them as Tables, and it works immediately. They were selection queries, based on a union query, based on a set of six selection queries, each involving five tables... I easily passed the 32 mark. Leaves me wondering why the error message was in Dutch...- MJSmit
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
"Can't open any more databases"
I get the error message "Can't open any more databases" when I run the following query: SELECT qIndProgJUN03.Code, Sum(qIndProgJUN03.MaxOfIndValue) AS JUN03, Sum(qIndProgDEC03.MaxOfIndValue) AS DEC03 FROM qIndProgJUN03 INNER JOIN qIndProgDEC03 ON qIndProgJUN03.Code = qIndProgDEC03.Code GROUP BY...- MJSmit
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
-
Nesting multiple instances of one table
I have a query that contains records for each time a project (identified by JournalID) in a given period (e.g. DEC02, which has number 7 in a field called 'Sorting') reports on the progress of a given indicator (identified by IndType and ID). Similar indicators across different Projects share...- MJSmit
- Thread
- Replies: 1
- Forum: Microsoft: Access Queries and JET SQL
