Running & Setting Up Queries - Page 1001

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
date confusion by UGAJohn I would like to run a query to determine if a datetime field in table1 falls between start date and end date in table2. If so I would then like to assign...	February 2nd, 2010 07:17 PM by cm	2	103
Form to Execute Query by ADonMS This issue was probably already addressed in this forum, so I apologize for the redundancy. I created a multi selection form that uses SQL to run the...	October 12th, 2009 06:21 PM by ADonMS	0	103
Populate a field in a query with the value of record by Ben8765 Hello, I would like to make a query (based on a table) do this: Where the value of FieldA = D, get the value of FieldB of that record, and populate Expr1...	October 15th, 2009 12:33 AM by Bob Barrows	4	103
ODBC Call failed by Jim[_67_] The below query snip works fine WITHOUT the WHERE clause. As soon as I put in the WHERE clause I get an "ODBC Call Failed" (the tables are linked) SELECT...	October 22nd, 2009 08:00 PM by Stefan Hoffmann	3	103
access query to do the same as excel =IFSUMS by Ghurka I need to caluclate the maximum number of tanks by chemical that are on a lot on any given day over the course of the reporting period. The reporting period...	October 25th, 2009 04:08 AM by Ghurka	2	103
Long Date - Can't pull records accurately by Bonnie A Hi everyone! Using A02 on XP. I get an extract from systems each week with data that we use Access to analyze. Of 4 date fields in my Access import table,...	October 28th, 2009 09:01 PM by John W. Vinson	3	103
Adding a comma after a field by LG If i am using =( + " ") & this in a text box how would I be able to add a comma after the L_name when it addresses the member? Ex currently the above...	October 28th, 2009 06:33 PM by Jerry Whittle	1	103
How to find previous, current and future values by DawnTreader Hello All I have need to know in one "line" the previous value, current value and the "future" value. here is my scenario. i have a "service report", these...	November 4th, 2009 07:04 PM by DawnTreader	1	103
Why I get "Type Mismatch" by Kostas Why I get "Type mismatch" with this code (VBA) The 'sale_Date' field is date/time field ----------------- Dim strSQL as String Dim dbs As Database Dim...	September 6th, 2004 03:50 PM by Allen Browne	1	102
Create Aggregate function by Pross I am working on a project where I have to calculate the geometric mean of a set of values from an Access table. I know that it is possible to create my own...	September 3rd, 2004 02:51 AM by John Spencer (MVP)	5	102
Select Top 20 by Scott Reynolds Hello! Could someone please tell me why this query does not show top 20 Products ordered by Hits? SELECT TOP 20 Id, ProductName, Hits FROM Products ORDER BY...	August 29th, 2004 03:02 PM by Jeff Boyce	5	102
calculating in query by hermie I have a table with soccer results and want to calculate th e points of the won lost or equal gamein a query. Example: result portugal - holland 2-0 gives 3...	July 6th, 2004 07:00 PM by hermie	2	102
save a query as a table by JR Is there some method that will allow me to save an existing query as a table? Thanks, JR	July 12th, 2004 04:07 PM by	1	102
Add leading zero by Jay Location_Num Machine Number 06 DUD006 07 DUD007 07_1 DUD07_1 08 DUD008 09 ...	July 14th, 2004 06:55 AM by John Vinson	1	102
stripping off the end of data in a field. by susan Subject: stripping off dash From: " Sent: 7/15/2004 9:01:46 AM It still...	July 15th, 2004 07:49 PM by Frank Stone	1	102
Pull Fields From Multiple Tables by WDP Hi: I have "inherited" an Access Database that has several hundred tables. I don't know why it was setup this way...but it had to be a beginner that did it. ...	July 23rd, 2004 04:52 PM by Douglas J. Steele	1	102
Too many fields defined??? by MChrist I have some very lengthy and complex queries I am running that has about 45 columns in it, and once I'm done with the subqueries, I am using a UNION ALL...	August 1st, 2004 02:06 PM by Jeff Boyce	1	102
Parameter with a List box by Colby My mdb works off of two main companies (A and B). I am trying to build a parameter query that instead of just asking which company it should run for; I want a...	August 11th, 2004 07:05 PM by Colby	2	102
Calculating columns by Taher Hi there I have a table and I need to obtain the sum of all of the values in a particular column. Firstly, how do I distinguish which column I want to sum up;...	August 20th, 2004 07:32 AM by John Vinson	2	102
Calculating Weekly Totals by Van I have a data base in Access XP that tracks total number of visits each Friday for 6 or 7 years. I want to count the number of visits for each year. My query...	June 26th, 2004 04:35 AM by Ken Snell	1	102

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