Update query

[rlf1957]

I have an update query that advances the status of a record from "N" (new) to "P" (printed). The standard verification boxes come up to allow me to avoid updating.
#1 "You are about to run an Update Query - Continue ? Y/N"
or something like that ....

#2 "You are about to update ## Rows, if you answer "Y"es you cannot use the "Undo" command to reverse the update.
Continue ? Y/N"

If I answer #1 with "Y" and #2 with "N" the update still processes and the Undo menu bar button isn't accessible and the "EDIT/Undo" command isn't either.

Shouldn't one of these be useable if I answered "N" to the message box?

Thanks for any assistance.

 

[JeffTullin]

I have serious doubts about :
"If I answer .. #2 with "N" the update still processes.. "

I strongly suspect that it did not actually update the file. Otherwise why ask the question?

It does not say 'if you answer YES you won't be able to undo, but hey - you WILL if you answer No..'

It just asks if you want to continue.

 

[rlf1957]

Just getting back to this --
Here are the msgs word for word.
First Message:
"YOU ABOUT TO RUN AN UPDATE QUERY THAT WILL MODIFY YOUR TABLE. ARE YOU SURE YOU WANT TO RUN THIS TYPE OF QUERY?"
Answer "NO" goes back to switchboard. (No Problem)
Answer "YES" results in another break message (see below)
I do this to see how many records will be updated, for control purposes.
Second Message:
"YOU ARE ABOUT TO UPDATE nn ROW(S). ONCE YOU CLICK 'YES' YOU CAN'T USE THE UNDO COMMAND TO REVERSE CHANGES, ARE YOU SURE YOU WANT TO UPDATE THE RECORDS?"
Answer "YES" - Records are Updated, Returns to switchboard.
Answer "NO" - Records are Updated also, Returns swtchboard

Answering "NO" should return without updating records should it not?

Sorry for the repeat of the original question, but I don't think I communicated it properly the first time.

Thanks
RickF

 

[rlf1957]

Running totals column in a query? Is it possible to display a column in a query that contains a running total
of the dollar amount shown in that line ?
ie. Inv# InvDte InvAmt Total Select
1 010104 $100 $100 X
2 010104 $ 50 $100
3 020104 $ 75 $175 X

To take that one step further, would like to randomly select only certain lines displayed (using chkbox maybe?)
to actually include in the totals column.

thanks for any guidance
RLF1957

 

[PHV]

rlf1957, please start a new thread as your last post is totally unrelated to the subject.