Combining Text When It Has Space

Oct 9, 2006

Hi

is it possible to combine text in a table when some have a space between them eg 123 456 789B would like it on the table as 123456789B without any space. I was not sure what command to use in a query to get this type of and use it for an update query if possible.
Can someone help
Many thanks

View Replies


ADVERTISEMENT

Combining 3 Fields Space Problem

Sep 15, 2007

Hi,

Im combining 3 fiels with the following code.

Newfield: [Field1] & " " & [Field2] & " "[Field3]. So after eacht field a space is placed but when field 2 had no data there are 2 spaces between field 1 and 2. How do i solve this

You can react in euther english or dutch

Tank you in advance

View 1 Replies View Related

Text Boxes - Need More Space

Sep 23, 2005

Hello,

I have a text field for filling in details of a job description. I only need a brief suummary, but unfortunately I require more than the standard 255 characters.

Is there any way of doings this? I woudl like to be able to add the information to one box in my form as I am cutting and pasting the text from MS Word documents.

Thanks

View 3 Replies View Related

Delete Space In Text Field

Dec 5, 2007

In my Dbase, I have a table with a text field. Field name is Country
There are over 5000 records in the table and many of these in the Country field start with a space. I would like to get rid of this space as to ensure that all text starts with a character, rather than a space.
How can I achieve this.

View 4 Replies View Related

Queries :: Get All Text To Right Of First Left Space

Mar 21, 2014

how to find the first space on the left of a text string, for example:I have this string : FUJIFILM XM-1 16-50mm BLACK and I want to find the space between FJUJIFILE and XM and then get all the text from XM onwards.I have this expression that gets me so far but then I'm stuck:

Code:

Model: Left([strDescription],InStr(1,[strDescription]," ")-1)

This expresssion gets me FUJIFILM, which isn't want I want.

View 6 Replies View Related

Modules & VBA :: Replacing Value Of Zero To Blank Space In Text Box

Oct 4, 2013

How can I replace a '0' to a blank space and '1' to 'X' in 'Text Box' in a report ? The 'Data Type' is 'Yes/No' in the table.

View 6 Replies View Related

Replace Space With Underscore In A Text String

Feb 2, 2015

I sometimes get a last name with two names not connected by a dash (i.e. Smith-Jones), instead it is entered as "Smith Jones". When I get it from Excel into Access is there a way to replace the space with an underscore in Access? I know I can do it in Excel, but I need that Excel file the way it is for other purposes.

View 2 Replies View Related

Combining First Letters Of Two Text Fields

Feb 21, 2005

In a form I can easily combine and display the content of two text fields in a third text field with the formula =[field1] & [field2]. Very well. Now I would like to combine and display only the first letter of each of the two text fields. This I would expect to go somewhat like this =(letter,1,1[field1]) & (letter,1,1[field2]). How is the correct formula?

View 4 Replies View Related

Combining Two Text Box Values Into One Label

Jun 12, 2013

I have two text boxes, and i want to make there value be the label for the form. Here is what i have in the Label on the form:

=Nz([Last Name] And [First Game],"Untitled")

Where am i going wrong?

View 5 Replies View Related

Tables :: Combining Two Text Columns Into One In A Table?

Aug 16, 2013

My Approach database contains records relating to nearly 800 sites in London. There are radically different amounts of data held about each site. The database contains a lot of different tables, each containing a different class of information. Not all the sites listed in the database have information in all of the tables.

The unique thing that holds it all together is the unique site reference number. Unfortunately this is split into two separate columns in the Approach database, "Reference" and "Suffix". Not all sites have a suffix. (The purpose of the suffix is to identify sub-sites which are subordinate to the main site reference, but need to have their own individual records.) Because many sites have no suffix, most of the fields in the second column are blank.

In order to link all the tables together in access I need a Primary Key which is unique to each site. In this case the reference/suffix number is the obvious (only) candidate. There is no problem using two different columns to create a primary key. The problem I face is that it doesn't like the fact many of the fields in the second column are blank.

My solution to this is to combine the two columns into one. That would give every site a unique reference, and none of the fields in the combined column would be blank. Can I work out how to do it? All I want is a new column that displays the reference and suffix (if any) in a single field, no spaces.

View 2 Replies View Related

Combining Multiple Columns Into One Longer Column (without Combining Fields)

Jul 17, 2013

I trying to combine three columns that I have into one column without combining fields.

Currently what I have:
(see image below)

What I want:
ID-----MOC
##----name1
##----name2
##----name3
##----name4
##----name5
etc

The list I have will be much longer and will be changing frequently, which is why I can't just go on excel and manually do this.

View 14 Replies View Related

How To Add A Space In Between

Oct 26, 2005

I have a query that pulls information from two different columns in a linked table, and places them together in a single column in a new table. The expression that i use in the query is: Expr1: [ARTINAME]+[ TITLE]. I need to put a space between the two. Is there a way to put a space in between these two when written to the new table?

View 3 Replies View Related

What Takes More Space?

May 19, 2006

Hi everybody,

Amongst many other things i would like to be able to see which teams in our company have access to which database. We currently use up to seven!!! different Databases which makes for tremendous fun...just kidding.

