Queries

Replacing individual characters in a field to something else.
I have a field with names that is pulled from a main frame database. These names have the last name first, then a comma, then the first name. I want to get rid of the commas. I can do this easily enough with the edit replace. But this table will be constantly updated from the main frame Db. I want to build it a... 29 Apr 2010 21:29

Convert to Proper or Title Case in Access 2003
I am trying to convert a field that is in all CAPS to Proper Case. Ex: Field Name is First Name, contents "ROGER". Desired way for First Name field to show on query results is "Roger". ... 29 Apr 2010 18:05

Dave Ashish method of updating from previous record
I need to enter the Height of the patient every time the form opens. The name of the control is [Fld37]. Yes I will name it better next time! I used Dave Ashish method and entered the expression in the default value of the control's data. The following is the expression it created after I typed in the code ... 1 May 2010 01:11

Need null values for several fields in db
I have an equipment inventory db. I need to run a query that would give me the records that contain null values in several of the fields. I have run a successful query to return records that have a null value in one field but don't know how to combine so that query returns records that also have null values i... 29 Apr 2010 15:49

adding a new customer
Ok, I have been away from Access for a couple years now and was only a moderate user to begin with. I am trying to build a database in 2007 that has several details or fields about a product. I have a drop down list of customers to choose from in the customer field, but if an operator comes across a customer that... 29 Apr 2010 22:35

Query crosses 3 tables
I have 3 tables. tblPatient contains ID, Name, Age....., tblAdmission contains ID, PatientID, AdmissionDate....., tblCertificate contains ID, PatientID, AdmissionDate..... How to combine the following 2 queries into one that crosses 3 tables? (Please note that the WHERE clause in the second query has error by ... 29 Apr 2010 19:14

Query Criteria
I have a query where I am trying to get a count of items. The first column is: Less than 10: (IIf([Days in Queue]<10,"")) This gives a count for each queue that has been under 10 days and is working correctly. I cannot get the criteria to work for the # ranges after that. I want it to return the count for any... 29 Apr 2010 13:33

Count by Date
I am trying to create a query that will capture how long a particular record has been in a queue. I have another query called Status of Item. This query has the following Fields: ItemId, Date Entered, and Queue. Now I need my new query to group the Queues and count the # of ItemId's by how many days from when i... 28 Apr 2010 22:00

split up one field into multiple fields
i am looking to split up a field into multiple fields. we produce steel tubing and the way our product show in the system is a little tricky to work with in access. here are some examples 8 x 4 x 1/4 = 8.4.14 6 sq 3/8 = 6.38 4 x 3 x 6 ga = 4.3.6 5 round .375" = 5000.375 3.5 nps Sched 40 = 35.S40 4-1/2 x 2... 28 Apr 2010 18:37

Concatenate multiple rows
@Duane Hookom I have a similar problem as above, but this link no longer works. Any current advice? "Duane Hookom" wrote: There is a generic function with sample usage at http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane -- Duane Hookom MS Access MVP -- "Cydney" ... 28 Apr 2010 22:00