|
|
|
|
1 |
303 |
|
|
|
August 29th, 2004 10:19 PM
by tina
|
1 |
110 |
|
|
Date Value: Week Begin by
Bernie
I'd like to use an expression to identify the Week
Beginning date (using Monday) of a given entered date
value.
Users can enter any day of the week, but I...
|
August 30th, 2004 12:58 AM
by Bernie
|
2 |
303 |
|
|
IIf(IsError... by
beppe005
I am trying to use the two functions IIf and IsError in a query in this way,
which is wrong (since it doesn't work):
Total: IIf(IsError(/;0;/)
my intenttion...
|
|
4 |
85 |
|
|
MAX vs. LAST by
Dave
Hi all,
After creating a formula to extract the 6 right most characters from a 7
digit code and then returning the last one, I found that the results...
( 1 2)
|
August 30th, 2004 02:39 AM
by Pike
|
10 |
210 |
|
|
Find a word in comments field by
David
I can create a query that finds a word in the "comments" field (200 char
text field).
I need the results to show the word searched for plus the next 7...
|
August 30th, 2004 10:24 AM
by Bonnie
|
3 |
123 |
|
|
Function?!? by
Dan
Hi:
Store Date
1 01-Aug-04
1 03-Aug-04
2 04-Aug-04
2 05-Aug-04
3 06-Aug-04
****************
I have many stores thata should send data every day for
|
|
1 |
91 |
|
|
IIF formula by
hermie
If have the next IIF formula
=IIf(IsNull(),,IIf(IsNull(),,))
This formula works, it shows the fields porhora and mensual but not the
field salario_otro?
What...
|
August 30th, 2004 01:16 PM
by hermie
|
6 |
132 |
|
|
MSAccess won't start by
Keith Bryers
I can't get into my MS Access (1997), running on Windows
98, this error window opens:-
MSACCESS caused an invalid page fault in
module unknown at...
|
August 30th, 2004 02:28 PM
by
|
1 |
139 |
|
|
Make Table query gets ODBC Error by
Robin Hughes
Help! I am running an Access 2002 query to create a table
from an ODBC file on a AS400. I am running under Windows
98. I can open the linked table without a...
|
|
1 |
237 |
|
|
|
|
1 |
109 |
|
|
How do I show more than one contact type? by
Erika
I am new to Access. I have downloaded the Contact Management template and am
hoping to tweak it to meet my needs. The main problem I'm having seems like
it...
|
|
1 |
158 |
|
|
Joins Problem by
esi
Running the following query and I'm not getting my desired result:
SELECT tblPayroll2004.Period, tblDepartments.,
Sum(tblPayroll2004.Hrs) AS Total_OVTHrs,...
|
|
1 |
193 |
|
|
Recordset not updatable by
ExcessAccess97
I made a query for an end user. The query works, but when
the user filters the list, it becomes un-updatable. Why
does this happen how can I get around...
|
|
1 |
175 |
|
|
Using date range in query criteria by
Kathi
I have a form that gathers a date range that is then used
in a Between statement in my query. But, I would like to
include all records if the date is not...
|
August 30th, 2004 03:10 PM
by Kathi
|
4 |
398 |
|
|
Delete/append queries in macro firing late by
Kendra
Hello,
I have a macro created from the combination of two action
queries, a delete query and an append query. The delete
query deletes a record if a certain...
|
August 30th, 2004 05:06 PM
by Kendra
|
0 |
495 |
|
|
VBA HELP by
JIMBO
What if I have more than one query, say for example:
SqlStringA = Transform Query code
SqlStringB = Select Query Code
SqlStringC = Joins SqlStringA and...
|
|
1 |
89 |
|
|
Simple DMax lookup with "Like" filter by
Stan S.
I need to find the record in tblResults (Access database) with the largest
entry in the "SPECIMEN" column and I want to do it from VBscript only. I am
after...
|
August 30th, 2004 06:09 PM
by Stan S.
|
7 |
191 |
|
|
Big brain problem! by
Jeff Klein
I have a table with check boxes for every day of the week. My query shows
all dates (between MonthStartDate and MonthEndDate) if its respective
checkbox is...
|
August 30th, 2004 08:33 PM
by Jeff
|
2 |
146 |
|
|
|
|
3 |
405 |