Date time Stamp

I'm developing an application in Access 2000. I need two fields one with date and one with time. These fields our to supposed date time stamp the transaction. What would be the easiest way to do this in access 2000.

Please hellp me

Thanks

Ken

well i don't know if this is the best/efficient way to do it, I'm still learning VB...

if you're using DAO to access your database, this is what I do to add the date and time, assuming rs is your recordset and date and time is your fields in the table

Code:

---

with rs
  .Add
  ![Date] = Date
  ![Time] = Time
  .Update
  .Bookmark = .LastModified
end with

---

the date and time functions return the current system's date and time respectively

then you can use the format function to get the desired format

hope this helps :)

[Edited by gin on 11-16-2000 at 09:50 AM]