Running & Setting Up Queries - Page 166

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
Sort by text by abigiggle I am a novice to Access : is it possible to sort a database of education establishments by creating a query that will find only schools containing the text...	September 3rd, 2009 03:39 PM by Dale Fye	3	132
Query with = Parameter by joykairos I need a report that will pull a certain age population, and would need a query to pull the employees that are 24 years old and younger and 65 years old and...	September 3rd, 2009 01:33 PM by joykairos	2	102
Help writing Query by tweety Hi, I am new to access and am trying to create a query but are getting nowhere fast, so hopefully someone can help me. I have 2 tables (imported from excel),...	September 3rd, 2009 07:47 AM by tweety	2	86
How could I combine these 2 queries into one in Access 2007? by Aldred@office Hi all, Now I have 2 queries, I was asked to display them in the same view in a form as Datasheet view. Query 1: SELECT PartNumID, Manu, POOutNum, PartNum,...	September 3rd, 2009 05:24 AM by Aldred@office	2	94
Parameter passed from a form to a query by Joseph Greenberg Using Access 2007. I have a simple form with an opton button array. I want to pass a paramter based on which option value is selected (there is a default...	September 3rd, 2009 02:47 AM by Joseph Greenberg	4	80
IIF with wildcard and OR... by NWO Hi. Here is my statement: Class: IIf( Like "E1","1st Preference") Or IIf( Like "E2","2st Preference") Now the first IIF works just fine, but I want to...	September 2nd, 2009 11:35 PM by Ken Snell [MVP]	1	116
Query Sorting by jmm1954 I have 3 tables tbl 1 is rates tbl 2 is truck info by employee (an emplpyee # and assigned truck number) tbl 3 is daily detail for loads hauled (assigned...	September 2nd, 2009 11:14 PM by jmm1954	5	115
Delete duplicate records by Opal[_3_] I am trying to create a query that will delete a duplicate record in a table. I want to delete the older record and keep the new one created. I have used the... ( 1 2)	September 2nd, 2009 09:37 PM by Opal[_3_]	17	203
displayFormat (non-SQL programmer) by Guitarzan Gretings, I am combining data from two separate tables that join together via a common ID. Table A has fewer records than Table B. In the query, Table A is...	September 2nd, 2009 09:23 PM by Guitarzan	4	110
Expression Multiplying Hours by a Number by 71605 I am trying to come up with an expression that comes up with total man hours. I have a query that calculates the total number of time spent. I am now having...	September 2nd, 2009 08:58 PM by KARL DEWEY	1	140
Update query - sequential numbering by Mackster66 MSAccess 2003 Windows XP Pro Access front end, SQL back end I have a table "EVMASTER" that contains evidence information. There is a field "OCA" for the...	September 2nd, 2009 08:40 PM by vanderghast	3	201
MS Access 2007 Cutting Text from Field by Musa via AccessMonster.com Hello, I created this db in MS ACCESS 2003 and recently our office upgraded to MS ACCESS 2007. Everything was working fine, until a User noticed that after...	September 2nd, 2009 07:28 PM by Musa via AccessMonster.com	0	109
inner join sytax error, missing operator. by Gluefoot pretty new to creating queries using SQL in Access. i have the following SQL command but it says I'm missing an operator. I can't figure out how to fix....	September 2nd, 2009 06:55 PM by Bob Barrows	2	89
Query by Form "blows-up" when query is closed and re-opened by Kodawari I am having a major problem with a â€œquery by formâ€ â€œblowing upâ€. I am using the following query on the criteria line: !! Or !! Is Null Everything...	September 2nd, 2009 06:33 PM by Daryl S[_2_]	1	111
Group By and Grouping by Steve[_77_] Are the Group By clause in queries and Grouping in reports related? Thanks! ( 1 2)	September 2nd, 2009 05:01 PM by John... Visio MVP	15	118
Update Form by casih I have a main form called Members Overview and a sub form called Case Details. I wish to have a command button on Overview which will open a new Case Details...	September 2nd, 2009 03:48 PM by KARL DEWEY	3	77
Query export as Table by Hazzy I am using access to manupulate a huge data set and the database is getting really slow. Is it possible to export the data in a query into a table in a new...	September 2nd, 2009 12:11 AM by John W. Vinson	2	101
IIf Query assistance by rebeca I'm looking for assistance with the below query. I need the query to look for the previous entry for "RunningSum". For example, if I am running a report for...	September 1st, 2009 10:39 PM by Rebeca	7	122
Reports are only totaling the fields for the first record by zufie I found that the my reports are only totaling the fields for the first record so I must modify or create another query to resolve this. How do I fix...	September 1st, 2009 09:13 PM by zufie	2	117
How do I add a column that calculates the product of two fields? by Elizabeth Here's my current SQL code (which works BEAUTIFULLY, by the way! Thank you, Discussion group for your assistance and allowing me to plagarize,...	September 1st, 2009 09:09 PM by KARL DEWEY	2	113

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