split a column into two seperate columns
2,500 @ $21.55. The @ symbol is always present so I essentially want to wind up with two columns Quantity (2,500) and Price
Thank you for taking the time to report an issue.
What's wrong... Please write below.
Please, see the attached image that shows my question
Attached also the table
i need to split the column that contains the N E values into 4 columns
Why I need this?
Im given the coordinates in long-lat and I need to convert them into XY, so first I need to convert them into Decimal degrees then to be converted to xy.
I will have about 2000 lines that need to go to seperate word doc
I have imported a table into access. One of the columns is a column called DTG_LOCAL (which is short for Date/time group local time). This column is a string column with the format DDMMMYYYY:HH:MM:SS or 01JAN2010:13:40:00.
I am looking for a sql query that will take the string DTG_LOCAL column and break out DDMMMYYYY and HH:MM to their own columns with an additional column with just HH for a total of three new columns with the broken out information. The three columns would be DATE, TIME, and HOUR; Lastly, convert the columns from a text column to DATE/TIME respectively.
DTG_LOCAL --> DATE / TIME / HOUR or
01JAN2010:13:40:00 --> 01JAN2010 / 13:40:00 / 13
The other columns in the file are not deleted.
The table name is GPS_AI_Import
Record 1: English
The 3 languages are separated by hitting the enter key, and not the space bar key. I have about 400 records of this issue.
Is there a way I can split the language column into 5 columns at most? And then, if a record only has 3 languages, only the first 3 columns are populated?
FYI, I have MS Access
I need to separate the values AA, BB as one column and 000,001 as another column.
So the tasks I need to do is:
read in the Excel file
split the data in a column in to two columns
update the already existing access table with the data in the two new columns.
I have a table called Table1 and within it are various columns including a Transactions column that contain both credit and debit (positive and negative) transactions. As well as the Transactions column in Table1 there is also an Account Number column. There are several account numbers and each account number has several transactions.
The end goal is to create a query that splits the debit/credit transactions into separate columns and then totalled for each account.
Iv tried creating one query with <0 criteria under the Transactions field for negative and vice versa for positive then a third to bring the two columns together but its not really working!
Ideally it would be great to do from one query but think it may be unlikely to do from the query design view.
Whilst I have no experience with SQL, I am confident of following any clear guidance offered
For example :
Me.[nameOfColumn].Columnwidth = -2
This doesn't seem to work in my split form