I have a query that I want to create a report from. With the query data for this report, how do I show data from a specific field from each record on one field/page in a report? i.e
property / listing #
123 Street 123456
456 Way 789101
I want a report that takes the listing # and shows all the listing #'s from the query on a single field/page so I can copy and paste them all at once to my browser.
If the listing number is always 6 digits you can create a new column and use the following formula
=RIGHT(A1,6)
and copy down. You can then copy and paste the resulting list of numbers.
If it is not always 6 digits, then can you describe the format rules?
Good question. The listing numbers are going to either be 6 or 7 digits. for example:
957226
1000420
998416
The property listings just turned over one more digit in the count of listings; so some of the older listings will be 6 digits and the most recent will be 7. Is the formula you provided still possible? Thanks for the input.
This will work
=TRIM(RIGHT(A1,7))
This assumes that:
- There is always at least one space before the number
- The number is always at the end of the string
- The number is always either 6 or 7 digits
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks