|
|
converting text to % by
Ted[_6_]
i know this is not hard...i've done it before but i'm drawing a blank
if i have a field: ConDedAmount which holds a value of 5% as text how do i
(in a...
|
January 29th, 2008 10:28 PM
by Ted 
|
3 |
138 |
|
|
|
SELECT statement syntax confusion by
noe1818 via AccessMonster.com
I'm lost.
I would like an unbound text box to pull up a value from another field.
so,
SELECT
FROM
WHERE (in the fasting table) = (from this table) AND
...
|
|
2 |
144 |
|
|
Help with query searching within a string by
BradC
I want to enter data character by character into a combo box and search the
field for matching records. Ex: if I type in "a" any records containing the...
|
|
4 |
184 |
|
|
|
dlookup with 3 criteria by
noe1818 via AccessMonster.com
Here is my expression:
=IIf(DLookUp("","","=""" & & """
And =" & & " And =" & )=True,
DLookUp("","","=""" & & """ And
=" & & " And =" & ),0)
Client ID is...
|
|
1 |
150 |
|
|
|
DateAdd Working Day Query by
hobbit2612 via AccessMonster.com
Hi,
I wonder if someone could help me please.
I'm trying to write an expression (see code below) within a query where I
calculate 15 working days from a a...
|
|
7 |
141 |
|
|
|
Is Not Null? by
Tony Williams
I have a query where I want to use Is Not Null in the criteria to check
whether there is data in a text field. However when I run the query I still
get all...
|
|
4 |
108 |
|
|
|
Zero length String? by
Bongard
Hi, I have a TEXT field in my query whose criteria is a Function
NodeFilter(). This function looks to a form that allows the user to
fill in data and then runs...
|
|
1 |
114 |
|
|
|
Query expression removing leading zeros by
Design by Sue
I have a database to keep track of part numbers that are 5 digits and a
suffix that can be up to three digits. My table are set up with a format of
00000...
|
|
4 |
157 |
|
|
|
Date -Data Type by
D
Hi:
Can you please tell me how to change the Binary data type for date to
Date/Time data type.
I have the below qry. (make table) where I enter the report...
|
January 29th, 2008 05:03 PM
by D
|
2 |
102 |
|
|
|
|
January 29th, 2008 04:38 PM
by Mike
|
11 |
157 |
|
|
|
Query Left Command Help by
mattc66 via AccessMonster.com
Hi All,
I want to find the first 2 or 3 letter in the field. The data is the users
initial followed by a number. Sometimes they enter there 2 or 3...
|
|
5 |
158 |
|
|
|
IIF statement run amuck by
RedHeadedMonster via AccessMonster.com
I'm running a query that shows sums of several fields. For one field I want
to replace a null with 14. Im using the follwoing conditional statement in
the...
|
|
2 |
79 |
|
|
|
TOTAL column in query by
Aurora
I am using Access 2003
I have a database in which I keep track of retirement inform such as hours
worked per year which is convered into credited service year...
|
|
1 |
89 |
|
|
|
Record is deleted error by
mattieflo
Hello,
I have a table called Orders that keeps track of a list of Orders for a
week. I'm trying to append to a table called Orders Archive which keeps track...
|
|
5 |
190 |
|
|
|
|
|
0 |
80 |
|
|
|
Running sum running by date order by
אייל המבולבל
I have the following problem.
I would like to create a running sum on a form or a query. It should sum
PurchaseAmount but I have a problem with the where...
|
|
1 |
113 |
|
|
|
Select records based upon date by
richard
Hi
I need to create a report which shows the number of samples received from
each client in each calendar month.
I need advice on the query to select the...
|
|
1 |
84 |
|
|
|
|
|
3 |
129 |
|
|
|
IIf function for 3 possible outcomes? by
levi252
I want to calculate a rate for 3 types of Gears (coded "OT04S", "OT16S", and
"POT02S". I've used IIf in the past when the database contained only 2 Gear...
|
|
3 |
129 |
|
|
|
|
January 29th, 2008 02:06 PM
by gmcco
|
5 |
112 |
