|
|
Distinctrow by
Ann
I'm trying to get only the distinct rows for the following but it doesn't
work. What am I doing wrong? Thanks for any help you can provide.
SELECT...
|
|
4 |
149 |
|
|
Identify missing numbers by
Tara
I have a table that uses a text field to store receipt numbers. Currently I
use VAL to sort the numbers numerically. Is there a way to identify which...
|
November 20th, 2009 09:55 PM
by Tara
|
4 |
179 |
|
|
Access Query by
Ken Taylor
I have a table with approx 270K records. One colum contains an ID codes i.e. WATUA1, WAXUB0 etc.
I need to change the last to letters to AA, i.e. WATUAA,...
|
|
1 |
167 |
|
|
|
November 20th, 2009 09:13 PM
by babs
|
5 |
125 |
|
|
Date Function in query by
RoyS1031
I have two tables. One is INVOICES, the other is "INVENTORY. Each has a
DATEMODIFIED field. The dates in INVENTORY are formatted dd/mm/yyyy
hh:mm:ss. Yet...
|
November 20th, 2009 08:32 PM
by RoyS1031
|
3 |
147 |
|
|
Sorting in Queries by
Charles
Hi,
I am trying to write a query that assigns contributions for each account
considered to either East or West depending on which territory has the larger...
|
|
2 |
142 |
|
|
Data Conversion Expression returns #Error by
D. Stacy
Objective: Convert txt data representing a time stamp on a particular
activity into DateTime format.
1. If the data field contains any data convert it to the...
|
|
2 |
123 |
|
|
|
November 20th, 2009 04:28 PM
by D. Stacy
|
0 |
150 |
|
|
|
|
3 |
135 |
|
|
Type mismatch in Function by
PatK
Hoping someone might be able to help. I have the following Function that I
have used in excel 2007 (and it works fine), that I am trying to now use in
MS...
|
November 20th, 2009 04:03 PM
by PatK
|
5 |
179 |
|
|
WHERE CLAUSE by
Martin
Hi,
I have a query that I need to assign a WHERE clause within the statement.
This is below:
Monthly Update: IIf(!="*BR*",!* ! WHERE ! = "BR",0)
Does...
|
|
2 |
177 |
|
|
iif and between by
Justin T
hello
i have a set of numbers 1-52 in a field. when i query criteria ...between
and -13....i get the answer i need with the query: a set
of...
|
|
2 |
148 |
|
|
|
|
0 |
126 |
|
|
|
|
3 |
152 |
|
|
Crosstab qry not adding up by
deb
I've built a crosstab qry for a tenant sales database based on a select qry,
the original select query works (adds up correctly) ive checked by sorting
and...
|
|
1 |
117 |
|
|
Problems with Crosstab Query by
Rob Parker
This should be so simple, but I'm about to tear my hair out.
I have a crosstab query based on a table, left joined to a query which
selects distinct FYs from...
|
|
4 |
168 |
|
|
Using Criteria for a Y or N response by
TKorell
I am using a large database and I want to have it give me only the Y
responses not the N responses for the labels. This might sound nuts but
there are 12...
|
|
2 |
147 |
|
|
Clause order in SQL select query by
.Len B
Are there any rules that govern clause order? Does the
parser care?
Obviously SELECT must be first but does WHERE have to
precede ORDER BY?
This question...
|
November 20th, 2009 12:06 AM
by .Len B
|
4 |
174 |
|
|
Counting records matching criteria by
OssieMac
I have the following queries that count records matching particular criteria.
One counts ProdPrefix="C" and
the other counts ProdPrefix="M".
Output is in 2...
|
November 19th, 2009 11:53 PM
by OssieMac
|
4 |
119 |
|
|
Web based news browser by
Dale Fye
Don't know what has happened lately, but the the MS web based news browser
functionality has decreased lately.
Up until recently, searching on my name in a...
|
|
2 |
165 |