Assign values in a random order

[Guest]

I have a pretty large database, I need to assign a value to new filed like
"A" and "B" in a random order. If I can assign alternate also is fine.

 

[Guest]

If numbers would be OK instead, you could use an autonumber field and change
the default of increment to random.

 

[Dirk Goldgar]

I have a pretty large database, I need to assign a value to new filed
like "A" and "B" in a random order. If I can assign alternate also is
fine.

You could use an update query along these lines:

UPDATE YourTable
SET [AorBField] =
IIf(Rnd(IsNull([AorBField])+2) Mod 2=0,"A", "B");

For "YourTable", substitute the name of the table to be updated. For
"AorBField", substitute the name of the field you want to receive the
value "A" or "B". This field must already have been created in the
table design.

Note that, as written, this won't be completely random, as you won't
have executed the VBA Randomize statement to seed the random-number
generator. But from your description, this should be random enough.