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

First Letter Should Be A Capital, The Rest Not

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

Need Solution To Read Data In Both Capital/small Letter

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

Storing The First Letter Of First Name, First Letter Of Last Name And Data Of Birth

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

Letter By Letter Search Through A Table

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

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

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

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

Letter And Query

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

Query To Look At The 3rd Letter In A Field

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

General :: Does Access Recognize Capital Letters

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

Query With Resulting Print Of Letter

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

How To Update A Query To A Letter Instead Of Number?

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

Reports :: Create Letter Using Fields In Query

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

Queries :: Possible To Extract First Letter Of A Surname In Access Query?

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

Forms :: Format Memo Field To Ensure That Sentences Begin With Capital Letters

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

Need Query For Max Date To Find Most Recent Letter Sent Using Distinct Addresses

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

Forms :: Make Image Appear In Form When There Is Check In Check Box From Table?

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

Letter Help

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

Check For Eof In A Query

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

Check Box In Query

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

Check Box Query

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

Check Box - Query

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

Letter Feeding From DB

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

Starting Letter

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

Does Not Start With A Letter

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







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