Tracking spending by payee / matching data problem

  • Thread starter Russ via AccessMonster.com
  • Start date
R

Russ via AccessMonster.com

Ok, I figured out I can download my spending in a csv. file, but need to be
able to filter it out the payee field has too much information so that I can
append the information into my transactions table.

Payee field looks like this;
WALGREEN 00067033 L 10/14WALGREEN
But need to compare it against my payee Walgreen located in the table
payeename field so all I get is the; WALGREEN

How do I accomplish this, is it possible?
 
Top