Since every Team has access to more than one Database andevery Database obviously gets used by a multitude of Teams, i thought the best way to go would be a Junction Table. Whilst building this, however, it occured to me that i could have just created fields for each Database in the Team Table which then can be ticked.

So here's my question, is it more space consuming to create a junction table, it certainly appears to be more work right now...

Thank you very much,

Dan

View 2 Replies View Related

Can I Have A Space In Field Name?

May 11, 2005

Hi!

Is it possible for me to alias the fldGroup to Function Group?

How do you alias a field name to a name that contain a space?

Please advise.

Aijun.

View 3 Replies View Related

Remove Space

May 20, 2006

I have an enormous Post Code Table 1.7 million records, which I must update every month into usable sectors for our carrier cross refs, the UK postcode is in the format CB6 3HQ, CB6 3HR, CB6 3HS, CB6 3HT, CB6 3HW etc I need to be able to remove the space then only use the first 4 chrs ie CB63, in the above examples I know I could do a search and replace " " with "" but I need this to be run automaticly where would be the best place to do this and if coded how?

Any help or alternative suggetions appriciated

View 6 Replies View Related

How Do I Know How Much Space A Table Uses Within An MDB

Jul 26, 2007

Hi there

I would like to know how to find out how much space a table uses within an MDB. is there a analyser of some kind available that you know of?

Thanks

View 3 Replies View Related

Find First Space From Right

Sep 17, 2007

I need an expression which finds the first space from the right and returns the text (variable length) to the right of it.


Ex.

AMINOPH, THEOPHY. INJ

expression should return INJ

View 1 Replies View Related

Read Right To First Blank Space

May 19, 2005

I am trying to break out a field where city, state and zip codes have been consolidated. I want to create a field where I am able to ready the consolidated right either right or left until the first blank space. For example:

"pittsfield ma 01201"

I want to read the field to break out "pittsfield"

Thanks in advance for any help I can get on this :)

View 3 Replies View Related

Not Enough Disk Space Error

Nov 21, 2005

OS = XP pro SP2
200GB IDE HD with 134GB free (NTFS)
200GB USB2.0 with 54GB Free (NTFS)
Virtual Memory = 1gb (Let Windows Manage)

Trying to copy files from a external USB drive to the Hard drive.

I have done this a million times and now it decides to foul up. When trying to copy files from the external drive to the hard drive that are 4GB or higher I get an error "Not Enough Disk Space"

Both Drives are NTFS with Plenty of free space. Also get the same error when creating files larger than 4GB. It worked before and no OS changes have been made that I know of.

View 2 Replies View Related

Adding A Space After The Decimal!

Aug 16, 2006

Hello Everyone :cool: ,

In access, I have a field in a table that I need to fix. The field contains a charge(money) value, with a code attached to it. For example:

[2345.0020680]---> The (2345.00) is the charage amount & the (20680) is the code.

[17580.04PPO]----> (17580.04) is Charge; (PPO) is the code.

**Every charge amount is different, and every codes length is different; so there is no consistency in this field.

I need to add a space, comma, backslash, or something two places after the decimal, to split the two. Once I do that I'll export to excel, and split the field into 2.

HELP!:confused:

Thanks in advance everyone,

Martian262002

View 5 Replies View Related

How To Check Harddisk Space

Jul 15, 2007

Hi, i wish to check the user C drive remaining spaces using vba, how to do this?

View 6 Replies View Related

For Statement With Space Inside

Jul 27, 2007

My following sql statement is wrong. "Scenairovalues Step02" is the table name. How should I write this one with the empty space in the name?

vtSql = "Select * from Scenairovalues Step02"

Thanks a lot in advance!

View 2 Replies View Related

Delete <space> If At Beginning Or End Of Value?

Dec 4, 2007

Hey all,

I got a massive lump of WORD documents with Avery Mail label tables -- each avery mail label template/table has a mailing address. This how these people store their data. :mad::confused::mad:

So I went through and over a couple days transfered all 458 records to an excel spreadsheet for easy importing to my access mailing database. Problem is that I forgot to clean up a couple of the fields and now I have all these values with unnecessary spaces as the first or last characters for a lot of values.

My question:
Could anyone help me remove the first and/or last character of these values if the character is " "? Would it be easier to do this in excel and just re-import?

View 6 Replies View Related

Space Character In A Field

Oct 12, 2005

Hi!
I have a field that has to be 20 Characters long. Most of the time data for this field is less than 20 characters, so the remaining has to be filled with spaces to make it 20. e.g. if there is a record xyz1234567, then the rest of the record should have 10 spaces like xyz1234567ssssssssss, meaning if i click on this record then the cursor should not blink after 7 but after the spaces. Hope I am making sense.
Thanks for any input.

View 1 Replies View Related

Temporay Disc Space

Apr 10, 2006

can anyone help, when trying to run a dedupe query i get a error message saying 'not enough temporary disc space'

View 1 Replies View Related

Sorting Records After The Last Space

Oct 10, 2006

Hello all,

I have a field in a database that has people's full name (e.g. Jane B. Doe). I would like to sort by their last name. Can I build a query that looks at everything after the last space in their name? Thanks in advance.

Ron

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved