How can I limit the number of records from a query.
A table has over 1000 entries but I would like to work with 50 at a time.
Thanks

I'm having trouble running a query in which i want to view outgoing Special
Events orders for the week. Some orders have corresponding order details and
others do not. For the orders that have corresponding details, the query
calculates the total number of items on that order.

i'm using following SQL stmts to select  rows from Table .
When moving the code to the bookmarks in a Word Document I don't see
anything appearing in my word doc.
Word opens the doc all right but then no data appears.

Last week data on people attending a class was entered for classes on 5/23,
5/24, 5/26 and 5/27.  The data is in the table.  The query will pull the
records for 5/23, 5/24 and 5/27 (by date), but not for 5/26.  The date
"looks" the same in the table, i.e, 5/24/2005, 5/26/2005 (it ...

I have two tables, with almost equal values except the entry for one field is
blank.
how do i update the blank values in one table and replace those said blanks
with the entry from the other table for the same record