|
|
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...
|
|
1 |
289 |
|
|
|
|
1 |
144 |
|
|
|
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. =...
|
|
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 =...
|
|
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 |
|
|
|
|
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...
|
|
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
|
|
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 |
|
|
|
|
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...
|
|
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 |
|
|
|
|
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,...
|
|
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...
|
|
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
|
|
2 |
142 |