Running & Setting Up Queries - Page 104

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.

		Home » OfficeFrustration forum » Microsoft Access
Running & Setting Up Queries

Home

Page 104 of 2165

104

Threads in Forum : Running & Setting Up Queries

Forum Tools

Search this Forum

Thread / Thread Starter	Last Post	Replies	Views
Use of "LIKE" in a SQL string by XP Using Office 2003 in Windows XP; I have the following query that neither raises an error nor functions: UPDATE " & gcTable1 & " SET DEPT_MINOR = 'Library'...	January 23rd, 2007 07:27 PM by Michel Walsh	1	100
Use of "In" in parameter queries by Fred Zack Basically In does not seem to work in a paramter query. I would like to have a parameter that asks the user to input a list of subject numbers to analyze. I...	October 21st, 2009 06:58 AM by Proposal Doctor[_2_]	4	113
use month & sum in grouping query by Ian Elliott Thanks for any help. I don't know much about queries, so I don't know if this will work, but I have two queries in a database, and I would like to consolidate...	September 24th, 2008 01:35 PM by John Spencer	1	81
Use List Box to select a paramter for a query by jeh For the first time I'm trying to base a query on a user selection via a list box. My simple test db has one table, two forms and two queries. Tbl_1 contains...	November 21st, 2006 12:40 PM by John Spencer	5	84
Use Left() function to update field by Nick X Hello, I have a table that I pain-stakingly created from a word document (long story, very long). Now that I have everything situated in the table I need to...	July 7th, 2005 06:00 PM by Nick X	6	141
Use InStr to find Excel carriage return by Judy Ward I am importing an Excel spreadsheet into Access. There are several columns where a carriage return has been used to separate the data in the field. I would...	November 4th, 2007 03:44 PM by Judy Ward	4	142
Use Insert Into to insert multiple records by Kenny A. I have a table that gets replaced each month with new data from a feed, no problem. I need to insert into this this table once the new values are there, the...	July 30th, 2007 03:03 PM by Jeff Boyce	9	69
Use If statement with AND operator in query by Ac Hello, I would like to write an If statement with the AND operator in a field in a query. For example: I have a total yearFee, and have to divide by 12 and...	August 13th, 2007 03:54 PM by Ac	2	90
Use Function in Query problem by Co Hi All, I'm trying to run an access query using a function I created to tell the query what path to use. Public Function QueryVar(ByVal sPath as String) As...	February 23rd, 2008 06:23 PM by Dale Fye	6	120
Use first record found in expression? by CASJAS My calculation is coming up with two different values for the following SQL: SELECT A.ID, A.Site, A., A., A., ((C.-B.) /(C.-B.)) ( 1 2)	July 22nd, 2004 09:21 PM by Tom Ellison	17	2,121
Use first 3 characters in query by Ben Hi - I have two tables - BAL_ACT and APS. In the BAL_ACT table, there is an Acct_nbr field that is 9 characters. In my query, I want to "join" the first 3...	May 14th, 2009 05:28 PM by John Spencer MVP	4	85
Use field values as names names? by PayeDoc Hello All Is it possible to get the field name for a query from DATA within the underlying tables? e.g. Table with text field 'practice' (related to key...	June 8th, 2009 07:26 PM by vanderghast	5	173
Use field to select but not group by? by Ann Scharpf Is it possible to use a field to select data but not use it as a group by criterion? Here's what I'm trying to do: Select all time record with a date...	November 13th, 2008 10:04 PM by Ann Scharpf	4	63
use field list from form to specify query fields by jrizzo77 Hello, I want to have the user select a field on a form via combo box and use it to define the fields in a query. The combo will show the field list from the...	May 21st, 2009 03:21 PM by jrizzo77	2	391
Use field for selection but NOT group by? by Ann Scharpf I have a data table. Right now there are four pertinent fields. PPE Date Function Task Total Hours I would like to select records with date greater than...	October 11th, 2007 03:39 AM by Duane Hookom	1	78
Use Field as Input by Sean H I have a file with 2 columns. One is a column of zip codes, and the other is a column with random numbers in it. I would like to run a query that matches up...	October 28th, 2005 08:50 PM by [MVP] S.Clark	1	115
Use expression/calculated fields as criteria? by [email protected] I've read a lot of posts about setting criteria ON calculated fields. I'd like to use a calculated field AS criteria. Is this possible? I'm using Access 2000,...	October 6th, 2008 04:29 PM by [email protected]	5	112
use expression as field name in query by Larry I'm trying to use an expression to create a field name in a query. I have an "Employee" file. that has fields "Sun", "Mon", "Tue" ... "Sat" that contain...	February 17th, 2008 09:12 PM by Larry	1	81
Use DoCmd.SendObject to send Select Query by GVR_Mike Is this possible? Here is my code but it does nothing at all: DoCmd.SendObject acSendQuery, "QueryName", acFormatXLS, ", , , "Subject", "Some...	November 8th, 2007 03:43 PM by GVR_Mike	0	71
use different equations in same query field by KimD[_2_] I am trying to set up a query to calculate flow from a table which contains date and other relevant information. The calculation changes depending on the...	December 28th, 2008 06:55 PM by KimD	2	90

Page 104 of 2165

104

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

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is Off HTML code is Off

Forum Jump

All times are GMT +1. The time now is 12:26 PM.