Newbie Questions

[MeredithPfeiffer]

I am very new to Access, I have taken a few classes and have a few books, but I still need help.

I have a very basic form:

Is there anyway to have the current date populate the date field?

Also, I have a few fields that have different amounts, is there a way to have them add/subtract and total in another field?

I don't know if any of this makes sense or if the are incredibly simple questions, but I would appreciate any help I can get!

Thanks

 

[rjoubert]

For the current date, add a textbox control, and set the control source property to...
= Date()

For the calculations, add a textbox control, and set the control source property to...
= [Field1] + [Field2]

Replace Field1 and Field2 with whatever form fields (must be numeric) you want to add together.

 

[mp9]

For current date and time, should that be required, use =Now()

http://www22.brinkster.com/accessory/

 

[rjoubert]

Now() will display the time stamp as well. Date() only displays the date portion.

 

[MeredithPfeiffer]

That helped alot, thank you. I have one more question:

I want the date field to automatically fill in with the date that the info was added so I can look back and see when the form was updated.....How would I do that?

 

[Golom]

Go into Design View for the table, click on the field (it must be a Date/Time field) and type "Now()" (without the quotes) as the Default Value.