|
|
Date Range - Between Start and End by
UnknownJoe
Hello,
I have a table of employee information, which include 2 fields called Start
Date and End Date.
I want to be able to run a query that enables the user...
|
|
7 |
165 |
|
|
Support for CASE statements in SQL by
Domenick
I know that Access 2003 does not support the ANSI SQL "CASE WHEN...ELSE..END"
statement. I know that you have to use an inline IF statement . Also,
I've read...
|
|
2 |
150 |
|
|
Display Query Results on top of a Form by
Kristin M
I have a query which runs from a control button on a form. When the query
runs, the results are displayed behind the form. The user then has to
minimize...
|
|
1 |
121 |
|
|
Query x amount of records at a time by
The Joker via AccessMonster.com
Hello all!
I'm working on a task queue database. Currently the queue shows all non-
completed tasks. I'm working on a Form where people can go in and see...
|
|
3 |
197 |
|
|
SQL with IIF by
Barry
I have a form with a list box containing Customer names. Since all customers
may not have an associated company name, I made a column in the query of the...
|
January 13th, 2010 06:53 PM
by Barry
|
5 |
122 |
|
|
|
|
1 |
168 |
|
|
|
|
2 |
116 |
|
|
Join on a UNION query by
Tokyo Alex
Dear all,
I have a table of quotes, a table of relevent customer numbers and a table
of relevent quote keywords.
I have written a query to return all...
|
|
2 |
114 |
|
|
Quotation Mark Question by
jim
I'm trying to format a CSV spec from a query and so want quotes on some
fields and other without quotes -because of embedded commas in some fields.
Can...
|
January 13th, 2010 04:14 PM
by jim
|
3 |
130 |
|
|
How to not include results starting with 99 by
SteveP.[_2_]
I have been asked by our purchasing department to modify a query on one of
their databases to not include results that have a PO # which starts with
"99"...
|
|
3 |
100 |
|
|
Parameter Query multiple criteria help by
acss
In my query design grid i can place a criteria such as 830100 or 850600 and
it will bring all records for these two accounts under this account column.
How...
|
|
6 |
150 |
|
|
|
|
2 |
107 |
|
|
|
|
1 |
99 |
|
|
query comes up blank by
Maresdd
Could somebody please look at my query. I've looked and looked and tried
changing it all different ways, but I can't work out why I'm not getting any
data....
|
|
1 |
117 |
|
|
subquery help by
Maresdd
I get a syntax error message when trying to run a query using the following
as an expression in the query
Cat 3: IIf(=True,0,IIf(=,0,IIf(=3
And...
|
January 13th, 2010 04:30 AM
by Maresdd
|
5 |
141 |
|
|
Nested If help by
Suzanne
Hi, I'm having trouble with my If statement, not sure what i'm doing wrong,
can anyone help? This is what i have, you can get the gist of what i want my...
|
|
2 |
100 |
|
|
List of records 10 days old by
Linda RQ
Hi Everyone,
I am using Access 2003. I want a list of patients who are active and have
been on therapy 10 days as well as a field that shows how many days...
|
|
5 |
137 |
|
|
IIF stmt in Criteria by
Ray
I have a query and I have the following in the criteria of the ListOrder column
IIf(!!="Yes",45,)
I want the results to exclude only 45's from the...
|
January 12th, 2010 08:09 PM
by Ray
|
3 |
135 |
|
|
Must use updatetable query - work around by
NuBie via AccessMonster.com
I want to set SNumber field of Table01 using a concatenation of two fields
Fsn and AllFsn from Table03. Fsn link these two tables, below is my query
however...
|
|
5 |
179 |
|
|
|
|
4 |
144 |