Running & Setting Up Queries - Page 1003

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
IMPROPER RESULTS IN A QUERY by ED C =!! And =!! EX 04/01/2007 TO 04/30/2007 I AM GETTING A RESULT THAT IS NOT INCLUDING 4/30/2007	May 14th, 2007 06:24 PM by ED C	2	85
Improve adding tables with long names in Access Query Editor by HTG1 The dialog that allows you to show (add) tables and queries to the Access 2003 Query editor does not does not cater for long table and query names. It...	July 26th, 2006 09:29 AM by HTG1	0	79
Improve Performance by LeAnn I'm not sure if anyone can help me but I would like to speed up the output of my report. I have a stand alone Access 2003 database located on our file server...	March 18th, 2006 05:40 PM by John Spencer	2	52
Improved & Controlled Se-xu-al Pleasures & Sensations... by Jonhy Ambrina is a magic pill of the new millennium. It is most stimulating, vitalizing and harmless herbal sex tonic for men. Ambrina rekindles passion and enhances...	November 28th, 2008 11:10 AM by Jonhy	0	93
Improving append query speed by HKKS Hello, I have an update query that works well and at good speed ONLY IF I use a single field in the append query, such as "LastName". But my pull down combo...	July 27th, 2009 02:06 AM by HKKS	2	108
improving performance by indexing query criteria fields by Paul James In Access Help under Performance, it says that you can improve query performance indexing any field used to set criteria for the query. It also says to index... ( 1 2 3)	February 16th, 2005 07:55 PM by Tony Toews	20	796
improving performance of union query by JoeA2006 I need to access data from several large tables approx 1 million records each. There is a table for each month in a separate database over 300mb each. I need...	May 17th, 2007 08:58 PM by Jerry Whittle	1	88
Improving queries resource usage by John Hi I have a 10 user access backend/front end app which runs sufficiently ok. Recently I deployed a winform/ado.net app that runs a sequence of queries on...	July 22nd, 2008 04:38 PM by William Vaughn \(MVP\)	5	113
improving query performance by Bart Hello, I have a number of queries in an application that all reference a single key field in a table to set the selection criteria for each query. I can...	November 20th, 2007 04:58 PM by Bart	0	68
IN (Select ... ) in Query criteria by Cydney Can someone please explain to me how and when to use an IN(Select ... ) statement in the criteria grid of a query? I've seen it used, but I don't understand...	September 6th, 2005 05:00 PM by Cydney	2	67
IN A COLUMN OF 7000 RECORDS FIND 9 LOCATED IN THE 4&5 AND 7 POSIT. by Essie In a column of 7000 records how can I find only those that have 9 in the 4th&5th or 7th column?	March 7th, 2006 05:14 AM by Duane Hookom	1	76
In a Join, 0 doesn't join -0; why not? how to workaround? by Dick Watson I have a table of transaction data. In the imported state of the data, there are may cases where the same transaction is in there in two rows from...	June 20th, 2005 01:33 PM by Dick Watson	2	104
in a mailing list there are 1,2 or 3 to choose from,choose 1 or 2 by dees using filter by form, i'm trying to filter the list to show (eg) the mailing list priority 1 or 2 (out of a possible 3).. i typed in =1or3 but that didn't...	May 19th, 2005 05:28 AM by dees	0	78
In a multi-user database, how to restrict access to records by Bikerman Problem In a multi-use database, how do I restrict a user from having access to certain records and allow it for others. The scenario is as follows: The...	July 7th, 2004 07:46 AM by Allen Browne	1	457
In a query (in criteria) how do I promp for a "substring"? by Wendel Silva I need to have the query promp for an input, and with that input, I want to return all the entries that contain such input as a substring. Thank you.	May 18th, 2006 05:09 AM by Allen Browne	1	88
in a query for only black colored dogs in a created table how do . by davko i have a table listing dogs and thier colors. I need to make a query to find only the dogs with black as one of thier colors as some dogs are listed as having...	March 14th, 2005 06:32 AM by John Vinson	1	83
in a query having the between dates and also a sum by Asha I am trying to create a query where the user will require to enter the from and to date and also the query to create a sum of the amount field. When I apply...	November 10th, 2005 01:05 PM by Jeff Boyce	1	54
in a query return a zero for values that do not meet criteria by Need Help With a Compact and Repair Erro I can not figure out how to get a zero to show for values that do not meet the criteria if that is possible.	May 16th, 2006 01:22 PM by Duane Hookom	2	65
in a query test on date to see if it falls between two date date? by date calc in query in access 2002 I have a table that has three dates, lets asay 7/1/2006, and I have to other dates that crate a date reange, lets say 6/28/2006 and 8/1/2006. I want to check...	June 1st, 2006 04:34 AM by Arthur	1	62
In a query, create an average field when another field is a match by Pre_Live_Wire I have a Query that uses one field as the main catagory (Plant Variety). I would like to create a field that when the plant name matches (field 1), then the...	March 1st, 2006 01:47 PM by Pre_Live_Wire	4	90

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