Having trouble with a macro

[Guest]

Hi there,
This is probably a piece of cake for most of you out here, but I'm
relatively new to Access. I'm trying to create a macro or query that will
automatically copy and paste certain fields into a different table if a box
is checked. I'm much more used to Excel, where you can use the IF statement
to do all sorts of things, but the Iif in Access doesn't work the same way.
In any case, any help is appreciated! Chris

 

[Rick B]

You would typically not do this in Access.

That would be redundant to store the data in both places.

If you want to see all the data with that field checked, you'd simply
include that criteria in a query.

Tell us what you are trying to accomplish.

Rick B