Running & Setting Up Queries - Page 111

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
Ambiguous outer join by Petr Danes[_5_] I have an update query that joins three tables, A, P & S. S & P are linked with an inner join, P & A with an outer join from P to A. Each join is on three...	January 26th, 2010 07:08 PM by Petr Danes[_5_]	6	199
ambiguous outer join need help by Janis I need help on this query to fix the ambiguous outer join? I think I know what the problem is but I don't know how to fix it. I have a self-join where I...	August 8th, 2007 03:52 PM by Janis	7	137
Ambiguous outer join vs. multiple duplicative records by MEOlsen I am designing a database to follow patient records in a medical office. The records are strictly medical data and not to do with billing. I am trying...	June 28th, 2005 03:59 AM by John Vinson	1	277
ambiguous outer joins by Rosemary I'm trying to write a query to gather information for a report. When I first did it, I got the message that the SQL statement could not be executed because...	May 12th, 2009 02:49 PM by Rosemary	0	124
ambiguous outer joins by renwick My database for was not recording in the right place, realised it was not bound to the right sourse so fixed it, not it won't run because my SQRL has...	February 22nd, 2005 01:29 PM by Roger Carlson	3	665
Ambiguous outer joins by gmore Hello folks! I've got a problem. I guess it's why we always come in here when that's the case :) I have three tables as follows: SIR (PK : id) SIR_D (PK :... ( 1 2)	February 20th, 2007 08:49 AM by Jamie Collins	11	328
Ambiguous outer joins by Karl Hello, I am having a problem with a query. I am trying to make an equipment list and I have 5 tables (Category, Sub Category, Component, Subcomponent...	May 8th, 2006 09:12 PM by Duane Hookom	6	101
Amount NOT Found... by Gary B Table: Payments PaymentsKey, Amount 967, $50.00 Table: Applied PaymentsKey, AppliedAmount 967, $22.00	October 29th, 2004 09:23 PM by PC Datasheet	1	134
Amount of time between records by chowda Hello. I have a table that I need to add a column that shows the time difference(in minutes) between records. ID date 1 4/15/06 11:30 PM 2 4/15/06 11:00...	November 21st, 2006 10:30 PM by Michel Walsh	4	92
AMOUNTS KEEP CHANGING by Kelli McCann Hello, Below is the query I had: SELECT . AS TruckID, Sum(.) AS Amount, Sum(.) AS Miles, Format(,"mmm") AS , DatePart("yyyy",) AS FROM WHERE...	September 16th, 2004 05:06 AM by Duane Hookom	3	116
Ampersand and other symbols in text by MechEng I have a table where the users would like to use the ampersand and â€œ â€˜ â€œ. For example; in a field named "Company", they would like to be able to use...	July 1st, 2007 01:44 AM by Ken Snell \(MVP\)	4	103
Ampersand in Field Caption by Ken Hudson I have a make table query in which I want to enter a field caption that contains an ampersand. When I save the query and re-open it, it inserts spaces around...	December 30th, 2005 03:41 PM by Duane Hookom	9	77
Ampersand in Query Criteria by AG[_3_] Access 2000 through 2007. How can I escape the ampersand used in query criteria? If I type a & b as criteria in a query, Access changes it to "a" & "b". The... ( 1 2)	January 7th, 2010 08:29 PM by AG[_3_]	12	495
Amt sum < certain date by Tina I have created a query that contains an Invoice Amt field and a Invoice Date field. The invoice date field has a criteria to display only the invoice amounts...	February 4th, 2005 10:14 PM by [MVP] S.Clark	1	82
an ab-normal bite in the rear end ? by barret bonden Picked up a new client with an old MDB , a lawyer's office dealing with state forms of great length and thus 100's of fields in each table; not only can I...	February 9th, 2009 01:17 AM by david	6	115
An Access function that works like Excel's vlookup or hlookup? by PeteyP Need something that will pull an item from a large table by matching something from the first column, then selecting a corresponding field (cell) from one of...	June 23rd, 2006 08:52 PM by PeteyP	2	106
an ALIAS question? by cinnie hello gurus I have a Report based on the Cross Tab query shown below: TRANSFORM Count(qryEmp.SiteID) AS CountOfSiteID SELECT qryEmp.SiteName,...	March 22nd, 2010 04:41 PM by cinnie	3	340
An Approach for Updating A Table with New Records by Tonk Dear Ng, I've got a tblDeerData on server A which I add records to on a daily basis. The data are scanned forms and auto export directly from the scanning...	December 14th, 2006 05:46 PM by Tonk	2	69
an expression by Lana I have 2 tables that I am trying to join. The tables are X and Y for now. In X I have the query asking for the number that I want to be pulled and it works....	February 19th, 2009 12:58 AM by Tom van Stiphout[_2_]	4	82
An expression from a linked excel table will not calculate by kyc_fitav I created a query using a linked table from excel and am asking it to add three fields: Rev1 + Rev2 + Rev3. However when I run the query the expr field is...	April 20th, 2005 11:42 PM by Jeff Boyce	1	232

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