MS Access Programming help: Advice needed

polkatese

Any guru on MS Access programming here?

I need to create a procedure to store a running total of integer values to a temp table or a declared table, based on an assigned value to a row/record stored in a different table.

For instance, I have a table with descriptions, check mark, and assigned value column. If I select the check mark for that particular row/record, I like to start a counter to add that value. Let's say there are 10 rows of entry and I checked 6 lines of these rows. I like to have a running total of the assigned values related to these rows. The means to do the calc is to create a button click trigger, and perhaps display the total in a separate form.

Can anyone point me to a sample procedure to achieve this objective? Or better yet, have done it themselves?

Thanks in advance for your feedback.

Sami

Add the event and I think the SQL query should look something like this:

SELECT SUM(assigned_value) FROM table WHERE checked = True

nspindel

correct.

polkatese

Thanks, guys. On Yes/No argument, what's the proper syntax to say if Yes/No = true, THEN...

sorry for the novice question...

nspindel

not getting your question....

tcrossma

Yes, for a Yes/No field you query as "=True" or "=False"

polkatese

thanks, let me try it.

Sami

Yep. Description is type String, check is Boolean and value is Int32.