Thank you for taking the time to report an issue.
What's wrong... Please write below.
There may be the time where you want to restrict your users to using only a certain amount of characters when using a text field. You can set the field size when designing the table and limit the amount of characters allowed, however it would be nice to inform the user of how many characters they have used when they are entering data.
The ID must contain 7 characters in the following Format.
* Characters 1-3 = "LTS"
* Characters 4-5 = Starts at "AA", then when 6-7 reaches 99 changes to "AB" and so on.
* Characters 6-7 = Starts at "00" or "10" (Doesn't matter), and rolls through to "99" before reseting to it's start point, as well as change characters 4-5 to the next in the sequence.
We already use this method but on paper and a looking to move to an electronic system,
I have column called ID, which has about 700,000 records and each ID can be anywhere from 7 to 10 characters; however, I all IDs to have only 7 characters and this means removing characters that are greater than 7. For example, smith09 is fine, but smith09990 would need to reduced to smith09. Basically, I need an expression that will check every ID and, if ID 7 characters, use the left function to cut it to 7 characters.
There are over 700,000 records in this table:
I need a query break up the records in this text field to a max of, say 30 characters.
This means that if a record is 100 characters long, the query will put the first 30 characters (preferably up to the last space before the 30th character), then the next 30 characters will be on the next record and then the remaining in the next record.
So in this case, 1 single record in the table results in 3 returned record in the query.
The fields I am trying to do the join in, it's kinda difficult. In the data warehouse, the field, say ID, represents 10 characters, including spaces. it's always 10, though.
The value could be 1234568, 123456, or 1234567890. If there are only 5 characters, the other 5 characters are blank spaces.
The table I am entering the data into, in my database, the values are not led off with blanks. We input 1234568, and it is only 7 characters.
How can I make the two fields recognize eachother based on the Right characters. I never know how many "actual"