Running & Setting Up Queries - Page 461

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
(Error 3296) by daniel caparg Dear, i need some help, i try run this sql, but ans error 3296 over each conditions: SELECT coco_sector , coco_USM , coco_Center ...	August 22nd, 2008 02:56 AM by John W. Vinson	2	118
How to extract multiple rows based on data in one column by [email protected] I work at an insurance brokerage where we can download payment statements in an Excel format. We would like to search a list of policy numbers (as a group vs....	August 21st, 2008 10:46 PM by [email protected]	2	126
Add field from query to table by Golfinray I have a table named 06-07 Tracking. I have a field I need to add to that table called Date Plans Received in a query called Agreement Received. I have...	August 21st, 2008 10:32 PM by Jeff Boyce	2	111
Full Join Query/Union by Esaw I have created the following UNION query to get all of the contracts and all of the royalties together, even if either do not have a contract number. This...	August 21st, 2008 09:59 PM by Lord Kelvan	4	123
Using previous data to calculate results by Dave I have read posts about previous records and still have not been able to figure this out. I have a series of records Item TransactionID Date ...	August 21st, 2008 08:26 PM by Dale Fye	8	193
Create one to many join query by deeds I have a system table with Sales$ etc... Each customer may have 3-4 different ID's listed in this table. I want to combine all of those ID's and produce a... ( 1 2)	August 21st, 2008 08:20 PM by deeds	16	244
Processing thousands of records by Dave I have a query that someone had helped me with and it works great: However when I run this against 91,000 records the query runs forever. When running... ( 1 2)	August 21st, 2008 08:09 PM by John Spencer	17	349
Top 3 or Max 3 scores for each group. by S I created a union query. lets call it "query 1" It displays my data as below. Student # Total 1 90 1 85 1 ...	August 21st, 2008 07:16 PM by Michel Walsh	3	165
#Error in Query by mattc66 via AccessMonster.com I have the following in my query and it keeps returning a #Error. Can anyone tell me what I am doing wrong? IIf(IsError(/),0,/) Matt --	August 21st, 2008 06:49 PM by ANDY-N via AccessMonster.com	1	164
Query in VB access returns less records than via DAO ? by Acie Hi, I have a query which is basically a left join of two tables with a few iif statements, and it returns the entire lefthanded table(14,000 rows) when I...	August 21st, 2008 06:45 PM by Acie	7	263
Multiple join types in one query, jet compatible, exec from Excel/ by John Mulford When trying to add an 'unjoined table' to a group of Left Outer Joined tables, jet returns "join expression not supported", "syntax error in FROM clause",...	August 21st, 2008 05:06 PM by Bob Barrows [MVP]	3	158
Make Table Query by Sondra Using Access 2002 I have a database that I need to have users extract specific data out of to merge into a Word Document. I've created a "MakeTABLE" query...	August 21st, 2008 04:21 PM by Jeff Boyce	9	237
Query returns nothing by kateri4482 What is wrong with this query? SELECT TblDailyCodes.Code, TblDailyCodes.Classroom, TblDailyCodes.Date, DateValue() AS NewDate FROM TblDailyCodes WHERE...	August 21st, 2008 04:16 PM by kateri4482	5	126
PivotTable View by Jasper Recto I have a query that gives me hours worked for a employee and the date. The hours have 2 decimal places When I pull this query into the pivot chart view, it...	August 21st, 2008 03:28 PM by Leezet Llorance	2	129
Concatenate & Format 3 Fields by Jani I have three fields that I want to add together using a query. The first field should have 4 characters (no problem), the second field in the table will be...	August 21st, 2008 02:56 PM by Jani	1	130
Inserting info. into null fields by G. I think I will be a newbie forever! My problem - I need to create a report based on data in 4 tables. I created a query to join the data I need from each...	August 21st, 2008 01:50 PM by G.	5	125
how do I deal with case sensitive data in Access? by sly135 I am trying to leverage SalesForce.COM ids in Access but the case sensitivity is an issue. How can I work around matching a 16 alph-numeric case sensitive...	August 21st, 2008 01:13 PM by sly135	2	137
Criteria Help by singingsister Hi, I'm a complete Access newbie and would like some help please. I have an excel spreadsheet showing all orders that have been placed on my company this...	August 21st, 2008 12:31 PM by John Spencer	5	138
Subtract amounts from two records in same table by Hold the Onions Using Access 2003, if you have a one table database, Count Date Item Amount 1/22/08 Oranges 2 1/22/08 ...	August 21st, 2008 05:46 AM by Lord Kelvan	2	115
Outer Join issue by Sue Compelling Hi - using ACCESS2007 I have a query (sourced from 2 others) that is calculated to tell me the current # of leads assigned to an employee (for various...	August 21st, 2008 02:24 AM by Sue Compelling	4	166

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