Search results for query: *

Thanks! I'll give this a shot. We usually to bring everything in as text if we can. Sometimes, it doesn't always work, but that's another issue. Will this handle other instances like 0012 and 0001 as well? Thanks again, T

All, At work, we run audits in Access on Class V switch records that are sent to us in .txt files and daily we encounter files that contain between 300,000 and 1 million records. Since the telephone numbers are stored as Numbers and not Text some TNs don't have all their zeros. For example, TN...

Well, you're right. The table idea doesn't work. Now that I have the list of TNs that don't have a TN preceding them, how should I generate the ranges from numbers that do exist? Thanks again, Tal

Hey, thanks for the input guys. Jerry's first response definitely got me farther than I was. Once I got the results, I figured if I subtracted two from every TN except the first one, the result would give me the TNs I needed for the ranges. Then my next thought is to export both columns out...

Folks, I've been using Access for a week and my first project is to query 60,000 telephone numbers and create ranges when there are gaps in the sequence. For example, TNs 555-123-0000 through 555-123-1000 may be missing a number and so should wind up like this in a new table...