UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Appending data in field to only capture first 3 characters    
 
   
Bearack
post Apr 9 2005, 08:13 AM
Post #1

UtterAccess Enthusiast
Posts: 73
I need to only view the first three characters in a specfic field i.e. field name WAREHOUSE, Data consist of SEAYAK, SEAPOR, SEAEUG, DENCAS, DENFTC, PHOTUC, PHOSCT ect. All I want from this field is the SEA, DEN AND PHO.

Thanks in advance (IMG:http://www.utteraccess.com/forum/style_emoticons/default/frown.gif)
Go to the top of the page
 
+
ScottGem
post Apr 9 2005, 08:17 AM
Post #2

UtterAccess VIP / UA Clown
Posts: 25,079
From: LI, NY
=Left([field],3)

HTH
Go to the top of the page
 
+
Loop
post Apr 9 2005, 08:18 AM
Post #3

UtterAccess Veteran
Posts: 412
enter Left([enterfieldname],3) in the field line of your query
Go to the top of the page
 
+
Loop
post Apr 9 2005, 08:19 AM
Post #4

UtterAccess Veteran
Posts: 412
oops. sorry scott
Go to the top of the page
 
+
Bearack
post Apr 9 2005, 08:27 AM
Post #5

UtterAccess Enthusiast
Posts: 73
Thanks for helpin a noob. Many more to follow.
Go to the top of the page
 
+
Bearack
post Apr 9 2005, 09:22 AM
Post #6

UtterAccess Enthusiast
Posts: 73
Curious question....
Once I added the formula to my warehouse field, why would me record count decrease? Before formula 311000 records. Once I add the formula I am at 221000 records?
Go to the top of the page
 
+
prebez
post Apr 9 2005, 09:43 AM
Post #7

UtterAccess Guru
Posts: 908
From: Copenhagen, Denmark
Only if you have changed a criteria, or if you are grouping on the new field. The later seems to be a possibility.

Hth
Jock
Go to the top of the page
 
+
Bearack
post Apr 9 2005, 09:45 AM
Post #8

UtterAccess Enthusiast
Posts: 73
Did some test and with the formula that you provided its only querying warehouse names that only begin with DEN, SEA and PHO. The warehouse that are name DENCAS, SEAYAK and PHOTUC (as examples) are not showing in the query. I need those to show but with the arehouse name appended to just the first three characters of their name. Is this what the function of the formula is suppose to do and is just not working properly?

Thanks again for your assistance.

EDIT TO CLARIFY: There are warehouses with just the names of DEN, SEA and PHO which the query is just pulling and not appending the warehouses with the names DENCAS ect and placing them into the query.

Hope that helps.

Edited by: Bearack on Sat Apr 9 11:03:07 EDT 2005.
Go to the top of the page
 
+
Bearack
post Apr 9 2005, 10:04 AM
Post #9

UtterAccess Enthusiast
Posts: 73
I want to pull the numbers for the region and not by individual warehouse. Regions are determined by the states the main warehouse is located, hence SEA.
Go to the top of the page
 
+
Bearack
post Apr 9 2005, 02:02 PM
Post #10

UtterAccess Enthusiast
Posts: 73
Suggestions?
Go to the top of the page
 
+
balaji
post Apr 9 2005, 02:14 PM
Post #11

UtterAccess VIP
Posts: 5,635
From: Chicagoland, USA
Maybe someone will be able to help if you post the exact query you have right now and give some details about your table structure etc.

Maybe you need an extra calculated field in your query which is calculated as left(warehouse,3) and you need to group your results by this calculated field. But again, this is just a guess and I can't help further unless I get more details of what you have right now, it is difficult to help.
Go to the top of the page
 
+
« Next Oldest · Access Queries · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 22nd May 2013 - 02:13 PM