I have what is probably a simple thing to do in a qry but I just can't figure it out.
I have a spreadsheet that I imported into access. The basis of this spreadsheet is just basic company info.
Company|Address|City|State|Zip|Name
AAA Comp|123 Street|Anywhere|CA|90210|Mr. Somebody
ABC Comp|345...