Running & Setting Up Queries - Page 1006

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
In my crosstab query I want it to enter a "0" for null values. by Amber1805 I'm running a crosstab query and in my sum column I want it to put a zero if there is no value. I know how to do it with regular queries, but am running into...	August 15th, 2006 06:37 AM by Duane Hookom	8	130
in need of subquery help by djmentel Here's my table (MyTable): employee_id dependant_id effective_date last_name first_name 12345 0 1/1/1999 ...	April 24th, 2005 11:21 PM by Marshall Barton	1	76
In need to test if a task has happened in six month increments... by Kelvin Beaton I'm working on a tasks due list and need an entry to show up if task has not yet happened in current (or past period) 30 day period. I have clients that have...	November 1st, 2006 07:30 PM by KARL DEWEY	2	69
In operator question by Tony Hi, Does anyone know how to use the In() operator in a parameterized option in the sql where clause in MS Access 2000. For some reasons, When I try to use the...	September 22nd, 2004 03:57 AM by Duane Hookom	3	241
IN or INStr help by HB Here's the scenario, Members (parent) have (child) Skills. Skills uses a lookup table so it stores numbers, not strings. I want a parameterized query where the...	February 7th, 2005 03:32 AM by Ken Snell [MVP]	2	130
IN Predicate in UPDATE statement by [email protected] I have an update statement that uses the IN predicate the exclude a list of values from another table. However, I would like the values to have wild cards at... ( 1 2)	February 10th, 2007 10:00 PM by [email protected]	10	159
In query by Chris Kennedy I have two tables with some duplicate filenames in a field. I want to extract the ones in the tmpfilenames that aren't in the tblWeb table. This returns...	April 12th, 2005 11:40 PM by MGFoster	1	72
In Query Design, No queries in add new table/query dialog box by mike_mike Hi I have queries in my database. When i go into query design , +add table, no queries are in the queries tab of the show table dialog box. Has anyone...	May 16th, 2005 05:55 AM by John Vinson	3	250
in query it states 'record is deleted' but I have not deleted it . by Problem with queries in Access In Access I have 3 tables linked together, from that I have made reports through the query. This has been working perfecting for some time now. But today, I...	May 30th, 2006 12:46 PM by Allen Browne	1	62
In query records returned multiple times by Serendipity Using Access 2003. Trying to make a grading report that groups on fldyear, fldquarter, fldSubject, fldLN/FN (trimmed field) and fldGradeWeight then I want to...	February 24th, 2007 01:52 AM by Serendipity	6	159
In query wizard request sums in summary but get detail. help by BB When building the query with the wizard, I check "sum" for every field, but get a detailed listing when I perform the query. I can not figure it out. I've...	March 3rd, 2005 02:35 AM by Duane Hookom	1	71
IN SELECT Query Criteria by Cydney I think I read somewhere that using an "IN SELECT..." type of query will speed up your query performance in Access 2003 better than linking the two tables by...	September 28th, 2007 06:02 PM by Michel Walsh	9	141
In String - Urgent Request by Sean Is there a way to use the in string function to pull out text if you do not know the position of the text you are looking for? For example, if my string...	July 10th, 2009 12:57 AM by John Spencer	5	111
In VBA how do I link the fields of a form to an on-the-fly SQL que by garywed Hi. I have a form whose fields are linked to an underlying table of constellations and their variable stars. When the form opens it is initially linked to...	July 7th, 2007 06:30 AM by garywed	4	95
in vba: Get list of all tables involved in the query by AC[_2_] Hi Is there an easy way in VBA to get a list of all the tables that are involved in a particular query/sql_string? I have made a couple of dummy examples...	May 12th, 2009 09:23 AM by Allen Browne	4	105
In([variable]) by undrline via AccessMonster.com I know that In (123,456,789) will work in my query criteria. But I want the user to be able to type in any set of ids. I don't want to give them a hundred... ( 1 2)	February 1st, 2007 06:48 AM by undrline via AccessMonster.com	14	251
in-line function in queries by R Weston I'm attempting this in a query , but i get the error: "unknown function in 'Date' in expression" Could someone point me in the correct direction? ...	June 14th, 2004 07:58 PM by R Weston	3	161
IN-Predicate means OR - I need AND by [email protected] Hello, I have a table like this: tblEACodes: ============================== SK AQ_FKEY aqeEA_FKEY == ======= ==== 10 26 6 21 ... ( 1 2)	May 19th, 2008 04:06 PM by [email protected]	11	189
in/out query by realspido Hi, I have a table: Emp_no Date Time In/out 58001 27/7/06 7:01 In 58001 27/7/06 8:23 Out 58001 ...	July 31st, 2006 11:14 PM by Michel Walsh	1	79
in/out query by realspido Hi, could anybody help me with following problem? I have a table: Emp_no Date Time In/out 58001 27/7/06 7:01 In 58001 ...	August 1st, 2006 01:08 PM by David F. Cox	3	74

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