Running & Setting Up Queries - Page 997

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
Multi expression(different condition) in one queries by mohsin via AccessMonster.com Hi there My queries as below; SELECT NetName, Date,Hour, Sum(Total) AS CG0, Sum(Total) AS CG1 FROM totalcc_hour WHERE ((()="000" And (()="010" Or ()="011" Or...	March 20th, 2007 10:03 AM by mohsin via AccessMonster.com	7	77
Multi Dlookup in a query with grouping by ZigZagZak Can someone help me with this queries SQL? I have been beating my head on the desk for hours and can't figure out how to get the CPI: value to work...	July 22nd, 2009 11:31 PM by ZigZagZak	2	115
Multi dated query by Dan I put the criteria (date()-7) in a query field. It gives me what I want from that field. However, I have more date fields and would like them all to...	December 16th, 2006 09:11 PM by hrtrst	3	73
Multi criteria selection / filter by Schmidtnikov Any help is very much appreciated. I have a table with 543 records, and I need to scale down to 267 via a query to then update an existing table with the...	October 22nd, 2009 03:51 PM by KARL DEWEY	1	102
Multi Criteria Query by Rob Hi, I have a couple of joined tables in a query which if run to return say the number of people who started after 27/03/2004 works fine, however if I add to...	April 3rd, 2005 12:11 PM by Rob	2	87
multi column to 1 query by Anton I am trying to create a query that selects data from 15 or 20 columns. The unique results should be presented in a single column, so it can be used as a pick...	July 29th, 2004 01:15 PM by Anton	4	213
multi calculations by Dan @BCBS I have to perform multiple calculations, based on a date field, for a report. The field is called = "IssueClosedDate" all the calculations are based on this... ( 1 2)	January 18th, 2007 03:20 PM by Dan @BCBS	11	216
Multi by rob p Made a query that runs when I run a report. Query has one field call Field 1 and one called Field 2. Field 1 could be 8, 9, or 10. Field 2 could be 1, 2, or...	December 7th, 2005 11:57 PM by KARL DEWEY	1	61
mulltiple column "not in" query by icccapital Is it possible to perform a multiple column "not in" query in access? I created the query select * from climktvaluefromgroups c where (c.group, c.invdate,...	January 15th, 2010 04:18 AM by John W. Vinson	6	108
mulitple select list query by Newbie Hello, I have a simple salesperson and sales history query. How can I create a form and subform like the following: Main form has the first select from...	December 6th, 2005 05:17 AM by Tom Ellison	1	58
Mulitple IIf statements - Too many by AccessIM How many nested IIf statements are allowed in a single query field? I have a list of 41 slot ranges with corresponding section numbers. I am trying to use a...	January 26th, 2007 09:00 PM by AccessIM	5	264
MULITPLE IF STMNT EASIER by jeanne Does anyone know how to write this easier? SELECT , , , , , , , , , , , , , , , , , , , , , , IIf(="STEP UP","YES",IIf(="STEP UP","YES",IIF(="STEP...	October 25th, 2004 09:25 PM by jeanne	9	245
Mulitple Categories in a query by Paid The Umpire I have a table which contains ten different categories: A through J. With the following of field... Category, Score, Player1, Player2, MatchID I'm trying to...	November 23rd, 2006 07:45 AM by Paid The Umpire	3	83
Mulitiple Records fro mthe same table ? by Paul Dennis I am trying to workout the total time within a month that a type of server has been unavailable, which is proving dificult. Table:...	February 17th, 2006 12:31 AM by KARL DEWEY	2	68
Mulit. Sums by Renetta I have a report that is sorted by fund number and sub totals for each field with in the funds. Now I have a two-part question. I have sub funds field with...	October 28th, 2006 07:52 PM by Chris2	3	86
Muliptiple Records by Joe[_19_] I have a database with two tables. Once table list the primary information and the second table list the maintenance records. Basically, like a car's...	August 4th, 2008 06:47 PM by John W. Vinson/MVP	2	117
Muliple queries by Tom Hi, I have a Query 1 with Column A and Column B Query 2 with Column C and Column D Now, I'd like to combine these queries like Query 3 with Column A,...	September 8th, 2006 10:08 PM by Tom	2	47
Muliple Critera by K Hello, I have a query that refers to fields in a form to search. Form (frm1) Field names / search critera are as follows: Date Start Date End Branch /...	January 21st, 2010 02:38 PM by Duane Hookom[_4_]	1	159
Muli layered query by Rich Hi, I currently have a table that has consists of two (relevant to this problem) columns. Column one is all the owned properties, column 2 is a list of all...	June 22nd, 2004 02:44 AM by Rob	1	84
Much Better Description by Gary B ClientTable: ClientPrimaryAutoIncKey ClientName ClientHistoryTable: ClientHistoryPriAutoKey ClientForeignKey ClientHistoryNote In this One To Many...	October 28th, 2005 03:03 AM by Gary B	0	67

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