What is it you want to do with this variable?, do you want each record
marking with the variable or do you want the records moving to a sheet with
the variables name?, you need to give us a little more to go on.
--
Regards,
The Code Cage Team
www.thecodecage.com/forumz


"ttp" wrote:

I need assistance comparing a list of records. Within my file, there are
records with multiple records. I want to perform the following If
statements. But, I don't know how to arrange it in Excel or Access.

If all the items in a field (column) begin with CR,
then variable = "HQ"
If all the items in a field (column) begin with DR,
then variable = 'OC"
Else variable = "N/A"