Results 1 to 2 of 2

Thread: Stumped

  1. #1
    Join Date
    Jan 2012
    Posts
    1

    Unanswered: Stumped

    I have a report that I've been running for years to pull revenues by county. We've started loading new physicians with their 9 digit zip codes. When I run my reports now those with the 9 digit are not pulling county information. So I wrote a formula to (select left 5) of the physician zip table. This worked fine and pulled the 5 digit zip, however when I tried pulling the county information from another table the only ones that pulled were those that were 5 digits to begin with, even though the new data set from the formula I built is all 5 digit codes.

    I'm stumped on what else to do

  2. #2
    Join Date
    Oct 2010
    Posts
    46
    With no actual report to review the issue, I would have at this time to look at the data type of the 5 and 9 digit zip, test for the length of the variables etc to ensure it allows you to pull the records by evaluating 5 digit zip codes.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •