Running & Setting Up Queries - Page 407

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Thread / Thread Starter	Last Post	Replies	Views
Reformatting an address that has been pasted from a report by luvspeanut I have an address that has been pasted into the database as one big field. I need to format it into individual fields so I can work with it. This is how it...	October 21st, 2008 04:57 PM by luvspeanut	5	114
Like operator and wildcards, compare fields by titlepusher I have 2 tables. Both contain a Name field. I need to check against and variants of . example: if is "Old SPG Land Co." and is "SPG Land...	October 21st, 2008 03:57 PM by Fernando Loizides	2	124
MAX Value Across Multiple Rows. by Muse Need to get the top diagnosis in terms of paid dollars for each member for the data set below. I tried using MAX and group but it returns the records that...	October 21st, 2008 03:42 PM by KARL DEWEY	1	116
Case-sensative query by AccessChick Hello, I am trying to query a text field to return the count of entries by case, ie count of Mixed Case, lower case and UPPER CASE entries. Is this at all...	October 21st, 2008 02:42 PM by Michel Walsh	5	78
Updating a Table by Michel Walsh UPDATE table2 RIGHT JOIN table1 ON table2.POid = table1.POid SET table2.POid=table1.POid, table2.SomeData = table1.SomeData, table2.SomeOtherData =...	October 21st, 2008 02:39 PM by Michel Walsh	0	87
What am I doing wrong? by pam I'm trying to design a query that will give me total hrs by adding the "duration" for coaching hours used as well as hrs per student. There are thirteen...	October 21st, 2008 02:35 PM by pam	5	82
how to find the second largest date or a number from a field in ac by Jazz I need to find out the previous date than to the maximum date from a date field	October 21st, 2008 02:09 PM by Stefan Hoffmann	1	107
IIF IsNull in a SQL not working. by gtslabs I have a Query in my Record Source of a Form. It references 2 combo boxes. I want to display records based on both boxes or if Box1 is Null then only Box2 I...	October 21st, 2008 12:51 PM by Dale Fye	3	99
Date Evaluation by dave rivera I am attempting to evaluate the number of days it takes to complete tasks. Results can be same date for both start and end dates or end date greater than...	October 21st, 2008 12:37 PM by Dale Fye	1	87
Date Evaluation by dave rivera I am trying to evaluate how long it takes to complete tasks. Results can be one of two - either the start date and end date are the same date = 0 or the end...	October 21st, 2008 11:54 AM by dave rivera	0	83
Combine Few Records Into One Records by Ahliank Hi All. I want to combine this few record in a record with this format Original Records ex: A 1 A 2 A 3	October 21st, 2008 11:22 AM by Allen Browne	1	80
Two queueries - same table - different totals by Love Buzz Hi all. OK, I have two queuries that are pulling from the same table. One is a Summary and one is a subtotal of the queues that make up the type. The...	October 21st, 2008 07:52 AM by Rob Parker[_3_]	1	138
Updating a table with a query by John Hello, I am needing some help - I have 2 tables. #1 = Current PO information #2 = Orignial PO Information Table #1 is being pulled from another database, the...	October 21st, 2008 03:35 AM by John	8	82
Automatic Numbering Titles by Jorge mst Hello I have MS Access 2007. In a table I have the ID and the numberOfTitle In a consult I have the ID and Title. In numberOfTitle I say the number of the...	October 21st, 2008 01:30 AM by Lord Kelvan	2	62
Import data from Excel by Boon Hello, I have a big excel file that contains 80 columns and 35000 rows. I have about 20 of this files. I would like to import all of them into Access. What...	October 21st, 2008 01:14 AM by Lord Kelvan	2	77
Pulling text from parenthesis by Victoria I need to pull text from a parenthesis where there is text on both sides of the desired info. For example 11294GGsewrf PPO asfdio(dfjios)sd/12 I'm using the...	October 21st, 2008 01:03 AM by Lord Kelvan	2	85
Deleting from main table instead of sub table by sherriross81 Thanks that worked perfectly. I didn't know I could write sql like code with this program. That will be very helpful for future projects. "Dale Fye"...	October 21st, 2008 12:54 AM by Dale Fye	1	106
bring related fields into a query that uses MaxofDate and GROU by Lord Kelvan SELECT DISTINCT latestgpsrecord.Individual_ID, latestgpsrecord.MaxOfdate, GPSLocations.LongWGS84, GPSLocations.LatWGS84 FROM . AS latestgpsrecord INNER JOIN...	October 21st, 2008 12:52 AM by Lord Kelvan	0	124
What's wrong with my SQL stmt? by Gator I get the error... Syntax error (missing operator) in query expression " = "18708960" or where = "19995601" or where = "17726948" here is my SQL...	October 21st, 2008 12:14 AM by John W. Vinson	5	98
query Qtrly info for non-traditional quater period by Toni I would like to print a summary of quarterly information and am having problems with the select statement The table has a RebateAmount and RebateDate which...	October 20th, 2008 11:39 PM by Toni	5	70

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed