I have a query that is a table joined with another query of our company database. The query of our company database is actually a 'final query' joined together from 5 queries of the company database. There are a number of left() and trim() functions used in these queries.
The query that is joined with the table can be run, but crashes when I try to sort it using the drop-down boxes in datasheet view. The 'final query' can be run and sorted without issue. All of these queries were made using the Access query builder.
Does this problem sound familiar? Where should I look for the trouble?
The query that is joined with the table can be run, but crashes when I try to sort it using the drop-down boxes in datasheet view. The 'final query' can be run and sorted without issue. All of these queries were made using the Access query builder.
Does this problem sound familiar? Where should I look for the trouble?
