I'm trying to put more than one table into a query. The first table has 55 fields. When I put only that table into the query, the wuery returns all 55 fields. As soon as I add a second table, even before I've entered any fields from that table into the query, the query stops returning results.
According to what I've been able to find on the Internet, an Access 2007 query can have up to 32 tables and 255 fields. I have two tables and 55 fields. Does anybody know what the problem here might be?
Thanks in advance for your help.