I have a field called CertNum. Presently it has 243 numbers (records along with related data) starting with number 2050. I want to be able to return the "CertNums" and related table data for a range of numbers - ie I want prompts for a begining number and an ending number and return say numbers from 2075 thru and including 2175, again with related data. I have tried Between [First Number:] And [Second Number:] as criteria for my query. I am prompted correctly but I do not get the expected return. (When I enter 2050 through 2070 I get 2050 through 2053 and that is it; when I start with any number other than 2050 it returns nothing). CertNum is a generated number of Long Intiger type. (CertNum is generated by: =DMax("CertNum","Brick Info")+1 being placed as the default value in the data input form).