|
|
Passing Multi-Select to a Query by
LarryP
I sometimes need to pass the results from a multi-select list box to a query,
e.g., "Apple" or "Orange" or "Grape" etc. I've done this before by writing a...
|
December 3rd, 2009 03:06 PM
by LarryP
|
4 |
238 |
|
|
query parameters by
Patrick D.
Hi
I have a stored query in a accdb-database:
UPDATE Table SET Field1 = WHERE =;
Running the query I am just prompted for one parameter.
It must be only...
|
|
2 |
191 |
|
|
Query twice with the same criteria == by
dede
I will run two "make-table" query with the same criteria
I call those two query from a form with
DoCmd.OpenQuery
the criteria in the query is twice...
( 1 2)
|
December 3rd, 2009 08:06 AM
by dede
|
12 |
315 |
|
|
update next row by
shank
I need to update a field in a table I use for grooming data.
Something like...
IIF (Row1.PO=Row2.PO,Row1.InvNo,Row1.InvNo+1)
....and it would loop through all...
|
|
1 |
181 |
|
|
|
|
4 |
202 |
|
|
InStr Function not finding space by
Kirk P.
I'm using this function InStr(Trim()," ") on data that looks like
this:
(USD 65.00)
and it is returning a zero. I'm trying to find the first occurance of a...
|
|
8 |
333 |
|
|
|
December 2nd, 2009 10:35 PM
by Dorian
|
2 |
171 |
|
|
|
|
13 |
327 |
|
|
Prevent duplicate append - nothing unique by
Opal[_3_]
Help! I have been working on this all day and
cannot get my head around a solution....
I am running Access 2003.
I have created the following select...
|
|
0 |
169 |
|
|
|
|
1 |
198 |
|
|
|
December 2nd, 2009 08:10 PM
by yator
|
0 |
190 |
|
|
|
December 2nd, 2009 08:10 PM
by yator
|
0 |
178 |
|
|
|
December 2nd, 2009 07:56 PM
by Ben
|
0 |
199 |
|
|
|
December 2nd, 2009 07:56 PM
by Ben
|
0 |
160 |
|
|
Year Minus One by
Ann
I am using Access 2002 and have a two character text field that
holds the last to characters of the current year, (example 09). I want to
retrieve all the...
( 1 2)
|
|
12 |
299 |
|
|
|
|
9 |
195 |
|
|
Duplicate Values in Query by
AccessIM
I have the following code in a query:
SELECT qryDisciplineLevelAll.EMPLOYEEID, qryDisciplineLevelAll.SSN,
qryDisciplineLevelAll.NAME,...
|
|
6 |
223 |
|
|
|
|
9 |
198 |
|
|
|
|
0 |
181 |
|
|
|
|
0 |
209 |