|
|
Update - If statement by
Dan @BCBS
My data is Y or N, I need to Update the data to: If "Y" then -1 Else If "N"
then 0 Else NA.. Can I add an experssion to do this, if so, what would it
look...
( 1 2)
|
|
13 |
1,870 |
|
|
IIf statement by
BARRY
I would like to make a query on a table on one field to 'sum' or 'max' the
field based on 'if' another field is null or not. Any idea on how I would
go...
( 1 2 3 ... Last Page)
|
|
35 |
1,860 |
|
|
Undefined function 'Left' in expression by
The Joker via AccessMonster.com
Hello all,
First off I want to say I read a lot of the previous posts about this issue
and none seem to be similar to mine. I am working on a database...
( 1 2)
|
|
11 |
1,859 |
|
|
Expression exceeds 1,024 character limit... by
JBHansen
"The expression you entered exceeds the 1,024-character limit for the query
design grid."
I just saved a make-table query with a new field name and evidently...
|
|
4 |
1,838 |
|
|
complex duplicate queries by
Gary Walter
Hi Tony,
I woke up this morning thinking about
how you probably (might) want your queries
to be updatable.
One method is putting the group by in
the Where...
|
|
0 |
1,831 |
|
|
Adding records to a query? by
Mike J
I have a query attached to a form. On that form I have a
combo box w/ a 'notinlist' event that is supposed to add a
record if the 'id' is not in the list. I...
|
May 23rd, 2004 09:36 PM
by Mike J
|
0 |
1,813 |
|
|
Expression - calculating running total by
Kathy
Ted, I really appreciate your help on this.
The Inception table is used to specify the inception date and the starting point for 100 in the IDTotRet field for...
( 1 2 3)
|
|
26 |
1,807 |
|
|
Query for 'confirmation' by
rogge
Please help. I am trying to make updating a 'confirmation' routine quick and
easily updateable by some one else.
I have 2 tables, one of which I would like...
|
|
8 |
1,800 |
|
|
|
June 2nd, 2004 04:54 PM
by tina
|
14 |
1,795 |
|
|
|
|
32 |
1,780 |
|
|
Help again from Ken Snell (Query) by
Randy
Ken you helped me last week with a query to find missing dates from my
employee db. It works great except I have found that it returns all dates
from my...
( 1 2 3)
|
August 29th, 2005 08:15 PM
by Randy
|
22 |
1,768 |
|
|
|
August 2nd, 2006 10:14 PM
by Iona
|
37 |
1,766 |
|
|
|
|
36 |
1,729 |
|
|
outlook express access to attachment by
cathy
I received an email with attachment. Outlook Express
blocked access to attachment to "suspicious email". What do
I do to view attachment? Thank you for any...
|
|
1 |
1,729 |
|
|
query field reference help by
-dch
I am running Access2002 under Windows XP Pro.
I have built a query as a row source for a listbox on a
form. The first version of the query is working...
|
June 2nd, 2004 07:30 PM
by
|
4 |
1,704 |
|
|
First and Last Problem by
Dan[_33_]
For some reason First and Last are giving the wrong data in a Totals
query. I assume that somehow the data is not ordered correctly in the
main table, but it...
|
May 31st, 2010 04:10 AM
by david
|
9 |
1,593 |
|
|
|
|
29 |
1,580 |
|
|
Can't Post Clarification by
Al Voss
Now that my former post has gone through, when I am in other newsgroups
using Outlook Express, I can view all ngs I visit. But I can't post in ANY
of...
|
|
0 |
1,576 |
|
|
Lag 1 day relationship by
Michelle
Sorry if this is a duplicate, but I tried lots of searches here. I can't
seem to find my answer anywhere.
I have 2 tables that I need to join by date and...
( 1 2)
|
|
11 |
1,576 |
|
|
"NOT EQUAL" query by
Van T. Dinh
You got the Left Join wrong way around. The way you have at the moment, the
Query will show Records in tblPersonnel that don't have related Records...
|
May 23rd, 2004 12:27 PM
by Chuck
|
1 |
1,571 |