I want to run a query that will show me the last record added or modified ....is there a fuction that will do this .....TIA

If you have a LastUpdateDt field in the table, you can use the Max() function to find the most recently adde/modified row. If your application does not maintain such a field in the table, you're out of luck.