|
|
Problems with query by
Duster
Hi all,
I am facing the following problem:
Two tables:
Table1
Name Code
Hans A1
|
November 30th, 2006 01:22 PM
by Duster
|
2 |
84 |
|
|
|
|
8 |
107 |
|
|
Boolean for idiots by
Mozy
I'm very new to this so forgive this idiotic question.
I've managed to set up a parameter query. However, I don't know how to apply
Boolean operators so...
|
November 30th, 2006 09:37 AM
by Mozy
|
2 |
123 |
|
|
Decimal Precision error. GRRRR by
Phil Smith
Is there any way to avoid this damn error?
Trying to convert using CDbl() does not work.
As best as I can tell, all of the data fits 8.4, which is the way the...
|
|
5 |
79 |
|
|
|
November 30th, 2006 07:00 AM
by Ananya
|
0 |
75 |
|
|
|
November 30th, 2006 06:51 AM
by Roger
|
0 |
77 |
|
|
DISTINCT Query Question by
[email protected]
Hi guys,
Basically I'm wanting a query to produce DISTINCT results for
"gallery.prod_title" only; obviously there are two tables involved.
With the DISTINCT...
|
|
1 |
116 |
|
|
question on joins by
Duane Hookom
And why did they choose to include crosstab queries?
I suppose they make some decisions like any other implementation of SQL. I
would rather have crosstabs...
|
|
0 |
90 |
|
|
|
|
0 |
74 |
|
|
|
|
0 |
84 |
|
|
Calculating group total in report by
Duane Hookom
What do you mean by "total number of incumbents for each position number"?
You need to ask questions in terms of records, fields, values,
calculations,...
--...
|
|
0 |
84 |
|
|
Very Tricky Query by
Go
Hi Karl,
Tried the first one and does exactly what I want
Thanks again
"KARL DEWEY" wrote:
Try these two queries.
|
November 30th, 2006 03:23 AM
by Go
|
0 |
91 |
|
|
repeating values by
TeresaE
My table has the following fields
ItemNo Name Image DateRecd
123 Foo 00 1/1/06
123 ...
|
|
1 |
91 |
|
|
|
|
2 |
142 |
|
|
Very Tricky Query by
KARL DEWEY
Try these two queries.
Grd_Bonus_1 ---
SELECT EM_List.PERSONNEL_NO, EM_List.HIRE_DATE, Grd.bonus, Grd.EffDate
FROM EM_List, Grd
WHERE...
|
|
0 |
69 |
|
|
|
|
10 |
164 |
|
|
Calculating group total in report by
Danielle
I have created a report by department that shows the position number and
other related data. The position number has multiple employees assisgned...
|
November 29th, 2006 11:31 PM
by Danielle
|
0 |
168 |
|
|
|
November 29th, 2006 11:29 PM
by Danielle
|
0 |
90 |
|
|
|
|
0 |
102 |
|
|
|
November 29th, 2006 10:36 PM
by Anthony
|
2 |
106 |