Running & Setting Up Queries - Page 2101

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
Top 3 items per customer by Natalie Hi all, Apologies for what is probably a trivial question but I am a newbie. I have a table (CUSTORDERS) which contains the fields Customer, Date, Item,...	July 26th, 2004 06:04 AM by Allen Browne	1	134
Use of query to add sequential numbers to a table. by Frank Martin My InvoiceLines table uses the autonumber field for the primary key. But I need another auto-incrementing field for the sort field. Can such a field be...	July 26th, 2004 01:58 AM by Frank Martin	4	148
Tasks Not Completed by I have a query of a table that lists all tasks for this year. I have another table that records each employee, the task completed, and the date it was...	July 26th, 2004 12:43 AM by Graham R Seach	3	788
Make Table Query Using Form Criteria by Tee I set one of the fields' criteria of my make table query to a value on a Form (ex. !!)This works fine if I run the query from the Database window. However, I...	July 26th, 2004 12:13 AM by Eric Butts [MSFT]	1	714
Using Like when field contains a # by Jim Tinder I have a form with a field to enter a parameter to use to list the contents of a table in a subform. For example an address field may contain: 1. Null 2. 19...	July 25th, 2004 07:24 PM by Ken Snell	1	128
Query Design by Mathew Hi~ Below is a sample of my table structure and data: GroupName Dt_time Score Group1 04/01/2004 12:00PM 61 Group1 04/01/2004...	July 25th, 2004 03:49 PM by John Spencer (MVP)	1	377
access database by Shirley I built a database and all in all postal codes starting with zero it is dropping the zero. I don't know what i'm doing wrong. Please help!	July 25th, 2004 06:11 AM by Duane Hookom	1	143
Postal Codes dropping first zero by Shirl When adding postal codes starting with zero such as 02888 the zero is dropped leaving only the 2888	July 25th, 2004 06:11 AM by Duane Hookom	1	120
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
Delete query on external db? by NoSpamTakeSquareRootOfNumber Can a delete query be run to act on a separate database in the same way an append query can be? I have Database A with the query in it, and I want it to delete...	July 24th, 2004 02:35 PM by Jeff Boyce	1	574
Unmatched Query by Bob Mullen I have a table that contains fields for four players fldPlayer1, fldPlayer2, fldPlayer3, fldPlayer4. Through a main form a guest may be entered into any one of...	July 24th, 2004 02:34 PM by Jeff Boyce	1	536
Update query: To roll forward a date by 52 weeks using a look-up f by Fossil I created a table named WeekId which contains the following fields: WeekID (PK) (ie. weekID = 28) BegDate (Date) Format: Short date (ie. 07/05/04) (weekID =...	July 24th, 2004 01:57 PM by Michael Keating	1	141
Append Query problem -- producing WAY too many records. by Richard Hollenbeck I have a temp table as a work-around because of the need to get data from several unrelated tables. I don't want to change my relationships at this time. I...	July 24th, 2004 09:32 AM by Richard Hollenbeck	3	605
Add Column in make table query by Michael Noblet I have a make table query that I have created and I would like to be able at the time of creation to add a column for check boxes to the table. I assume I...	July 24th, 2004 02:43 AM by MGFoster	1	300
Delete record by Todd Huttenstine Hey guys How do you delete the last record in a table using SQL? Thank you' Todd Huttenstine	July 24th, 2004 02:23 AM by John Spencer (MVP)	1	183
Update a Quantity by R. BRADFORD THOMAS Good Evening, I am using Windows 2000 and Access 2000. I have a Table1 with a field Quantity1 and a Table2 with a field Quantity2. I want to update Table1 by...	July 24th, 2004 01:47 AM by R. BRADFORD THOMAS	2	101
translate SQL to Access by Dale Fye You cannot use a case statement in JET SQL. What are you doing with this query? Is the the recordsource for a form? If so, you could leave out the orderby...	July 24th, 2004 01:38 AM by shank	1	263
Looped result by cojohnso I have a query that I would like to loop. The fields are Transaction date, accountID, Beginning balance, withdrawals, deposits and then a calculated field -...	July 24th, 2004 01:25 AM by Tom Ellison	7	563
Query isn't giving all results by CJ I have 2 tables that I are in a query and the 2 tables have an Easting and a Northing value in common. Each field in the tables is set as a double number and...	July 23rd, 2004 09:30 PM by Tom Ellison	9	363
Combine 3 fields by Vic I need to take a Month field, a Day field, and a Year field and combine them into one field. I can not get this to work. Any ideas. Thanks	July 23rd, 2004 06:42 PM by John Vinson	1	66

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