MACRO COMMANDS THAT MODIFY FIELD DATA

  • Thread starter Thread starter Gilberto Lawas via AccessMonster.com
  • Start date Start date
G

Gilberto Lawas via AccessMonster.com

Can anyone Tell me what command to use to make a Macro Change a field value?

In this case I want to change a Yes/No field to say Yes.

The Query name that the records are coming from is Processed. The field
name is also [Processed].

My objective is to have the macro select all the records that have not been
processed by way of the Processed Macro...

SELECT Main.*
FROM Main
WHERE (((Main.Processed)<>Yes));

Then to change the field to say Yes.

r/s
clueless
 
Good Plan, and it worked.

Thanx for the insight.

Much appreciated.
 
Back
Top