Query To Check First Letter Capital
Jul 2, 2007
Hi. I have a load of records, that some of the first letter of a field, are not capitals, otherwise they are ok. the are loads of them though, so would take too long to go through by hand, is there a query i can run, to check it and change it if not?
Thanks
Alex
View Replies
ADVERTISEMENT
May 31, 2006
Hi,
I have a set of data and some are in capitals and some are not. This set of data is meant to be used for a mailing, and the home style of my company only allows the first letter to be a capital, the rest should be normal letters. Anyone have an idea how I can arrange this?
Thanks in advance!
View 4 Replies
View Related
Nov 13, 2006
Hi,
In one of the column of a table of my SQL Server contains around 500 employee names. Some of them are written in capital letters and some are not. Some of them with first character capital and rest all small.
I am using FE as MS Access. When user search the record thru a normal textbox (behind which I put small bunch of code to get the desired data in sub-form) user must enter searching name in the textbox in the same fashion the actual data available in the table.
e.g. let us say the employee name is John
User who searching John’s record must enter first letter capital otherwise it will not search. Why like this if table in on server.
This doesn’t happen when table is local in access. What is the solution to this?
All the suggestions are welcome.
With kind regards,
Ashfaque
View 3 Replies
View Related
Feb 19, 2006
Hi,
I'm designing a database in which the primary key is a combination of the first letter of first name, the first letter of last name and the date of birth.
How can I do that?
Regards,
CS
View 8 Replies
View Related
Aug 21, 2005
ok here is what i want.. imagine a search box, just an empty text box that allows the user to type things into it...
there will be a simple table from the database behind it, here is the typical structure of a record
<Country>Poland
<Price1>60
<Price2>85
<Price3>95
in this table there will be say a 1000 of these records...
my user is going to have to quickly search through these records while on the phone to a customer, and quote one of the relevant prices associated with that country
what i would like is this most convenient system..
as the user types in the letter 'P' just below all the records with countries that begin with 'P' are displayed (with a scroll down arrow if needed)..as well as the 3 relevant prices with that record
if they then type an 'O' into the box (which will now hold 'Po') all the records with countries beginin with 'Po' will be displayed (eg Poland)
if they delete the 'o'. once again the displayed records below the box will return to just the countries begginin with 'p'
all that is needed is for the records to be displayed, thats it.. but the adding and deleting of the letters within the text search box will need to instantly manipulate this list..
i have posted on other forums, and have been told this can be acheived in access, is it hard?
View 9 Replies
View Related
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
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
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
Oct 12, 2007
Hi,
I'm fairly new to Access. I have few questions.
How to set up database so it searches through my table, finds the name and inputs it into letter in a space I want?
Where does this letter suppose to be located in the file?
Thank you
IOI
View 2 Replies
View Related
Sep 1, 2005
Hi, anyone know if it possibe to create a field within a query that looks at a 3 letter number code in a field of a table named "employee master" to see if the last number is an "I" or not. So for example a number code in a field named "Department" is "KTI". I would like to display "indirect" in that field if it contains a "I" in the 3rd letter of the number. And display "direct" if the third letter is a "D" intstead, tried doing IF statements but not sure how to go about it, any help would be great.
View 5 Replies
View Related
Jun 15, 2012
When enforcing referential integrity, does access get angry about capital letters?Or just in general, if an address gets put in with a capital letter in one instance and then without in another does it make a difference?
View 14 Replies
View Related
Sep 13, 2006
I am assisting with the design of a db, where depending on two criteria, one of two letters needs to be printed. If one check box is positive, a letter is to be generated. If it is empty then a second checkbox will be checked, resulting in a different letter.
I appreciate any assistance.
:o
View 1 Replies
View Related
Jul 5, 2005
I have a query that I try to update to Alphabetical instead of numerical. I am using MS Access. on the row say "Update to" I Enter Alphabetical letter but it doesn't work. I wonder if any way to do so. Please HELP!
Thanks
View 3 Replies
View Related
Mar 14, 2014
All, using access 2010. I am working with an existing database that have a letter programmed using fields in a query. I have to add to it but having a trouble. Merge in Word was not used. I can't find any examples. The letter is designed in a report design. Using the fields from a query and filtered by "IIF Statements".
View 3 Replies
View Related
Jun 11, 2015
is it possible to extract the first letter of a surname in an Access Query? Below is my sample data, and below that is what I want to acheive.
Player Name
Hart, Joe
Cech, Petr
de Gea, David
Szczesny, Wojciech
Mignolet, Simon
Reina, Pepe
Lloris, Hugo
Howard, Tim
Begovic, Asmir
What I want the query to return:
Player Name
Hart, J
Cech, P
de Gea, D
Szczesny, W
Mignolet, S
Reina, P
Lloris, H
Howard, T
Begovic, A
View 6 Replies
View Related
Nov 4, 2014
Is there a way to format a memo field to ensure that sentences begin with capital letters. There might have been something in the strConv function, but it seems my hopes are dashed?
View 1 Replies
View Related
Feb 21, 2014
I'm trying to create a report for how many "nasty grams" (rejection notices) my company has sent to people who keep sending in paper forms when they are supposed to file electronically.Every letter that goes out has information recorded based on whatever they sent to us - so the only remotely reliable way to count how many each person received is by the address on the envelope (people use different names, different business names, use different telephone numbers on the forms, etc).
I just built several queries that feed into a report that gets sent to my boss on a monthly basis to show the people who've sent in more than one paper form and have received our rejection notices more than once.I'm not the greatest at SQL, but I've been trying to find a way to use DISTINCT Addresses, leave all other fields the same (not DISTINCT), to:
1. Only return people who have received 2 or more letters
2. If at least one of the letters was sent more than 90 days ago
AND If at least one of the letters was within the last 90 days
-If at least one was within the last 90 days, only display the most recent send date of the letter (lots of people get back-to-back letters).
3. Display their names, addresses, telephone numbers, the date of the most recent letter sent, count of the total letters ever sent to that person. (the report will already do this, just need Max date)
My first query counts the number of times each address appears in the main table and simply only has [Address] and [CountofAddress]
My second query has the [Name], the [LetterDated] >=Now()-90, and the qryCountofAddress is linked to the main table by [Address], using [Countof Address] >=2...I have tried Selecting Unique Values in the Properties tab. Yes, I have tried INNER JOIN (but can't get the rest of my fields to display once I make addresses distinct).
View 1 Replies
View Related
Jun 26, 2014
how can i make a image appear in my form when there is a check in the check box from the table?
View 14 Replies
View Related
May 14, 2007
hi,
Im creating a letter. It is based on a query. I have some details that I'd like to display , one on it's own line. I cant print them out now, but they dont all fall on their own separate lines. How should I do that? If I put a carriage control at the end of each detail line, will it know to print each of the fields on its own line? I need advice . I tried doing a subreport -type letter, but it looks weird!
thanks!
View 1 Replies
View Related
Apr 12, 2007
Hi everyone
when I open my form i SET UP A QUERY IN THE CONTROL SOURCE that would only selected records that I wanted. That part work fine. The problem that I have its when i get to the last record , how do you determine that you are at the last filtered record?
View 6 Replies
View Related
Aug 7, 2007
hi all
is it possible to use a check box to excecute different parts of a query? or to select which queries i want to run. and if so how can i do this.
Ex...
i run different queries on different tables all the time...table names change but they have the same columns and thus my query stays the same except for the table name. but i don't run all the queries on all the tables,,,how can i select, using a check box, which queries i want to run???
please help
regards
View 3 Replies
View Related
Jan 23, 2008
I'm looking to create a query which I can use to produce a report. In one of my tables I have an "In Progress" check box.
I'd like to create a query which will show all records with the "In Progress" box checked. I'm just not sure what to enter in the criteria field in the query.
View 2 Replies
View Related
Mar 21, 2008
hi,
can anyone help i don't know how to show all the records that have been checked in a check box. Do i need to use the expression builder??
thx in advance
View 2 Replies
View Related
Oct 16, 2007
having database full of names and info, how to create a letter which feeds from specific database records with one click, so it can be printed and post it?
cheers
View 9 Replies
View Related
Jun 15, 2005
I want a criteris in access to get the records having field 2 starting with "num". Num is example. I want to do withdifferent letters.
number
numbiur
numg
numds
the first three letter should be num in this example. i want for different words i.e, i need to enter the paramter message box.
View 2 Replies
View Related
Oct 15, 2007
Hi All:given a table with, let's say, Job Numbers that start with a letter (such as RES2345) or just plain numbers (such as 253180001 or 9817) how can I set the criteria in the query to just give me jobs that start with a number?I first trimmed the field to eliminate blank characters and then I used the Not Like "A - Z" but it still gives me jobs with letters at the beginning of the name.thanks for all your help in advance. :D
View 1 Replies
View Related