|
|
line breaks by
Grimble Gromble
I'm trying to use an update query to concatenate several
text lines into a single memo field with line breaks.
I can't seem to find which character to use for...
|
June 3rd, 2004 09:27 AM
by
|
4 |
332 |
|
|
Simple Query Question by
Rebecca
Greetings. I deeply appreciate the help the MS MVPs have
given me (especially John Spencer). I have a quick
question about the following query that Mr....
|
|
1 |
385 |
|
|
Changing a column type in sql by
Andy Levy
Hi
Is it possible to change the column data type in an sql statement
I have a table column which is set as text data type. It only contains
numbers, but fir...
|
|
1 |
405 |
|
|
|
|
5 |
867 |
|
|
Query Problem by
Niall
I have a query which shows me the following data:
Name 2003 2004 2005
Joe 5 6 7
Bob 8 9 ...
|
|
1 |
344 |
|
|
Percentiles by
Tony
Does anyone know how to calculate a percentile in Access'
Query?
I run reports where I need to show Min, Max, Avg, and a
certain performance percentile, and...
|
|
1 |
144 |
|
|
Top 5 by
Heather
Hello,
Is their a way to get the top five per each ID. So say
each ID has 21 funds, I want the top 5 sales for Each ID.
ID Fund Amount
1111 A ...
|
|
3 |
146 |
|
|
Count Unique numbers by
Johnny
I have two columns: Job Number and Part Number. Since
most jobs consist of more than one part the Job Number
may repeat in this column as I list all the Part...
|
|
1 |
405 |
|
|
|
|
2 |
423 |
|
|
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 |
|
|
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 |
|
|
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 |
|
|
|
|
2 |
944 |
|
|
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 |
|
|
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 |
|
|
|
|
1 |
348 |
|
|
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 |
|
|
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 |
|
|
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 |
|
|
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 |