Running & Setting Up Queries - Page 2152

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
Get Result 1 Stdev Away From Mean by Amande Strode The following is what I have managed to put together so far, but it doesn't seem to quite work, It generates a list of all users of certain equipment and some...	June 4th, 2004 10:42 AM by Gary Walter	1	289
How do I add a password to SQL? by Ed SELECT tblOne.Contract FROM tblOne IN 'D:\Database.mdb' 'D:\Database.mdb' has a password-- ?--PWD='dirty'-- Ed	June 4th, 2004 10:18 AM by Gary Walter	1	144
Choosing Fields that don't exist in another table by RickA I am sure that this is easy, but I have spent a lot of time trying to resolve this issue and I have not come up with a working solution. I have 2 tables: & ....	June 4th, 2004 06:21 AM by Rick	2	169
String Sort / Unicode problem by Mr Sir Hi Folks, I'm sorting a bunch of codes in Access2000 that are stored in a text field and contain a good number of dashes (-). As I understand it Unicode data...	June 4th, 2004 04:25 AM by Mr Sir	2	413
Operation must use an updatable query by EyeSpec Query will not run I get the error: "Operation must use an updatable query" UPDATE PHSCO_Elig INNER JOIN dbo_Tbl_Co_Refraction_Plans ON PHSCO_Elig. =...	June 4th, 2004 04:04 AM by david epsom dot com dot au	3	433
access 2000 odbc in asp by David this is going to drive me to drink...again, could someone put thier evil eye on this query and let me know what is wrong. trackingnumber =...	June 4th, 2004 02:41 AM by Ragnar Midtskogen	5	197
Carriage Returns - remove by Phil Jones Hey Guys, Anyone know how I can check for carriage rerurns in a memo field and if thier are any strip them out? I am only a basic user of access and use the...	June 4th, 2004 12:38 AM by fredg	1	127
DLookUp criteria help - involved one! by Teri I have a report based on a crosstab query. It queries the results of ad sales by sales reps. Sales Reps is a row heading and the Issue is a column heading. ...	June 4th, 2004 12:11 AM by Teri	1	522
Every column in my query appended with 'As Exprn' by David I was modifying a set of queries and somehow Access added 'As Expr1', 'As Expr2' etc. to the end of every column selected. This made every query that used...	June 3rd, 2004 11:56 PM by John Spencer (MVP)	1	240
Sum Field A by Field B by Mark1 I'm new to Access but old to SQL. I want to sum one field by criteria on another field. In SQL, it would be: Select sum(dollar) as Dollar From Table1 Where...	June 3rd, 2004 11:53 PM by John Spencer (MVP)	3	144
JOIN UNION Query by Xenophobe I have two tables. The first contains 2 columns, ID and Name: 1, John 2, Mary 3, Bill 4, Troy The second contains ID references to the first	June 3rd, 2004 11:24 PM by John Spencer (MVP)	4	286
Wildcards by Matthew I enter "103" in the criteria for a field in a query. The results work fine. When I try to use a prompt instead, as the criteria and type "103" in...	June 3rd, 2004 09:24 PM by Rick B	3	190
Counting rows returned from a query by John Lawrence Hello, I am trying to count rows returned on a query. The query is on a Yes/No field, and I need to find how many people are "Yes" I have tried the group by...	June 3rd, 2004 09:12 PM by hcj	1	241
HELP HOW TO NUMERATE THE QUEY RESULTS? by radek	June 3rd, 2004 08:39 PM by [MVP] S.Clark	1	348
Help on query logic by Can someone suggest some logic for the following: I have two tables: one gives a listing of items and the second gives a listing of transactions performed on...	June 3rd, 2004 08:37 PM by [MVP] S.Clark	1	318
Consolidate and concatenate text by K Kindle I have a table that has notes related to records in another table Key OtherTableKey Note 1 2 "Some sort of note" 2 2 ...	June 3rd, 2004 08:21 PM by Rob	3	192
Exporting Multiple Queries to 1 Excel Workbook with VBA by Anthony Hi Everyone, Does anyone know how to do this? I need to export a series of queries to 1 Excel workbook, with each query being a new tab. I have pretty...	June 3rd, 2004 07:59 PM by Anthony	2	944
This should work...but by Jeff Harbin I've got a simple query that I'm using as the source for a report. It has 5 of the fields from the source table in it - Line, DTCategory, DTHours, DataMonth,...	June 3rd, 2004 06:57 PM by Steve Schapel	5	147
If and Or Functions in Access by bmistry Hi, I would like to create a simple function that read IF or is blank "No Data" The OR and AND Functions are causing me problems. I have entered the...	June 3rd, 2004 06:03 PM by Ragnar Midtskogen	2	161
Group Data Export/New Table by Phil Jones Hi Guys, I have a table that has a number of duplicate entries and want to export the grouped data to a CSV or save as a new table. any ideas? Thanks	June 3rd, 2004 05:34 PM by Phil Jones	2	142

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