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
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
Parameter query based on text field by Tom I need some help w/ defining a dynamic query. 1. Let's say I have a table that contains 4 fields: - Name - Address - City - State 2. Now I create a query...	August 23rd, 2004 12:05 AM by Eric Butts [MSFT]	4	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
Sorting a table by concatenating several fields in the same table by salsaguy I am creating a database to store information about printed media. For example, a single table with separate fields for title, author, publisher, citations,...	March 6th, 2005 01:33 AM by salsaguy	0	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
Help with SQL code by ctdak I did a mock up in Access query view before creating the following SQL code. I created two queries and linked them - the results were exactly what I need for...	June 17th, 2004 02:36 AM by Dale Fye	3	486
parameter query with multiple entries by lynn.atkinson Can I have a parameter query where the user just types the various criteria in to one dialog box? eg I want to find location 1, location 2 and location 3 from...	July 8th, 2004 06:53 PM by Duane Hookom	1	486
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	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
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
Don't understand posted update query answers by terryc Read a lot of posts but ... One table called Address has field cell and field email. no data in those fields. Second table called Cell has field cell and... ( 1 2 3)	January 23rd, 2010 03:46 PM by Gina Whipp	21	484
Delete Query Doesnt by Ron Le Blanc I have a database that won't let me delete records using a Delete Query. Attached are the DB table relationships in a .png image file. I have an Access 2003...	February 8th, 2006 01:21 AM by Ron Le Blanc	7	484
Using Combo Boxes as a Source for Parameter Queries by venajoe Access Gurus, I often encounter a situation where I want to run a select (parameter) query on a particular table, but instead of having the user type in...	March 5th, 2010 05:10 PM by John Spencer	2	484
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
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	483
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	483
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	483
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	483

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 06:58 PM.