Tomasz
|
| Posted: 04/17/2003, 8:58 AM |
|
as in topic.
I have record form which is needed only to edit one, first record from one table. How to display this record in record form without passing any param, just after entering page?
|
|
|
 |
hamilton
|
| Posted: 04/25/2003, 8:04 AM |
|
Each record may need to have a date_added field
set the default value for the field to Now() [for ms access] or GetDate() [for SQL Server].
Select TOP 1 From table_name order by date_added asc
OR
Select TOP 1 From table_name order by date_added desc
|
|
|
|
|
