Adding extra field to DB results at display time

[Martin Stabrey]

I'm displaying the results of from an input form that writes to an Access
DB.
What I'm wanting to achieve is to add an extra display field which shows the
date that the user completed their form input. I'm obviously wanting to do
this automatically (instead of the user having to enter the date in an extra
input field!), but I'm not sure where (DB or Frontpage) or how. Any help
appreciated.

Tx

Mart

 

[Bob Lehmann]

Add a column with a default value of Date() - I think that's what Access
uses - to the table. The user won't have to enter anything.

Bob Lehmann

 

[Martin Stabrey]

Thanks Bob. Sorry, I'm completely raw at this - do I do that in Fp or
Access? Where do I enter this value as a default.

Mart

 

[Martin Stabrey]

Bob - got it! Thanks again, you've been very helpful.

Mart