Running & Setting Up Queries - Page 2008

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
Make table queries by wheelz I am trying to create a new table that has fields from two different tables. The common field between the two tables is name_soc (employee's name concatanated...	October 30th, 2004 02:59 PM by Jeff Boyce	1	97
find non-matching records, sort of by needlewomyn My apologies if a variation of this question appears elsewhere; I've never posted here before and can't tell if I just can't find my original question or I...	October 30th, 2004 02:57 PM by Jeff Boyce	1	382
Access 2003 help says you can do full outer join, but user interf. by John Irwin Help seems not to match Access 2003. What I want to do is a full outer join. Does Access 2003 support this? How is it done, if so?	October 30th, 2004 02:56 PM by Michel Walsh	1	261
extracting everything from the db on specific ID by steven scaife Is there an easy way to extract everything relating to a particular record out of a db into an exact replica based on a particular ID.	October 30th, 2004 02:47 PM by Michel Walsh	1	172
Write conflict by Petra I added two new fields to a SQL table and updated the SQL view that the front end form is linked to, I added the new fields to the forms and when I attempt to...	October 30th, 2004 09:43 AM by Brian	4	132
Have detail records, want to group on one field get totals of oth. by David I have a table with detail payroll records. I want a query that will summarize the payroll detail based on job no (repeating value)	October 30th, 2004 02:54 AM by John Vinson	1	173
Complex Query... I think by Access Lover Hi all, I have a chain of linked tables in one to many relationship as such: Customers Table is the main table with these tables linked to it: 1. Payments 2....	October 30th, 2004 02:02 AM by John Vinson	5	98
Relationships by burg Hello, If I have one quote that relates to many different designs as the designs can change, how can I then search by quote and only report on the desgn...	October 30th, 2004 01:09 AM by John Spencer (MVP)	4	107
Optimizing join queries with indexes. by Brenda Select * from table1 as a inner join table2 as b where a.field3 = b.field3 and a.field2 = b.field2 where a.field1 = 803; Table1 already has a compound index...	October 30th, 2004 12:21 AM by MGFoster	1	139
Newbie help: sql string conversion by steve Hi, I am trying to avoid a horrendous amount of coding and see if i can get away with a complex sql statement. I have data values (measurements) which I have...	October 29th, 2004 11:31 PM by David Portas	9	207
How do I check the query record count from a macro? by Robert_L_Ross I have a macro that needs to do one thing if the number of records in a query is 0, and something different if the number of records in the same query is 0. ...	October 29th, 2004 10:08 PM by Ken Snell [MVP]	3	577
Calculations from Query by sad Hi, I have a query with the following fields: Cust-num Order-num Order-line OTP AL234 CO343 1 4.5 AL234 CO343 2 14.6 AL234 CO764 1 ...	October 29th, 2004 09:37 PM by sad	4	109
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
Create/Save Query on the Fly by Ed Ardzinski I have a rather large union query I build through code, then I wanted to use the SQL string as the record source for a display form. I ran into a problem...	October 29th, 2004 08:05 PM by Ed Ardzinski	2	85
Escalating invoice number. by SHIPP I have a table with multiple (duplicate) invoice numbers. What I would like to be able to do in a query is to read the table and for every duplicate invoice... ( 1 2)	October 29th, 2004 07:19 PM by Ken Snell [MVP]	15	196
Soundex Function by Fabio Hi I'd like to know if there is something similar to Sql Server function soundex() in Access ?	October 29th, 2004 06:02 PM by Peter R. Fletcher	2	143
Where to put SQL by Mike Binger Hello, I am in a form and after selecting a value for one field, under the On Click property, want to run a query to choose a value to set the Default Value...	October 29th, 2004 05:53 PM by Michel Walsh	7	115
Compare Data by Jeff Boyce Daniel When you say "the quantity must not be combined", do you mean you wish to keep separate rows in your combined table, one for each row appearing in...	October 29th, 2004 05:46 PM by Pieter Wijnen	1	68
Append Query with Date by Bryan Hughes Hello, I have an append query that gets info from two tables with the inner table getting the last date (max(MyDate)) as part of the criteria. INSERT INTO...	October 29th, 2004 05:22 PM by [MVP] S.Clark	1	143
Query To Find Records As Of Specified Date by Salad Sue wrote: I'm working on a database that keeps track of employees hired by a general contractor on a project by project basis. These employees are hired...	October 29th, 2004 02:59 PM by Sue	2	386

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