Running & Setting Up Queries - Page 493

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
could not delete from specified tables by LutherMom Using Access2000 - Trying to delete old data out of a table but it gives above message - turned the uniquerecords to yes - then it wants to delete all the...	September 7th, 2005 06:42 PM by Lynn Trapp	1	81
Results of Access queries not always copying reliable to excel by Andy S. I'm using Office 2000 SP 3 trying to paste the results of large queries (between 5000 - 50,000 rows) to Excel and am having a problem with one machine where...	September 7th, 2005 06:53 PM by Andy S.	2	195
Sort by largest sub-total by Steve via AccessMonster.com I need to know how to take a report that is grouped by account number showing cost detail - it shows the account number, all detail including spending, then at...	September 7th, 2005 07:54 PM by Steve via AccessMonster.com	2	142
Help with recursive statement by Net Can someone help with the following recursive statement: I have an employeeID, supervisorID, supervisor_last_name and supervisor_first_name For each...	September 7th, 2005 08:25 PM by RuralGuy	2	163
query by Alex I have a query as follows: Day Product Code 2/1/05 SOS 2/1/05 SBT 2/1/05 SBL 2/2/05 SBM 2/2/05 ...	September 7th, 2005 08:43 PM by Duane Hookom	2	96
WHERE statement by Stephanie Hi. I'm struggling to get my query to bring back the information I want it to: Here's the fields with the criteria Contacts.MemberOption ... ( 1 2)	September 7th, 2005 09:19 PM by Stephanie	10	160
Delete Query to SQL Database Times Out by John Piotrowski I have an Access 2003 front end to an SQL 2000 database. On an employee form with a subform for related records that I include a button to delete the employee...	September 7th, 2005 09:26 PM by John Piotrowski	4	115
show all records in a join by Kenyon I have a query that has two tables joined together. The first table has fields: Plant Material Code Material Description The second table has...	September 7th, 2005 09:36 PM by MGFoster	1	74
Running Sum Error by Lori I am having a terrible problem creating a running sum in a query. I have created a in the query by combining the and field. I am trying to calculate a...	September 7th, 2005 09:43 PM by MGFoster	1	138
to group like items with total and number associated in the group. by Larry I would like to group like groups in one column while having amts sum for those groups	September 7th, 2005 09:48 PM by MGFoster	1	137
How do I restrict a query to give only one name&date per name? by Aileen Hewat My query has three fields - name,date,notes. Each name will have several dates. I want to select only the latest date for each name, so that I get a report...	September 7th, 2005 11:23 PM by John Spencer (MVP)	2	80
Form field for criterea problems by Bdavis I have query with the following criterea in the date field !!. I copied this from another query that works perfectly. But, I get an error that says the Jet...	September 7th, 2005 11:39 PM by John Spencer (MVP)	3	92
More help with Paramter Query with Mathamatical Expressions by prismlight Hello, I was hoping someone could help a newbie. I have a table named FSAClients with Feilds such as EthnicGroup, StartMonth, StartYear,EndMonth,EndYear. Im...	September 8th, 2005 12:07 AM by Duane Hookom	7	170
Query of records with various criteria incl. Null Values by ETC My Access 2002 database lists everyone in an organization that has different types of transportation passes. Wanting to keep a record of all employees who's...	September 8th, 2005 02:50 AM by Allen Browne	3	209
'No Current Record' error in Group By query with outer joins - SOLUTION by Allen Browne This problem has been posted several times without a solution. This post is really so that anyone seaching at groups.google.com can find an answer. JET can't...	September 8th, 2005 05:12 AM by Allen Browne	0	162
Still can't make it work by me My query either returns 1.5 million records or it wont run due to the following error. "The SQL statement could not be executed due to an ambiguous...	September 8th, 2005 08:06 AM by David S via AccessMonster.com	1	88
Roll-Up and Aggregate query by Tom I have an MS-Access lookup table that contains various categories and subcategories. The fields...	September 8th, 2005 08:08 AM by David S via AccessMonster.com	1	103
Sum Query - how to?? by Flemming Hello How do i make a simple sum query. 3 tables: OrderDetails: ID, Bproduct, OrderNo, ordQTY Invoices: SInvoiceNO, Bproduct, shipmentdate, arrive,...	September 8th, 2005 08:27 AM by David S via AccessMonster.com	1	88
Date Query by Dennis A. In Access 2003, I want to make a query that selects records based on a date. I have a form with a combo box labeled: "All Records Since:" The choices...	September 8th, 2005 08:44 AM by Dennis A.	2	79
Add comments? by MilesMonkMingus How do I add comments to a query?	September 8th, 2005 11:40 AM by Vincent Johns	3	85

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