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.
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
Is it possible to search a field for a Lowercase letter.All data should be capital, but occasionally a user may ann a record in lowercase, and was looking for a query to pull back all records in lowercase
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
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.
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";
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?
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.
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!
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?
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?
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?
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.
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
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?
I have a column containing an id that consists of the first two letters of a weekday followed by an incrementing number. For example, for Monday, I have "MoA1" "MoA2" "MoA3" ... "MoA11".
The problem is that when I sort my list, it is ordering it: "MoA1" "MoA10" "MoA11" "MoA2" "MoA3" etc. Currently, my order by property is set to