In earlier versions of Access there was a query, which I cannot remember now, that changed all caps data into upper and lower case. It would leave the first...

I've constructed a query that relies on data from 9 other queries, using the same single field from each of the 9. I've tried to expand this query to include...

In our dB someone enter descriptions in capital letters. I need to Identify those entry. How can I do that?

How do you write a query that will change UPPER CASE to Proper Case In All Fields? Dale

Hi, Two questions 1) How can i permanently update all table values to Upper Case. Right now they are just formatted to upper case,but when the user selects...

Our data entry person has enter all of our contacts into an access table using all upper case letters.......Is there anyway I can change all of those names...

My Table has Few Fields two of them hold dates. the two date fileds are "FROM" and the other is "TO". I want to be able to run a query that will bring me...

Hi All, I have problem at the moment - all the data in one field is coming up in capital letter e.g. JOHN SMITH, what i would like to do is have only...

In my Access 2000 database, I have a form for entering data on people who register for an event. Key fields are "First Name", "Last Name", "Event Code". I...

There are several update queries in a db I am maintaining. They run when a user enters data in 2 fields on a form and clicks a button. The button runs 8...

When I upgraded from Access 2002 to Access 2003 the query speed has been reduced to a stand still. Mdb2 runs queries using linked tables from mdb1. The CPU...

Appending challenge,More complicated than the previous one, I have a huge data over 750000 records that I need to mange one of the challenges I am facing is...

dear all , i have one single tablewhere i used to keep all my purchases, i want all the the invoices on a specific date to be marked as paid , i want to it...

I am trying to update a field based on Lat/Lon 'decimal' numbers, but whenever I up to another table I get just single whole digits. This is a sample of the...

Is it possible to only update the year portion of a date/time field? The current dates are entered as xx/xx/xxxx, e.g. 3/5/2004, 4/22/2004, etc. All the years...

I have a file that contains multiple duplicate records except that they have a unique key. i.e. multiple row number /seat number and EVENT NUMBER When I...

Hi Guys, I need help :) End Goal: - A database to update and track shares between members Preliminary Information: - I have three tables: - one that...

I was using Allen Browne's module to update values from previous record. The entire code could be viewed at the following address: ...

I feel a little silly, but I'm just going to come out straight and say it: I play Dungeons & Dragons and I thought that it might be fun to try and build a...

I have multiple subforms that allows the user to change which subform a record shows up on. The user changes the category in a combo box. The form performs a...