please help....increment a value

[Guest]

i appologize for the repost, but i am having trouble getting help with my problem...here it is...

My organization performs tests. Each test has a row and a plate number. this is what i want to occur

1 user enters first test: field1 - row, value =
field2 - plate, value =1, or what ever, could be 130,44 or 2
2 user clicks next tes
3 values for step 1 are saved to the table
4.the plate field is incremented by 1, say from 44 to 45, where 45 is the default value for the next test and is visible on the form so the user does not have to type it in

I have tried several things, including maxvalue, but this doesn't work because it goes to the maximum value entered then adds one. this isn't correct because i just want the value to be incremented, not unique

Can anyone help me

thank you in advanc

carlee

 

[Larry Linson]

I believe I replied to your other question... in a different newsgroup...
asking you for more detail.

"Maxvalue"? Do you mean DMax? If you give it the proper Criteria -- that is
Test and Row , it will give you the maximum for this particular Test and Row
(use a Query, not the Table itself).

But, it'll help, as I requested before, if you'll describe the data and how
it is stored, not just the user input and not just the form.

Larry Linson
Microsoft Access MVP

i appologize for the repost, but i am having trouble getting help with my problem...here it is....

My organization performs tests. Each test has a row and a plate number. this is what i want to occur:

1 user enters first test: field1 - row, value = 1
field2 - plate, value =1, or what ever, could be 130,44 or 23
2 user clicks next test
3 values for step 1 are saved to the table.
4.the plate field is incremented by 1, say from 44 to 45, where 45 is the

default value for the next test and is visible on the form so the user does
not have to type it in.

I have tried several things, including maxvalue, but this doesn't work

because it goes to the maximum value entered then adds one. this isn't
correct because i just want the value to be incremented, not unique.

 

[Guest]

Hi there

thank you so much for helping, or starting to....i played with this over the evening and i got it working
many thanks again

Carlee