Why is my SELECT too complex? 1

[1DMF]

Access is erroring saying "Query to complex", why is this too complex

SELECT mytable.* FROM myTable WHERE Rec_ID = 6959 OR Rec_ID = 6960 OR Rec_ID = 6961 OR Rec_ID = 6962 OR Rec_ID = 7427 OR Rec_ID = 7487 OR Rec_ID = 7895 OR Rec_ID = 7939 OR Rec_ID = 7943 OR Rec_ID = 8459 OR Rec_ID = 7051 OR Rec_ID = 7412 OR Rec_ID = 8190 OR Rec_ID = 9481 OR Rec_ID = 10018 OR Rec_ID = 10019 OR Rec_ID = 7080 OR Rec_ID = 7378 OR Rec_ID = 8698 OR Rec_ID = 8820 OR Rec_ID = 6855 OR Rec_ID = 6856 OR Rec_ID = 6878 OR Rec_ID = 6879 OR Rec_ID = 7386 OR Rec_ID = 8999 OR Rec_ID = 9000 OR Rec_ID = 9035 OR Rec_ID = 9092 OR Rec_ID = 6862 OR Rec_ID = 6863 OR Rec_ID = 6864 OR Rec_ID = 6865 OR Rec_ID = 6866 OR Rec_ID = 6867 OR Rec_ID = 7019 OR Rec_ID = 7020 OR Rec_ID = 7372 OR Rec_ID = 7409 OR Rec_ID = 7527 OR Rec_ID = 7602 OR Rec_ID = 7690 OR Rec_ID = 7762 OR Rec_ID = 7792 OR Rec_ID = 7793 OR Rec_ID = 7800 OR Rec_ID = 7893 OR Rec_ID = 7905 OR Rec_ID = 8285 OR Rec_ID = 6921 OR Rec_ID = 6922 OR Rec_ID = 6923 OR Rec_ID = 6924 OR Rec_ID = 8178 OR Rec_ID = 8364 OR Rec_ID = 8388 OR Rec_I
D = 8414 OR Rec_ID = 8727 OR Rec_ID = 8728 OR Rec_ID = 9009 OR Rec_ID = 9403 OR Rec_ID = 9761 OR Rec_ID = 10011 OR Rec_ID = 10205 OR Rec_ID = 8237 OR Rec_ID = 8438 OR Rec_ID = 8669 OR Rec_ID = 9519 OR Rec_ID = 9601 OR Rec_ID = 9919 OR Rec_ID = 6967 OR Rec_ID = 9014 OR Rec_ID = 9395 OR Rec_ID = 10114 OR Rec_ID = 7001 OR Rec_ID = 7465 OR Rec_ID = 8700 OR Rec_ID = 8939 OR Rec_ID = 9095 OR Rec_ID = 9205 OR Rec_ID = 9206 OR Rec_ID = 9211 OR Rec_ID = 9339 OR Rec_ID = 9932 OR Rec_ID = 10166 OR Rec_ID = 6979 OR Rec_ID = 6980 OR Rec_ID = 6991 OR Rec_ID = 6992 OR Rec_ID = 6993 OR Rec_ID = 6994 OR Rec_ID = 6995 OR Rec_ID = 6996 OR Rec_ID = 6997 OR Rec_ID = 7326 OR Rec_ID = 7441 OR Rec_ID = 7443 OR Rec_ID = 7449 OR Rec_ID = 7450 OR Rec_ID = 7901 OR Rec_ID = 7916 OR Rec_ID = 7923 OR Rec_ID = 8471 OR Rec_ID = 8494 OR Rec_ID = 8884 OR Rec_ID = 8899 OR Rec_ID = 8927 OR Rec_ID = 9007 OR Rec_ID = 9040 OR Rec_ID = 9556 OR Rec_ID = 9837 OR Rec_ID = 9845 OR Rec_ID = 6885 OR Rec_ID = 6886 OR Rec_ID = 7468 OR Rec_ID = 7846 OR Rec_
ID = 7924 OR Rec_ID = 7957 OR Rec_ID = 8189 OR Rec_ID = 8470 OR Rec_ID = 8524 OR Rec_ID = 8543 OR Rec_ID = 8624 OR Rec_ID = 9562 OR Rec_ID = 9647 OR Rec_ID = 9937 OR Rec_ID = 10264 OR Rec_ID = 7305 OR Rec_ID = 7475 OR Rec_ID = 7548 OR Rec_ID = 7917 OR Rec_ID = 8948 OR Rec_ID = 9164 OR Rec_ID = 9468 OR Rec_ID = 9572 OR Rec_ID = 7307 OR Rec_ID = 7308 OR Rec_ID = 7421 OR Rec_ID = 7716 OR Rec_ID = 9070 OR Rec_ID = 9648 OR Rec_ID = 8734 OR Rec_ID = 8375 OR Rec_ID = 9162 OR Rec_ID = 9163 OR Rec_ID = 7877 OR Rec_ID = 7950 OR Rec_ID = 7966 OR Rec_ID = 8280 OR Rec_ID = 8335 OR Rec_ID = 9911 OR Rec_ID = 7309 OR Rec_ID = 7311 OR Rec_ID = 7314 OR Rec_ID = 7315 OR Rec_ID = 7316 OR Rec_ID = 7375 OR Rec_ID = 7376 OR Rec_ID = 7584 OR Rec_ID = 7585 OR Rec_ID = 7587 OR Rec_ID = 7588 OR Rec_ID = 8186 OR Rec_ID = 8244 OR Rec_ID = 8246 OR Rec_ID = 8249 OR Rec_ID = 8482 OR Rec_ID = 8768 OR Rec_ID = 9151 OR Rec_ID = 9157 OR Rec_ID = 9698 OR Rec_ID = 9699 OR Rec_ID = 9700 OR Rec_ID = 9706 OR Rec_ID = 9999 OR Rec_ID = 10001 OR Rec_I
D = 10002 OR Rec_ID = 10003 OR Rec_ID = 10004 OR Rec_ID = 10006 OR Rec_ID = 7073 OR Rec_ID = 7856 OR Rec_ID = 8067 OR Rec_ID = 9062 OR Rec_ID = 9435 OR Rec_ID = 9799 OR Rec_ID = 9800 OR Rec_ID = 10088 OR Rec_ID = 10225 OR Rec_ID = 8687 OR Rec_ID = 9039 OR Rec_ID = 7463 OR Rec_ID = 8462 OR Rec_ID = 8582 OR Rec_ID = 9272 OR Rec_ID = 9834 OR Rec_ID = 7567 OR Rec_ID = 7568 OR Rec_ID = 8003 OR Rec_ID = 8707 OR Rec_ID = 8710 OR Rec_ID = 9073 OR Rec_ID = 8023 OR Rec_ID = 8024 OR Rec_ID = 8025 OR Rec_ID = 8028 OR Rec_ID = 8030 OR Rec_ID = 8031 OR Rec_ID = 8618 OR Rec_ID = 7557 OR Rec_ID = 6791 OR Rec_ID = 6898 OR Rec_ID = 6899 OR Rec_ID = 6900 OR Rec_ID = 6901 OR Rec_ID = 6902 OR Rec_ID = 6903 OR Rec_ID = 6904 OR Rec_ID = 6911 OR Rec_ID = 7385 OR Rec_ID = 7436 OR Rec_ID = 7446 OR Rec_ID = 7529 OR Rec_ID = 7681 OR Rec_ID = 7803 OR Rec_ID = 7857 OR Rec_ID = 7861 OR Rec_ID = 8278 OR Rec_ID = 8281 OR Rec_ID = 8291 OR Rec_ID = 8332 OR Rec_ID = 8465 OR Rec_ID = 8472 OR Rec_ID = 8580 OR Rec_ID = 8638 OR Rec_ID = 8748 OR Re
c_ID = 8938 OR Rec_ID = 9041 OR Rec_ID = 9245 OR Rec_ID = 9411 OR Rec_ID = 9473 OR Rec_ID = 9482 OR Rec_ID = 9538 OR Rec_ID = 9913 OR Rec_ID = 10195 OR Rec_ID = 6987 OR Rec_ID = 6988 OR Rec_ID = 7651 OR Rec_ID = 8478 OR Rec_ID = 6871 OR Rec_ID = 7928 OR Rec_ID = 7071 OR Rec_ID = 7484 OR Rec_ID = 7968 OR Rec_ID = 9765 OR Rec_ID = 7016 OR Rec_ID = 7017 OR Rec_ID = 7618 OR Rec_ID = 6857 OR Rec_ID = 6917 OR Rec_ID = 6891 OR Rec_ID = 7532 OR Rec_ID = 7852 OR Rec_ID = 8317 OR Rec_ID = 8541 OR Rec_ID = 7437 OR Rec_ID = 8503 OR Rec_ID = 8507 OR Rec_ID = 7888 OR Rec_ID = 7913 OR Rec_ID = 8342 OR Rec_ID = 8390 OR Rec_ID = 9312 OR Rec_ID = 9520 OR Rec_ID = 9914 OR Rec_ID = 6972 OR Rec_ID = 7736 OR Rec_ID = 8176 OR Rec_ID = 8177 OR Rec_ID = 6859 OR Rec_ID = 6860 OR Rec_ID = 7007 OR Rec_ID = 7301 OR Rec_ID = 7550 OR Rec_ID = 9853 OR Rec_ID = 9731 OR Rec_ID = 9733 OR Rec_ID = 10037 OR Rec_ID = 7334 OR Rec_ID = 7929 OR Rec_ID = 8596 OR Rec_ID = 9512 OR Rec_ID = 9513 OR Rec_ID = 6774 OR Rec_ID = 6942 OR Rec_ID = 8180 OR Rec
_ID = 8201 OR Rec_ID = 8552 OR Rec_ID = 8553 OR Rec_ID = 8602 OR Rec_ID = 8642 OR Rec_ID = 9148 OR Rec_ID = 6934 OR Rec_ID = 6935 OR Rec_ID = 6938 OR Rec_ID = 7341 OR Rec_ID = 7471 OR Rec_ID = 9850 OR Rec_ID = 7530 OR Rec_ID = 9483 OR Rec_ID = 6869 OR Rec_ID = 7040 OR Rec_ID = 6881 OR Rec_ID = 6882 OR Rec_ID = 7730 OR Rec_ID = 8033 OR Rec_ID = 8453 OR Rec_ID = 7067 OR Rec_ID = 7577 OR Rec_ID = 8311 OR Rec_ID = 8312 OR Rec_ID = 8558 OR Rec_ID = 6861 OR Rec_ID = 7015 OR Rec_ID = 7644 OR Rec_ID = 7931 OR Rec_ID = 8102 OR Rec_ID = 8489 OR Rec_ID = 8519 OR Rec_ID = 9471 OR Rec_ID = 9490 OR Rec_ID = 9549 OR Rec_ID = 10263 OR Rec_ID = 9480 OR Rec_ID = 9810 OR Rec_ID = 10039 OR Rec_ID = 7853 OR Rec_ID = 7854 OR Rec_ID = 7855 OR Rec_ID = 7947 OR Rec_ID = 9581 OR Rec_ID = 8447 OR Rec_ID = 8704 OR Rec_ID = 9792 OR Rec_ID = 9865 OR Rec_ID = 8502 OR Rec_ID = 8702 OR Rec_ID = 9386 OR Rec_ID = 9448 OR Rec_ID = 10012 OR Rec_ID = 10191 OR Rec_ID = 10100 OR Rec_ID = 10232 OR Rec_ID = 9712 OR Rec_ID = 9936 OR Rec_ID = 10008 OR
Rec_ID = 10206 OR Rec_ID = 10210 OR Rec_ID = 10250 OR Rec_ID = 10219 OR Rec_ID = 10215 OR Rec_ID = 9271 OR Rec_ID = 10258 OR Rec_ID = 9438 OR Rec_ID = 9523 OR Rec_ID = 9982 OR Rec_ID = 9886 OR Rec_ID = 9977 OR Rec_ID = 9978 OR Rec_ID = 9991 OR Rec_ID = 9992 OR Rec_ID = 9993 OR Rec_ID = 10043 OR Rec_ID = 10044 OR Rec_ID = 10045 OR Rec_ID = 10227 OR Rec_ID = 10229 OR Rec_ID = 0

Is there a length limit on the WHERE clause or a limit on the number of OR operators you can use?

"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!

 

[PHV]

I'd use a WHERE clause like this:
WHERE Rec_ID In (6959,6960,...,10229,0)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[1DMF]

You're a genius, works a treat, thank you so much!

Have a great weekend.

"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!