Running & Setting Up Queries - Page 1171

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
Recordset with non Latin characters? by Lang Du Hi All, I have a recordset working with a translation table, please have a look at my below code: Dim rst As Recordset Dim strSQL As String Dim DB As...	September 29th, 2006 11:34 AM by Lang Du	0	59
overflow error by MM I have a query that runs fine until I put 0 in the criteria. When I do that and try to run the query I get an error "OVERFLOW". The SQL for the query...	September 29th, 2006 10:45 AM by Jamie Collins	5	84
permissions problem? by Geoff Cox Hello, I recently had my PC shut down suddenly whilst Access 2003 was open and appeared to loose some queries. They reappeared when I selected "show system...	September 29th, 2006 07:41 AM by Geoff Cox	6	112
get all the records from LastValidTech even one of the condition dont match by mustish1 via AccessMonster.com Hi: I try to print data from LastValidTech even one of the condition Join/Where dont match. But it shows empty record. SELECT LastValidTech.Account1,...	September 29th, 2006 05:37 AM by Marshall Barton	1	62
Plotting price changes. by Frank Martin I have a Query which stores the prices charged by suppliers. I need to keep a record of price fluctuations, so this would mean storing any changed prices...	September 29th, 2006 01:47 AM by Frank Martin	7	141
ACCESS QUERY: Get Values after Grouping and finding Minimum by Barnaby Burman Hi, I have a simple table in Access with four cols, as an output from my GIS: BUILDING_ID , ROAD_ID , ROUTE_ID , DISTANCE The table shows the distance of...	September 29th, 2006 01:18 AM by Neil Sunderland	3	69
Limiting Records from Query by Ripper I have a table used to sign up students for a class. The maximum per class is 20 in each class and I use a unique class ID for each course. How do I have...	September 29th, 2006 12:07 AM by John Vinson	1	74
replacing all null values by Maggie Is there a way to replace all null values to zeros? I need to make this change in all fields in several tables, the UPDATE query only allows me to do it one...	September 28th, 2006 10:47 PM by Duane Hookom	1	83
Need to pool out duplicates in a different column or sheet by [email protected] Hi, I already created a macro in excel to pool out duplicates and paste in other columns. I did a test run for 50000 and it does fine job. But the issue is i...	September 28th, 2006 10:00 PM by Phil Smith	1	91
Query ability by Tami Does a query ONLY pull from tables & other querys? Is it possible for the query to request a beginning date from the user & use that information to list the...	September 28th, 2006 09:19 PM by John Vinson	2	92
Count Expression by Alexandra504 I have several fields in a querry. These fiels have either 'Yes' or 'No' values. I need an expression that counts all the 'yes' in the previous fields.	September 28th, 2006 09:12 PM by John Vinson	3	62
Union Query WHERE clause by ALEX I'm trying to create a union query with the following SQL. I keep getting a parameter prompt for all the fields in the WHERE clause except for Model, which...	September 28th, 2006 08:50 PM by ALEX	4	62
To find overage order amount for last year USE DATEDIFF or DATEPART or DATEADD by Ashley I need to find out the avg amount of Ordertotal for last 1 year and this year if location is USA or Canada This query gives me error for present year and...	September 28th, 2006 08:32 PM by John Spencer	1	57
Criteria in multi table update query by jenngreff via AccessMonster.com I am trying to created an update query that will update all nulls for 2 fields in 1 table when the project # in both tables is equal. So far the sql view of...	September 28th, 2006 07:55 PM by John Vinson	1	58
Relating data in 2 fields by I''ve a feeling I''m not in Unix Anymore In my query I am trying to relate a PRStaff field containing an alpha list of names and a DayNum field containing the numeric value of the days of a selected...	September 28th, 2006 07:49 PM by I''ve a feeling I''m not in Unix Anymore	4	94
Violence due to primary key problem in Append Query by vicky I created an append query to append the data to Update table. However, in the Update table I put the primary key on purpose in order to prevent duplicated...	September 28th, 2006 07:44 PM by Steve Schapel	2	83
Using radio button option group to set criteria for query by JoeA2006 I would like to create an option group of radio buttons to allow the user to drill down to a group of records in a sub form. I have three choices and want to...	September 28th, 2006 07:35 PM by Steve Schapel	1	100
Singular by Tracy McClarnon Hello, Is this possible in Access 97? DELETE * FROM Offers AS A WHERE Not Singular (Select 1 From As B Where ((B. = A.) AND ...	September 28th, 2006 07:12 PM by Tracy McClarnon	1	60
Null to Zero in Crosstab Query by Alan Can anyone explain how to convert Null values to Zero in the Value field in a Crosstab Query? I know how to use the Nz function but I don't know where to use...	September 28th, 2006 06:21 PM by John Spencer	1	74
Retreive Only the Y results in a query by TKM My results without the Y look like this..Notice there is no N in that column and it is either Y or nothing in the BYPASS Column it only has the Y. In the...	September 28th, 2006 05:41 PM by John Vinson	3	63

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