|
|
is this a friday? by
ty
I need an update query with an If statement on it. Basically, it would say
something like If AssignDate is Friday, then update Time Elapsed to 1 hour.
My...
|
|
3 |
57 |
|
|
Problem with Update Query by
MacNut2004
Hello,
I have the following in a query:
UPDATE Actuals INNER JOIN ON (Actuals. =
.) AND (Actuals. = .) SET .Jan =
IIf(Month(Forms!Main!)=1,,), .Feb =...
|
|
5 |
61 |
|
|
Seems so simple - Percentage by
Danu
I have a table with the code designation in one column and the number of
records with that code in the other column. I need to find out what
percentage of...
|
May 16th, 2007 07:28 PM
by Danu
|
4 |
59 |
|
|
|
|
1 |
102 |
|
|
|
|
6 |
51 |
|
|
|
|
2 |
65 |
|
|
|
|
1 |
48 |
|
|
Somebody Please Help by
JS
I have a main table tblOHInst. Fields Match and Zip are blank.
I have a secondary table tblInstNew that has the same fields as the
tblOHInst but the Match...
|
May 16th, 2007 05:31 PM
by JS
|
3 |
63 |
|
|
Multiple parameter query by
JoeA2006
I need a form to allow the user to drill down to records using a multiple
parameter query. In the columns criteria I have something like this
!.!.
I will...
|
|
1 |
57 |
|
|
Get month between non calendar dates by
AccessNewbie
Office 2007
I want to be able to get the Tax Month from a given pay date.
Tax months run from 6 April to 5th May, 6th May to 5th June etc
If the payment...
|
|
3 |
71 |
|
|
multiple date ranges by
GiBB
Hello,
I am trying to create a query to search for various date ranges in a table.
to make it easier for the user i am trying to create the query so they...
|
May 16th, 2007 04:43 PM
by GiBB
|
3 |
63 |
|
|
Query on Date position by
[email protected]
I have a table where the date field is stored as yyyy/mm. I want to be
able to query all records that have the previous month in their
record. In other words...
|
|
2 |
67 |
|
|
Report Query Woes by
Michael Conroy
I need help with SQL syntax to combine two queries and use a criteria string
to limit the results and feed this all into a report. The criteria is
determined...
|
|
1 |
68 |
|
|
Help to correct this DLookUp by
Marco
Can you check what wrong with this DLOOKUp that I want o insert on a report.
=DLookUp("";"";" = '" & & "' and = '" & & "'")
I have a report base on a...
|
|
3 |
76 |
|
|
|
|
9 |
112 |
|
|
Less of Two...but not ZERO by
cnistler
I'm looking to take the lesser of 2 data values (in different colums) but
only when the data is greater than 100. Here's an example:
Col A Col B Desired...
|
|
3 |
121 |
|
|
Passing Public varialble to a query by
Frank
Hello,
I've got a button that when pushed will declare my VarCurrQry variable as a
parameter that I then want to pass to a query.
From reading posts it...
|
|
5 |
58 |
|
|
|
May 16th, 2007 02:04 PM
by Klatuu
|
1 |
77 |
|
|
|
|
4 |
64 |
|
|
|
May 16th, 2007 09:47 AM
by Marco
|
4 |
78 |