Welcome to Windows Help!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Alpha Query

  
   Windows Help (Home) -> Microsoft Access RSS
Next:  Words change into square boxes  
Author Message
zyus

External


Since: Dec 3, 2008
Posts: 8



(Msg. 1) Posted: Thu Jul 30, 2009 6:10 pm
Post subject: Alpha Query
Archived from groups: microsoft>public>access (more info?)
Records in my Emp fields is as follows

Emp
01-2-06ABC
1-1-09CDA
01/04/09BVE

In my query, i want to select alpha and i can get

Emp1
ABC
CDA
BVE

Thanks

 >> Stay informed about: Alpha Query 
Back to top
Login to vote
KARL DEWEY

External


Since: Jan 22, 2009
Posts: 16



(Msg. 2) Posted: Thu Jul 30, 2009 6:42 pm
Post subject: RE: Alpha Query
Archived from groups: per prev. post (more info?)
Try this --
SELECT zyus.Emp
FROM zyus
WHERE (((zyus.Emp) Not Like "*[0-9]*"));

 >> Stay informed about: Alpha Query 
Back to top
Login to vote
Steve

External


Since: Jun 4, 2009
Posts: 3



(Msg. 3) Posted: Thu Jul 30, 2009 9:43 pm
Post subject: Re: Alpha Query
Archived from groups: per prev. post (more info?)
If your desired result is always the three characters at the end of Emp,
create a query based on the Emp table, and put the following in the first
field of the query:
=Right([Emp],3)

Steve
santus.cut DeleteThis @penn.com


"zyus" wrote in message

> Records in my Emp fields is as follows
>
> Emp
> 01-2-06ABC
> 1-1-09CDA
> 01/04/09BVE
>
> In my query, i want to select alpha and i can get
>
> Emp1
> ABC
> CDA
> BVE
>
> Thanks
 >> Stay informed about: Alpha Query 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Can not change data once i bases a query on a query - I have a despatch System that shows a customers orders with the products to be despatched Its on a Contious form based on a query. On the form i also want to show the Quantity that need to be despatched as the order might be despated in parts Th I hav...

Query from 3 tables - I have three tables that I want to put in query. But this is what I need: Articles Stores MinimumQTY ----------- ---------- --------------------- ArticleID StoreID ArticleID..

Query Parameter - Is there a way to use a query parameter with an expression. Or reference a textbox value within an expression. In the expression below I would like to replace the 9/1/2010 date with a reference to a textbox or parameter message box: MeasurementDays:...

Setting up a query or report - Every first of the month i have to submit a report which contains the following informaiont: Total # of clients beginning of month, Total # of New clients, Total # close clients and total # clients receiving services at the end of month. What's the..

Auto Running a Query - I have a table that is linked to an external file that auto populates when a change is made to the file. Once the table is updated, I apply some business rules to it via a query then append the changes to a Master table. What I would like to have..
   Windows Help (Home) -> Microsoft Access All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]