We need some additional information if this query is being used as the data source for a data entry form. First of all, is your database a .adp file or a .mdb file? Second, if this is a .mdb file, are your tables linked using ODBC? Third, does your table have a primary key, and if so what field is it - ID or HID, and are either or both autonumber fields? Finally, are you displaying this on a continuous form or one record at a time? In theory if your table has a primary key, the ORDER BY clause won't prevent you from adding new records.