simply macro IF then

[XX7]

Hi,

I naeed help about "simply" macro if in access.


For ex.

Table - X
Column - 1 and 2

I need setup macro that if in Column 2 = 0 then delete row.

This is my try

[pbaldy]

For the whole table? I would run a delete query with that criteria:

DELETE * FROM X
WHERE 2 = 0

[XX7]

Yes from the whole table.
Yeap query is second(first) option, but I try to get same result over the macro, so if some guru can help me.
Thx in advance.

[pbaldy]

Run the query from the macro. I don't know that you can loop the table's records from a macro, and even if you could it would be far less efficient than executing an update query.

[XX7]

I don't know, I am asking is it possible to do over macro?
If yes pls help.

[pbaldy]

I can't think of a way.

[XX7]

Good maybe some other can, because of that I setup this thread.
EOF or any other solution?
Thx in advance.