MS Access SQL

[akins4lyfe]

hi

I am new to Access SQL query.

I have a table with the following fields & data types.

Fields Datatype
ReadDate Text
Micro-Business Boolean or Yes/No

I'd like to design a query to update some data within this table, based on the following scenario:

"Update Micro-Business rows, WHERE ReadDate is BGMR,MMRR or MCRG"

1.What type of action query is required. (im guessing an update query, not sure)
2.What criteria is required, for accurate result.

Pls assist, with helpful tips.

Thank you.

 

[SkipVought]

hi,

WOW! What a confusing field name, a misnomer of sorts, that is not ANYTHING what it seems.

You really ought to post Access SQL question in a forum like forum701. This is a VBA forum, that addresses mostly MS applications other than Access.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}