Good evening to you all.
I have a problem I need help on. There is a field I am trying to add a leading zeroes to a fix set of numbers. I already combines the fields through a conversion query as such Field3: Table1.[Field1] & " " & [field2].
Field 1 = 112 Field 2 = 56843312
16 9745231.A
235 3462367
I want these two combined fields (Field 1 and Field 2) to look like in Field 3:
112 56843312 112 56843312
016 09745231.A and not 16 9745231.A
235 03462367 235 3462367
All data should have a single space between and should align towards the left. Any help is appreciate it. The data is from an Excel file that contains "Field1" and "Field2" that do not contain zeros when downloaded from a certain online program. Then I import these numbers from an access database file to format before downloading that data into another a main access database file. I know there is a way to add leading zeroes through excel itself before I export them from the first access file. I want to know how I can add zeros to the data while it's in the main database file.
There is a conversion query in the main access file that converts headers from a the downloaded data from the online website to the new headers in the main access database file.
Can there be a formula I need to place during the conversion query or do I need to place the formula somewhere else? Once the data passes thru the conversion, it goes to a set of duplicate queries before settling down to a main table.
Help is much appreciate it.
I have a problem I need help on. There is a field I am trying to add a leading zeroes to a fix set of numbers. I already combines the fields through a conversion query as such Field3: Table1.[Field1] & " " & [field2].
Field 1 = 112 Field 2 = 56843312
16 9745231.A
235 3462367
I want these two combined fields (Field 1 and Field 2) to look like in Field 3:
112 56843312 112 56843312
016 09745231.A and not 16 9745231.A
235 03462367 235 3462367
All data should have a single space between and should align towards the left. Any help is appreciate it. The data is from an Excel file that contains "Field1" and "Field2" that do not contain zeros when downloaded from a certain online program. Then I import these numbers from an access database file to format before downloading that data into another a main access database file. I know there is a way to add leading zeroes through excel itself before I export them from the first access file. I want to know how I can add zeros to the data while it's in the main database file.
There is a conversion query in the main access file that converts headers from a the downloaded data from the online website to the new headers in the main access database file.
Can there be a formula I need to place during the conversion query or do I need to place the formula somewhere else? Once the data passes thru the conversion, it goes to a set of duplicate queries before settling down to a main table.
Help is much appreciate it.