Running & Setting Up Queries - Page 1005

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 access, if then statement by dtretina if (Escalation/Assignment = 0) or (Updateheat = 0 )or (Worklog = 0), then 0 for the total. Else total. How would you set this up in design query? Each of...	June 7th, 2010 09:13 PM by KARL DEWEY	2	7,277
in access, round up to nearest fraction(.5) by Stephengw In MS-Access, How do I round a formula result up to the nearest fraction (Specifically the nearest half). Example: 1.3 rounds to 1.5, while 1.7 rounds up to...	May 19th, 2010 07:56 PM by Daryl S[_2_]	1	1,193
In Access, Where do I find SQL Query Builder for forms; unbound co by Caren Hi, please let me know how to get to the combo box drop-down list and how to modify this list. Also I'd like to know SQL statement Query Builder. Thanks.	September 11th, 2007 01:49 AM by John W. Vinson	1	63
In an access Query how do you get data for the current month by Dram I would like to extract data for the current month only from my data base based on a receipt date. formated as mm/dd/yyyy I can get todays stuff and last...	May 21st, 2008 03:53 PM by Dram	3	151
In an access query, how do I set criteria for "most recent" date? by dukejam I'm trying to find the last time I reviewed a portfolio for each of my clients. This would be similar to finding the most recent order from each customer. ...	January 10th, 2006 03:20 PM by dukejam	8	98
In and Exists subqueries by Chris Kennedy Is there an equivilent of the 'in' and 'exists' keywords in Access. I am used to SQL Server. Regards, Chris.	March 23rd, 2005 01:41 PM by Chris Kennedy	1	77
In and out qty by roystonteo via AccessMonster.com Dear All, Please advise me if this is wrong. I have a table. PartNo, Qty, Movement The movement has IN which has a positive number. The movement which is...	January 17th, 2009 01:12 AM by roystonteo via AccessMonster.com	3	62
In between dates with a different twist by Keith I need to capture the month and year that the falls between two dates. But the between dates are capturing some dates in the previous month too. An example... ( 1 2)	October 24th, 2005 04:45 PM by Keith	10	216
IN clause error by SL I have a series of queries in a report database that pull information from other Access DB's and display it in one summary report. This was working fine,...	August 17th, 2009 06:19 PM by KARL DEWEY	1	103
In clause from form by QB Is there a way to setup a cbo ctrl to be used as an In clause within an SQL statement? I set one up In (!.) Where my cbo returns value like 'Open' and...	October 3rd, 2009 06:19 PM by John Spencer	4	127
IN Clause in an append query by mbynoe via AccessMonster.com Can someone please tell me why this query isn't working correctly: INSERT INTO workingnew ( meter_number, meter_name, prod_date_time, meas_dth, meas_mcf, BTU...	November 2nd, 2006 10:06 PM by mbynoe via AccessMonster.com	5	81
IN Clause Question by jutlaux I have a query that is linked to a table (tblDOTID) in another Database (Lookup.mdb) that is set up with the IN clause as shown in the SQL code below. Both...	January 14th, 2009 12:00 AM by Allen Browne	1	72
IN Clause using multi-select form parameter by thorn2fish I am having a problem where I get empty query results using a multi-select listbox as a parameter to a query. I have coded a MS Access form to feed the...	October 24th, 2008 05:19 PM by thorn2fish	6	181
In crosstab query, how do I count not including duplicates? by Ojoj I have a table which lists contacts with people including the field 'FamilyID'. I want to count the number of different families the organisation has had...	February 25th, 2010 07:43 PM by John Spencer	2	206
In Excel this would be a "lookup"! by HelenJ I have a table that lists the and the number of prizes that will be given for this number of entries , I also have a table of Entries. I now need to count up...	April 4th, 2005 01:33 PM by HelenJ	1	72
IN in query by Robert Painter Hi, I have the following query: Private Sub cmdOK_Click() Dim db As DAO.Database Dim qdf As DAO.QueryDef Dim varItem As Variant Dim strCategory As String Dim...	February 20th, 2009 02:50 PM by Michel Walsh	8	91
IN like clause? by Dan Does Access have the equivalent of the SQL 'IN' clause? TIA, Dan	August 16th, 2005 10:45 PM by Douglas J. Steele	1	109
In MS Access how do a only show the 19999 of 0~19999 in a column? by Tim S I am trying to write a Acces query where I only show the part after the ~ sign in a column? I know how to do this in Excel but can't figure it out in ACCESS....	March 21st, 2006 05:32 AM by [MVP] S.Clark	2	56
In MS Access SQL, what does ! do? by Bill I need to know it means in the situation whe ! QUANTITY_PURCHASED is a column in the veiw VW4_QUANT. I need to know before 6:00 Eastern 12-2-04. thanks	December 18th, 2004 10:53 AM by corey lawson	2	109
In MSAccess einen Timestamp aus einer UUID herauslesen by Chaote Ich habe eine Tabelle welche die Keys alls UUID hat, nun will ich diese in die richtige reienfolge sortieren. Aus diesem Grund muss ich aus der UUID den...	February 16th, 2007 01:17 PM by Chaote	0	164

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