Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. csmajor1

    Separating data in a field?

    Thanks so much kskid. I finally figured it out and your example was very helpful. Keep up the good work. Happy Memorial Day!!!!
  2. csmajor1

    Separating data in a field?

    Thanks for responding. The state is only 2 characters from the right here is what mine looks like and I am still getting errors: =If IsNull(<Addr Line 3>) Then <Addr Line 2> Else Right(<Addr Line 3> ,2) Both Addr Line 3 and Addr Line 2 contain the same thing. (ex. city state) Also, how about...
  3. csmajor1

    Separating data in a field?

    Currently, I have a record field that contains both a city and a state. I am trying to grab the data that is currently in the one record and have a individual city record and then an individual state record. The problem is: there are city's that contain more than one word (ex. New York NY)...

Part and Inventory Search

Back
Top