[clmowers]

Hello, I have a database that is used to input user nodes. This program can only use the node once. So if I have 1.520 on 1 computer i can never use that address again unless i remove the node from that computer. what i would like to do is have a button that when you click on it. It will run a query or something that will show just the last record in the database. I have 2 columns.Which are user and node. The Node column is the prim key.I have a query that display all records. I want that to show just the last record.Does anyone have any ideas. Thanks

 

[OBP]

Chris, see my email about Totals "Max" and a recordset on a Form.