Spliting A Zip +4

Feb 5, 2008

Can someone show me how I can split the Zip+4 in this query, if it can be done at all?

SELECT
RTrim([CLIENT TABLE].CITY)+' , '+RTrim([CLIENT TABLE].ST)+' '+RTrim([CLIENT TABLE].ZIP) AS [ADD],
RTrim([CLIENT TABLE].FN)+' '+RTrim([CLIENT TABLE].LN) AS NAME,
[CLIENT TABLE].MEMBER, [CLIENT TABLE].PIN,
[CLIENT TABLE].A1, [CLIENT TABLE].A2,
[CLIENT TABLE].MEMBER_CASE_STATUS,
[CLIENT TABLE].RELATION_CODE INTO [CLIENT TABLE 2]
FROM [CLIENT TABLE];

Thanks

View Replies


ADVERTISEMENT

Spliting Text

May 29, 2005

Hi, Would it be possible to get the first word from a sentance.

For example

Peter James would Return Peter.
John Michael would Return John etc.

The first word could range from 1 to 50 characters.

Regards

Pete

View 2 Replies View Related

Spliting Values In Field

Sep 29, 2005

Hi

I have the field fullname in my database which is in the format

Mr John Smith

What I have been trying to do is to extract the Mr then the John then the Smith into 3 separate columns. Can anbody help please?

Thank you

Marcus

View 3 Replies View Related

Problem In Spliting Table, Please Help

Sep 21, 2006

Hi!

The structure is like:

C query is based on 2 tables, A and B.

Then D form is created based on query C.

What I did:

Now I split table A to 2 tables, A1 and A2 which are indepandant from each other, and I updated query C to retrive data from A1 and A2.

Problem:

Then the form D which is based on C doesn't work properly.

Question:

Do I need to recreate a Query C because I split table A?
or do I need to recreate a From D because Query C is updated?

Thanks very much

View 2 Replies View Related

Spliting A Column Into Several In Access 97

Sep 10, 2004

I have a field in a table that looks like this:

hahafdhzuiwre8878878s
agahh87878jkjkkjk

etc...

there is no set length to the bits between the slashes.

I want to write a query that moves the data into a new table in three separate fields using the slashes as field separators.

Can anyone help ??

View 1 Replies View Related

Spliting Numeric From Letters

Jan 14, 2005

i have a field called Items, description

Items Description

1021 125BL/WH
1022 5RD
1023 1458BL/BU/YL
1024 2500GR
1025 5GR


i want to be able to split the numeric from the color code. and add make a new field with the color code, and then have the quantity as a record.

Any Help is apreciated
Mark

View 14 Replies View Related

Problem In Updating Query After Spliting Table, Help Please

Sep 21, 2006

Hi!

The structure is like:

C query is based on 2 tables, A and B.

Then D form is created based on query C.

What I did:

Now I split table A to 2 tables, A1 and A2, which are independant from each other, and I updated query C to retrive data from A1 and A2.

Problem:

Then the form D which is based on C doesn't work properly.

Question:

Do I need to recreate a Query C because I split table A?
or do I need to recreate a From D because Query C is updated?

Thanks very much

View 4 Replies View Related







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