S sha7jpm Registered User. Local time Today, 22:21 Joined Aug 16, 2002 Messages 205 Sep 2, 2002 #1 anyone know of a way to increase the amount of criteria allowed in a query, the max seems to be 9. and I need about 25!!! ta John
anyone know of a way to increase the amount of criteria allowed in a query, the max seems to be 9. and I need about 25!!! ta John
Graham T Registered User. Local time Today, 22:21 Joined Mar 14, 2001 Messages 300 Sep 2, 2002 #2 John I don't know weather there is a maximum number of criteria but you can add rows to the criteria section of the query design. If you click in the criteria grid then go to Insert >> Rows , this will allow additional rows to be added. HTH Graham
John I don't know weather there is a maximum number of criteria but you can add rows to the criteria section of the query design. If you click in the criteria grid then go to Insert >> Rows , this will allow additional rows to be added. HTH Graham
S sha7jpm Registered User. Local time Today, 22:21 Joined Aug 16, 2002 Messages 205 Sep 2, 2002 #3 doh! how painstakingly obvious! many thanks, that solves my problem. cheers John