help

[Javrix]

Hi, I'm new to access. I created a table with lots of fields. I have about 10 fields I want to add together and display in another field. Example:

Field 1 = 1
Field 2 = 2
Field 3 = 5

Total = 7

I want the 3 fields to add together and the result displayed in the total field. I have made the form to enter info into the fields and everything, i just don't know how to add them. they're all in the same table. ~Steve

A broken clock is correct twice per day.

A roomful of monkeys on typwriters will eventually write the great american novel.

If you gave an infinate number of rednecks, an infinate number of shotguns to shoot at an infinate number of street signs, they'd eventually recreate all of Shakespears works in braile.

 

[ghubbell]

Hi Steve, Remember, in Access we don't want to store calculated values in tables but prefer to display the results in a field on a form.

Make a new empty text box on your form in design view. Double-click on it to pop up its "properties" dialog. Find the data tab. Then find the "Control Source" property. In its "field" type something like this:

=[NameofField1]+[NameofField2]+[NameofField3]

You can now change its "tag-along" label to read "Total:"

Flip the form in to form view and see if that's what you're after!

Gord
ghubbell@total.net

 

[Javrix]

Hey thanks! that got me a little further, but it doesn't work. i did exactly what you said, but it doesn't display anything. ~Steve

A broken clock is correct twice per day.

A roomful of monkeys on typwriters will eventually write the great american novel.

If you gave an infinate number of rednecks, an infinate number of shotguns to shoot at an infinate number of street signs, they'd eventually recreate all of Shakespears works in braile.

 

[ghubbell]

Do you have values in the fields? Did you correctly enter the field names? If in doubt, please post exactly what you entered. Gord
ghubbell@total.net

 

[Javrix]

Nope I got it. Thanks alot man! Hey, I have 2 more questions.

1) Is it possible to have a section in the form tell me when was the last time I modified the record.

and

2) Can I use an access database to post stuff on the web? I don't know VBscript or asp too well. I want to put it in my webspace (sql and access complient) and I'm wondering if from what I have on my access db, it will post the data from it to the web? is this total asp stuff? ~Steve

A broken clock is correct twice per day.

A roomful of monkeys on typwriters will eventually write the great american novel.

If you gave an infinate number of rednecks, an infinate number of shotguns to shoot at an infinate number of street signs, they'd eventually recreate all of Shakespears works in braile.

 

[ghubbell]

For question 1: sure. add a field to your table (date/time).
Add the field to your form somewhere (it can be invisible if you want)
in the Forms After update event (in Visual Basic), add something like:

Me![NameOfTheDateTimeField]=Now()

For question 2: Access 2000 can handle it although I have no experience with it (yet). Do a search on the whole site. I'm sure you'll find a decent answer! Gord
ghubbell@total.net