|
|
|
June 2nd, 2006 10:29 AM
by kate
|
2 |
58 |
|
|
I keep getting a "#Error" by
Ryan W
What did you do to get it to work? I am having same difficulty. Thanks for
your time, Ryan
"Jason Butler" wrote:
Sorry...I managed to figure this one out...
|
|
3 |
98 |
|
|
|
|
8 |
78 |
|
|
if statement with SELECT by
John Vinson
On 7 Dec 2005 12:00:50 -0800, "mr_doles"
wrote:
I have a table with 1 row (Fees) and 3 columns: Fee, Next_Fee_Date, and
Freq. I...
|
|
1 |
61 |
|
|
If Statements by
Lisa
I am trying to create a statement that will do a calulation is a field is
null. for example I have a due date field that has some date and dome are
blank. if...
|
January 21st, 2009 06:27 PM
by Lisa
|
4 |
66 |
|
|
IF THEN in query..Maybe IIf by
tina
assuming that there is a primary key for the existing records in the data
table, which i'll call TableA, that matches a primary key in the imported
data, which...
|
|
1 |
78 |
|
|
If Then Statements by
Lisa
I am trying to create a statement that will do a calulation is a field is
null. for example I have a due date field that has some date and dome are
blank. if...
( 1 2)
|
|
10 |
116 |
|
|
IFF statement in query by
Mkilah
I answered my own question. The syntax is IIF not IFF.
Thanks
"Mkilah" wrote:
Where do you put the Iff statement in a query? I am getting error 3085,
...
|
July 14th, 2006 05:38 AM
by Mkilah
|
0 |
91 |
|
|
Iff Statements by
Lisa
Expr1: IIf(="Non-Specked",!="Specked",!)
I am trying to get this statement to show the Specked number for the
non-specked
So I want the 901280 to show in the...
|
|
5 |
127 |
|
|
Iff Statements by
Lisa
Does anyone know how to change the Font color using an IIf statement? I wan
Past Due to be in red.
=IIf(0,"Past Due")
--
Lisa S.
|
February 14th, 2008 03:14 PM
by Glint
|
2 |
108 |
|
|
IIF and query booking by
Vincent Johns
It looks as if your problem is with the IsNull(), not the IIF. In any
event, I wasn't sure what you were trying to do with your Query.
(Sample data, plus a...
|
|
5 |
63 |
|
|
Inner Join doesn't work, Help by
Ofer Cohen
You need to change the Group by and Sort by to include both field name that
you join together and not the new column name
Try
SELECT Master.Viol & " " &...
|
|
0 |
143 |
|
|
Inner Join doesn't work, Help by
elena
Thank you, Ofer
It works great!
"Ofer Cohen" wrote:
You need to change the Group by and Sort by to include both field name that
you join together and...
|
March 28th, 2007 12:16 AM
by elena
|
0 |
74 |
|
|
Input to Table by
Steve
Understand, make sense.
Thanks
Steve
"John Spencer" wrote:
Don't store the result. You can always calculate it when it is needed.
|
March 6th, 2006 03:35 PM
by Steve
|
0 |
57 |
|
|
Is it possible?? by
rblivewire
Thanks MG.... should all of this go in the SQL view, including the
"parameters" and the "grouped by" ... Also, when a user inputs a date,
it will ask them how...
|
|
5 |
52 |
|
|
Is not null criteria by
faxylady
The first paragraph, second to last sentence answers your question.
I have tried the Select query where I put without
the brackets under each of these...
|
|
1 |
71 |
|
|
Joined two tables by
Tom Ellison
Dear Alex:
It would seem that PolicyNumber T2315 is NOT a unique policy. There are two
completely different policies with this number, on of Type AT and...
|
|
1 |
67 |
|
|
|
|
0 |
73 |
|
|
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 |
923 |
|
|
Kas kas munakas by
Niko Huttunen
TEM TYÖ JA ELINKEINOMINISTERIÖ
________________________
Helsingissä 27. päivänä toukokuuta 2008
"Mielipiteitten esittäminen julkisuuteen nettiin...
|
|
0 |
85 |