WHERE First Three Letters Equal Xyz

Sep 21, 2007

Hi there,

I have one question with regards to the WHERE part of an SQL query. I want to limit my query on datasets, where the first three letters of a certain field (which contains strings) equal "Exp". Is there a more efficient way than the following?


SELECT A.Date, A.Name
From tblA as A
WHERE A.Name="Exp_A" OR A.Name="Exp_B" OR A.Name="Exp_C";


Best regards,
JapanFreak

View Replies


ADVERTISEMENT

"Not Equal And Not Equal" Query Not Working

Apr 14, 2006

I am trying to run a query where one field has a Not Equal parameter AND another field has Not Equal parameter (for example, Product Code Not Equal "A" AND Client State Not Equal "NY)

The result of the above query are all records that have Product Code = "A" are missing from the result. I want some of the "A" Product Codes; I just want to exclude the ones where the Client state is NY.

The list of values for each field is too big to state it in a positive way (I would have to list all the other 28 product codes and all the other 49 states).

What am I doing wrong? Thank you in advance for any suggestions.

View 1 Replies View Related

Not Equal?

May 26, 2005

Hey,

I have 2 tables that i compere together with a query and if my criteria is OK than selected data is recordet in new table with some calculation....code:

INSERT INTO tblZaloga ( Proizvajalec, Tip, DN, Predvideno, Naroceno, Zaloga )
SELECT tblACAD_Urejeno.Proizvajalec, tblACAD_Urejeno.Tip, tblACAD_Urejeno.DN, tblACAD_Urejeno.KosovSkupaj, tblIN_Urejeno.KosovSkupaj, Sum(([tblIN_Urejeno].[KosovSkupaj]-[tblACAD_Urejeno].[KosovSkupaj])) AS Zaloga
FROM tblACAD_Urejeno, tblIN_Urejeno
WHERE (((tblACAD_Urejeno.Tip)=[tblIN_Urejeno].[tip]) AND ((tblACAD_Urejeno.DN)=[tblIN_Urejeno].[DN]))
GROUP BY tblACAD_Urejeno.Proizvajalec, tblACAD_Urejeno.Tip, tblACAD_Urejeno.DN, tblACAD_Urejeno.KosovSkupaj, tblIN_Urejeno.KosovSkupaj;


Now i have a problem with racords that does not reach my criteria. The problem is that i dont know witch records are the one that does not reach my criterya? Can someone pls tell me how can i create a table like the code up there but with records that are not procesed?

THX

View 2 Replies View Related

Not Equal?

Jun 8, 2005

Hey,

Can someone pls tell me how can get not equal resoults from my two tables? I have table1 and table2 both with field "Layer" and what I want is to get only that data from table1 that does not have the same Layer as table2.Layer?

I try to JOIN table1 and table2 and i get the same resoult as with this code:
WHERE ((tblACAD_MRK.Layer)=[tblLayerji].[NeteniLayer])

but thats exactly the oposite from what i want, so i try with this code:
WHERE ((Not (tblACAD_MRK.Layer)=[tblLayerji].[NeteniLayer]))

and the code does not give me the resoult that i want, becouse i get all the layers for some reason :confused:

So can someone pls tell me what can i do?

THX

View 2 Replies View Related

Not Equal

Sep 27, 2005

I'm wanting to write this query that looks at both tables and only returns records that don't match...not for sure how to do this..


SELECT tblCombined.DLID, tblCombined.DUP, tblCombined.QRYRAN
FROM Susp_Master INNER JOIN tblCombined ON (Susp_Master.DUP = tblCombined.DUP) AND (Susp_Master.DLID = tblCombined.DLID);

View 4 Replies View Related

Letters

Aug 13, 2007

Hi

I am just wondering if there is any way that you can use access to input information into a letter

i.e. you could just click a command button and it would print a standard leter with the details from an address on access e.g. name etc

Thanks

View 10 Replies View Related

Capital Letters

Jun 25, 2007

Hi, I have an address database and in the zipcode/postcode box, i want all letters entered to go to capitals ie rj20 4ls would go to RJ20 4LS after update. how could i do this, what do i add to text boxes after updat?
Thanks

Alex

View 2 Replies View Related

Filtering Letters

Apr 20, 2007

How would I about filtering out all results that contain a letter in them? The entries are in a field called Code, and I only want to display the resources that don't have a letter in the code.

View 1 Replies View Related

Letters In Access

Aug 31, 2005

We are in the process of converting from Lotus Approach to MS Access.
In Approach we could create letters that would add the fields we told it to.
We do not want to have to use the mail merge to Word. Can letters be created in Access?

View 2 Replies View Related

Getting First Letters Of Records

Nov 21, 2005

hello
I have a access DB with several names in a table. I need to get only the first letter of each name, but only one for each A, B, C, etc. For example, if I have 3 names starting with a A and 5 starting with the C, it will give me only 2 records, one with the letter A and other with the letter C. I'm using ASP with access database.

tks for the help.
Sneakky

View 11 Replies View Related

Value In A Table Equal To The Sum Of Other Values

Dec 11, 2007

Hey.

Is there any way to make a field in a record automatically set it self so it's the sum of other values in the record

http://img412.imageshack.us/img412/1677/helphg9.jpg

That's an example what i want to do except i had to manually type in 25. Is there any way to get that so it does that automatically. I am happy to use forms or macros or anything as long as it occurs straight away after the data is inputted and not have to run something or open something up

Thanks in advance

View 5 Replies View Related

If Records In Rows A And B Are Equal Then

Apr 26, 2008

Hello,
I would like to show records in my query only if records in raw a and b are equal and they have same question id.
Please let me know if you can help.
Many thanks,
Debbie

View 3 Replies View Related

Not Equal To & Grouping Query

Apr 28, 2008

I have Table as PL2008 and RPT2. Both tables have one column named PTUNID. My goal is to first Group, sum certain Columns in the PL2008 then match PTUNID from this Grouping to RPT2 Table's column PTUNID and then show the results which do not match.

I have written following Qry but what really happenning is its giving me all the results ( match and no match in both tables ) and Sum values are incorrect.

SELECT [PL2008].PTUNID, Sum([PL2008].[Total Hours]) AS [SumOfTotal Hours], Sum([PL2008].[Actual Cost]) AS [SumOfActual Cost], [PL2008].[PRFIELD]
FROM RPT2, [PL2008]
WHERE RPT2.PTUNID <> [PL2008].PTUNID
GROUP BY [PL2008].PTUNID, [PL2008].[PRFIELD];


Any suggesstion



Thanks
Niri

View 3 Replies View Related

Compare 2 Tables Where NOT EQUAL &lt;&gt;

Feb 7, 2006

It need to compare two tables where the ID Number is not equal. Specifically I need to update new poducts in a table, but only those ID#s that are not already listed.

I know how to compare two feilds where they are not equal...
i.e. [New_Table].[ITEM_NUM]<>[Old_Table].[ITEM_NUM]
...but I'm currently limited by the join properties in the tables, since I'm comparing IDs and not the feilds. ANY IDEAS?

View 2 Replies View Related

Seeking Help On Extracting Letters From Name

May 5, 2005

Hi all: MS Access 2003. I have two text fields family_name and given_name I need to extract 1st, 2nd & 5th letter of family_name along with 2nd & 3rd letter of given_name to form a link_key field. If either name has insufficient letters the missing letter is replaced by the numeral 2. Does anybody know how to help me acheive this please!

View 2 Replies View Related

How To Change Lowercase Letters?

Apr 19, 2007

Now,
I have a big table with sales data downloaded from DB2.
We have branches codes of 1 digit only.
Because of too many branches we have branch codes in upercase and lowercase. So Q ans q are different branches.
I'd like to substitute all lowercase codes like q with something like q_ to make them searchable.
How I can substitute all lowercase letters in one column of the large table in one shot?

Or may be you know any solution how to make Access queries sensitive to the case.

View 11 Replies View Related

Capital Letters In Text

Mar 16, 2005

Hi I'm new round here, and just wondering if anyone could shed some light on a few issues which I am trying to resolve in Access 2000.

Is it possible to make each word start with a capital letter even if the user inputs all the text in lower case,

for example:
user inputs: john smith

Desired display: John Smith


Any help much appreciated

Nick

View 10 Replies View Related

Primary Key Autonumber With Letters

Jun 25, 2007

Hi!
I am a new member of this forum and new to access.
I need to make a data base and I would to have my primary Key as an autonumber. I would like to use ID numbers that have already been assigned but they have letters in the beginning, they are GKAD0001 etc. so at the moment I just have them as text that wont allow duplicates, but really I would like them as and autonumber so when new data is added it automatically assigns the next number.
Is this possible?

Thankyou very much for your help.

View 2 Replies View Related

Remove Letters From Numbers

Dec 15, 2005

Hello again.

I’m trying to find a way in a query to remove any data except for numbers

Examples


NET 90
NET 10
NET 10 DAYS
NET 110
NET 15


Any help would be greatly appreciated

Corey

View 5 Replies View Related

Taking Letters From A String

Feb 8, 2006

Hi all, I'm not sure if this is possible ...

I have a table which has contact details in it... two fields are FirstName and Surname. I want to create a new field called initials which takes the first letter from each of the former two fields. Is it possible to do this using an update query?

Or any other way maybe?

View 3 Replies View Related

Deleteing Lowercase Letters Only

Mar 2, 2006

I've been stumped on this and could use some help...

Fields in my table contains some words that are in uppercase and some in lowercase. I would like to delete all the lowercase letters and keep only the uppercase ones.

For example, if a field contains the following text:
CHLOROSULFONIC ACID with or without sulfur trioxide

I would like to change this to:
CHLOROSULFONIC ACID

Can this be done via an automated process?

Thanks!

View 7 Replies View Related

Can I Do Group By Query With Letters

Dec 20, 2007

ex
columns

Name Day1 Day2 Day3 Day4 Day5 Day6
Jackie s s
Jackie v v
Jackie p p


I would like to be combined into

Jackie s s p v v p

all in one row.

View 1 Replies View Related

Criteria For All Numbers Or Letters

Jan 18, 2008

Hello, I am a new member...thanks for any help anyone can provide.
I have a table with a column in which the fields will come in with various lengths and combinations of characters. I need to look up certain values from this field, and assign a value to another field based on that. For example if field1 begins with an "H*", then field2 will equal "INS".

My problem is that I need to write a statement saying something like if field1 starts with "H" and is followed by only numbers for any length, then assign field2 "blank"

so I cant use "H*" because that includes letters...and Ive tried criteria like "H[!a-z]*" but cant get anything to work(i know the last example only looks at the space after H) Does anyone have any ideas?

View 4 Replies View Related

Capital Letters At The Start

Nov 14, 2005

Hi all,

I am new to this game, so please bear with me...

I am creating a form in my database and would like to know if there is a way I can default each starting letter of my surname and address fields with a capital (but leave the rest in lower case)?
I feel that it looks more professional.

Many thanks for any help.

Mark

View 8 Replies View Related

Capitals And Little Letters Difference

May 10, 2006

I have an inlogform and pasword change form
i have a table "authorized"
userid is the same as pasword if someone wants to try
the problem is: he can't seperate capitals from little letters,
you can try it...

How can I program it that i can make a difference between
capitals and little letters in userid and password

Greetz

veerle

View 1 Replies View Related

Creating Custom Letters????

Dec 23, 2004

Hello,

I would like to create a custom letter where I can type the body of the letter and it will print the letter for every customer in the database.

Thanks

View 1 Replies View Related







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