Hello,
I have a short text field called [license] in a table that is set to 13 characters; the total number of records in this table is 323,992. I wish to capture only data in [license] where the data in this field is equal to 13 characters. I have 5932 records where the value is listed as 0. I have an unknown number of records where the value is less than 13 characters. I have attempted to create group by query where Len([license]) query where the criteria is 13 and License is displayed, that returned the same number 303,979 records. This query did not produce favorable results I can clearly see the License string has less than 13 characters. Does anyone have any suggestions? I realize that I can manipulate the data in Excel Len function but I cannot export 323,992 records at once into Excel. :banghead:
I have a short text field called [license] in a table that is set to 13 characters; the total number of records in this table is 323,992. I wish to capture only data in [license] where the data in this field is equal to 13 characters. I have 5932 records where the value is listed as 0. I have an unknown number of records where the value is less than 13 characters. I have attempted to create group by query where Len([license]) query where the criteria is 13 and License is displayed, that returned the same number 303,979 records. This query did not produce favorable results I can clearly see the License string has less than 13 characters. Does anyone have any suggestions? I realize that I can manipulate the data in Excel Len function but I cannot export 323,992 records at once into Excel. :banghead: