|
|
|
|
5 |
1,048 |
|
|
|
May 28th, 2010 04:14 PM
by Dan
|
4 |
1,036 |
|
|
Blank Fields in NOT Null Query Criteria by
Steve Stad
Why would a few blank fields show up in a query where I am using 'Is Not
Null' in the criteria. The rest of the Nulls are filtered out - but there
are 7...
|
|
5 |
1,134 |
|
|
Next to Last Date by
slotmgr70
I have a table that tracks each customers visit to my store. I hold
promotions on occaision that bring customers that haven't visited my store in
awhile....
|
|
2 |
1,159 |
|
|
Help on muliple table queries by
Natalie
Hi all,
I wonder if you can help. I have 5 tables of data with the same column names.
I want to run a query which includes all records from all tables within a...
|
|
1 |
954 |
|
|
Joins on NULL Date values by
Andy
I have some queries whereby I need to join two tables based on two date
fields that are in both queries. Sometimes date 1 or date 2 will have NULL
values,...
|
May 28th, 2010 12:01 PM
by Andy
|
3 |
1,170 |
|
|
Currency Format Lost in Union Query by
Jill
Thanks to John Spencer, I resolved one problem in my union query (Thank you,
John). But I have another problem. Some of my fields in my union query are...
|
|
1 |
1,182 |
|
|
Update Query with Parameter by
sg
I have an Update Query that asks for 3 fields with parameters. The first
parameter is the criteria in the query to identify which record we are
updating. ...
|
|
3 |
1,033 |
|
|
|
|
2 |
895 |
|
|
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 |
967 |
|
|
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 |
887 |
|
|
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 |
893 |
|
|
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,023 |
|
|
|
|
1 |
805 |
|
|
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 |
987 |
|
|
|
|
4 |
997 |
|
|
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 |
818 |
|
|
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 |
763 |
|
|
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 |
779 |
|
|
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 |
814 |