Too many queries fail for obscure reasons. E.g., a crosstab that has a subquery somewhere in it. I bet there are already open defect on a lot of these issues from the JET days. Work them! Limitations like the 32 table limitation occasionally get in the way as well.
(Again hating to spend votes on defects, but it is what it is.)4 votes
Modify query designer to automatically make the appropriate change to all join lines when setting Inner/Left/Right on any join.4 votes
Why not enableing the user to select "selected" columns / rows via Query - always looping thru itemselected is not very easy and intuitive.
Similar is with queries about Tables, queries, forms, reports, indizes fields (like in combobox) and Macros and all the other collections.3 votes
for me it would be very useful to be able to search queries by date or part of the name1 vote
- Don't see your idea?