|
|
|
|
4 |
1,500 |
|
|
|
|
0 |
848 |
|
|
|
May 27th, 2010 08:56 PM
by MKuria
|
0 |
886 |
|
|
Translate if statement in query by
Jazz
Thank you for the feedback; I appreciate your help and the suggested
modifications, they are much better. I still have some questions that I need
help...
|
May 27th, 2010 09:06 PM
by Jazz
|
0 |
821 |
|
|
union query without "blank" recordsl by
Mark Kubicki
I have a union query between 2 related tables, and where they may be records
in one table with no value in the other
.
I've got this (below) query written,...
|
|
4 |
1,393 |
|
|
How to Union Crosstabs... by
dtoney
I've been reading many posts but still trying to comprehend the union of
crosstab queries. I need to take the weekly count of estimates that take
under 4...
|
|
1 |
920 |
|
|
unique records Access 2003 by
Jerry Whittle
SELECT valveID, Max()
FROM YourTable
GROUP BY valveID
ORDER BY valveID;
If you have a duplicate valveID/Mas of Date combos, it will return all ties.
You...
|
|
1 |
875 |
|
|
Joins on NULL Date values by
KARL DEWEY
You can use a LEFT JOIN from Table1 to Table2 if Table1 always has a date or
the reverse if Table2 always has a date.
--
Build a little, test a...
|
|
0 |
940 |
|
|
Translate if statement in query by
KARL DEWEY
The query has table twice, with second instance having suffix _1 to
appear as and they both check for nulls.
The same could be accomplished like this --
New...
|
|
2 |
822 |
|
|
append crosstabs by
dtoney
can you append the results of several crosstab queries into 1 table?
I'm calc different categories & customers and need to capture "hours" for
each area for...
|
May 27th, 2010 10:05 PM
by dtoney
|
2 |
816 |
|
|
Change colour of a field by
Daryl S[_2_]
DontKnow -
You can use Conditional Formatting on the field. You are limited in the
number of options you have, but it can do what you want.
--
Daryl...
|
|
0 |
786 |
|
|
version by
arlene ramirez[_2_]
Does your query have a start time and end time.
If so, you can't run the query to see your time on Paper with Paper still
open as you will not have an end...
|
|
0 |
776 |
|
|
min query by
Siew-Ming
Hi,
How do I get the 2nd minimum value and the 3rd minimum from a table after I
have done MIN query for the 1st minimum value?
SELECT dbo_CON.SC,...
|
|
2 |
824 |
|
|
|
|
4 |
1,006 |
|
|
Parameter Error for Year 2010 by
AccessKay
Not sure if anyone knows the answer to this but I welcome any suggestions for
things to try. I have a crosstab query layered off of a Union query. I also...
|
|
7 |
994 |
|
|
|
|
1 |
811 |
|
|
Update Query not updating selected table by
MKuria
I have created an update query to update a master file. When I run the
select query to view the records I need to update - I see the correct data.
When I...
|
|
1 |
1,027 |
|
|
Access 2003 by
S.E.
I get a "type mismatch in expression" when saving a query. Why do I get this
and how do I correct this? My suspicion is my customerID and barcode fields
are...
|
|
7 |
900 |
|
|
adding new columns by
joemeshuggah
what is the best way to go about doing this?
i just created a report that first runs a query for current month info in
teradata sql assistant and exports to...
|
|
0 |
892 |
|
|
two level make table query and sorting??? by
tcek
I am creating a table with a "make table" query. I want to query by customer
number than by date of order. I want the customer number to be ascending
while...
|
|
2 |
972 |