Running & Setting Up Queries - Page 51

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 51 of 2165

Threads in Forum : Running & Setting Up Queries

Forum Tools

Search this Forum

Thread / Thread Starter	Last Post	Replies	Views
Concatenate multiple rows by Cydney Is there a good way to concatenate data from multiple rows into one field? I have several rows with different dates and I need to combine the comment text for...	April 29th, 2010 02:35 AM by Duane Hookom[_4_]	5	488
SQL query help by [email protected] I have this SQL SELECT QryHisacctable.CORP, QryHisacctable.DIVISION, QryHisacctable.FACILITY, QryHisacctable.DST_CNTR, QryHisacctable.PCC_SMIC,...	June 5th, 2009 04:11 PM by [email protected]	8	488
SELECT DISTINCT by MacDuff Hello Is there a way to group the fields in a select SELECT DISTINCT statement so that the distinct part works only with the first three fields and...	July 24th, 2004 07:46 PM by John Vinson	3	487
Inconsistent square bracket in Query SQL by Christine It has come to my attention that sometimes, when I open a Query in SQL View, the SQL that I see is not exactly the same as the SQL in the Query's Querydef. The...	October 7th, 2004 03:49 AM by Christine	8	487
Unmatched records by Mario Have 2 queries the names are "CustomersNoSales" and the other "CustomerSales", both have a field named "CID"(CustomerID) and another field named... ( 1 2)	February 10th, 2010 03:08 PM by Mario	14	487
Create a table from a query by ktm400 Iam trying to create a table from a query that has 10 columns of data (real numbers) I would like to extract the data in the 10 columns row by... ( 1 2)	March 22nd, 2006 09:14 PM by ktm400	11	487
Help with Query by Maureen Is there any way in a query to do a running total like records? the output that I am trying to acheive is this: teacher class period student stu_no Mr.... ( 1 2)	June 19th, 2004 02:39 AM by John Spencer (MVP)	14	487
Query won't work with THIS table by Alain Hi, Access 2002, Win2K Pro, French I have a IdTelephone table with following fields: Id: Autonumber, unike Key, unused here idMemb Member Id, long...	June 14th, 2004 03:56 PM by Alain	2	487
Access Update Query Not Working From ADO by Barry-Jon Hi, I have as saved access update query called 'qupdEnvironmentActivate'. The SQL for the query is as follows: PARAMETERS Text ( 5 ); UPDATE...	March 18th, 2005 08:42 PM by Van T. Dinh	3	486
Using IIF to return a zero value for a null by Muraii Hi, This is not so much a question as a sharing of something I've come across. It won't be earthshattering nor epiphanous, but it might prove helpful. I...	May 29th, 2004 04:06 AM by Van T. Dinh	2	486
Append Query Question by Chaplain Doug Is there a way to do an append query and set a particual field to a value in all records appended? I am currently using for exmaple: INSERT INTO SELECT *...	July 7th, 2004 02:30 PM by Chaplain Doug	2	486
query design view problem by Lisa I have a fairly simple table that I am trying to query and am having problems with one of the parameters. There is a field that simply holds a Yes or No. I am...	July 6th, 2004 11:32 PM by John Vinson	2	486
Append one table to multiple tables? by Stranger I currently have the computer inventory at work in one table. I have created new tables with relationships and I want to append the data in the existing table...	July 28th, 2004 01:00 PM by Stranger	2	485
Unable to link two tables in access having identical fields by sathish_sns I want to join two tables A and B. Both have multiple columns. The field that is exactly the same for two tables is "Phone Number". I want to put all fields of... ( 1 2)	May 18th, 2005 03:41 AM by John Vinson	19	485
query based on a date field by Richard Hello, I have a database in which I have two fields; called "1st Notice" amd "2nd Notice". Both are date fields and are formatted as medium date. I have a...	December 3rd, 2004 02:29 AM by Richard	2	485
The 'Select' query sometime does not return all the records with . by Sanjay Kumar Limbikai The select query sometime does not return all the records with in clause for ex. select * from modelmaster where model in ('a','b','c') will sometimes return...	October 3rd, 2004 07:15 AM by Sanjay Kumar Limbikai	2	485
Multiple Left Joins and an Inner Join by Corey Burnett I have the following tables: Address, LState, Country, Contact Every Contact has one or more Addresses. Each Address may or may not have a State or Country. ...	July 15th, 2004 01:21 PM by Corey Burnett	2	484
Display Relational tables in a query by Bill Duris Hello, I have 2 relational tables that a query currently displays like this: X1 Y1 X2 Y2 X2 Y3 In other words, it repeats the first column when...	July 23rd, 2004 03:37 AM by Allen Browne	1	484
query works but error message in report by Tony Hi, I am building queries for duplicate payments reports. I have the query working but when I go to run it in the report I get an error message (error 3079) in...	June 5th, 2004 12:43 PM by Tony	2	484
Creating a parameter query using part of the field by LORIB I'm trying to create a parameter query using the date only part of a date/time field as the parameter. Can someone help?	September 1st, 2004 09:06 PM by Tonín	1	484

Page 51 of 2165

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 07:16 AM.