|
|
How do this tricky query? by
Dorian
I have 2 tables, a CASE table and an INVESTIGATOR table.
This is a one-to many relationship. Each Investigator has an Assign Date and
a Completion Date.
There...
|
December 14th, 2009 10:28 PM
by Dorian
|
4 |
299 |
|
|
syntax error in JOIN operation by
javablood
Hi,
I am not even sure if this can be done. I am trying to reference a table in
a query. The table is defined in a form. Here is the query I am working...
|
|
4 |
227 |
|
|
Pass-Through Query Error by
jutlaux
I am trying to setup a pass-through query with the below SQL
SELECT FIN_CUR_CURE_CYCLE_SIDE_DATA.MOLD_REV_NUM
FROM FIN_CUR_CURE_CYCLE_SIDE_DATA;
When I run...
|
|
1 |
186 |
|
|
Printing Porblem by
Leo
I have a master form that includes a sub form. After designing this I stored
it as report. I have a print command (Command29) in the master form with
onclick...
|
December 13th, 2009 11:35 PM
by Leo
|
0 |
166 |
|
|
Total number of days by
Leo
I have a query that has fields called training days1 through 12. They are all
date fields. The user will enter various dates that will not be contiguous...
|
|
1 |
155 |
|
|
Problem With CDec Function by
John Lane
I have a query with one column containing "Expr1: CDec()". When I try
to run or store the query, I get a message saying the function has the wrong
number of...
|
|
1 |
215 |
|
|
|
|
4 |
235 |
|
|
|
|
8 |
527 |
|
|
|
|
5 |
204 |
|
|
Combo Box Not in List function by
Leo
I have a combo box called RECC. It does not look up any table for the
values. I typed in the values (string statements). How do I add to the list
if the...
|
December 12th, 2009 02:58 AM
by Leo
|
1 |
148 |
|
|
Use of Wildcard in String Expression by
NEWER USER
I am trying to get the wildcard syntax "*" correct on the query grid in the
following and have struggled. Any help appreciated.
InStr(,)
Criteria is...
|
|
4 |
188 |
|
|
Formatting Concatenated Fields by
hobbit2612 via AccessMonster.com
Hi I wonder whether someone may be able to help please.
I'm using Duane Hookom Concatenate coding which is superb but I would like to
go a little further with...
|
|
2 |
197 |
|
|
Query to add 2 different record values by
Bob H[_4_]
I am trying to build a query which will add together 2 values from 2
different record going along rather than going down.
Something like this in Excel:
Add...
( 1 2)
|
|
12 |
286 |
|
|
Help with a Monthly Summary Report by
Dennis
Hi,
Since this question involves both a query summary and a report, I tried to
cross post to microsoft.public.access.queries.
I am working of a volunteer...
|
|
3 |
188 |
|
|
|
|
1 |
176 |
|
|
|
|
1 |
152 |
|
|
last entry per record query.. by
Sklyn
Hi and thanks for your time.
My database is tracking the service histroy of vehicles.
The main table has VIN as the PK which links to another table containing...
|
|
3 |
282 |
|
|
IIf Statement in Query Criteria by
AccessIM
I have the following code in a query:
SELECT qryPointsWithDropOffDates.EMPLOYEEID, qryPointsWithDropOffDates.SSN,
qryPointsWithDropOffDates.NAME,...
|
|
1 |
175 |
|
|
Assigning text response to a value by
cowichandave
In quering a sales database, if the sales amount is positive how do I get the
query to add "Sale" in another field or if the sales is negative have it add...
|
|
3 |
215 |
|
|
Problem with Dates in Query by
TotallyConfused
I have a field with dates. However, I need to separate only the year in
another column. This is what I have so far but it is not working. Year:
IIF( =...
|
|
1 |
132 |