|
|
|
|
37 |
2,097 |
|
|
|
|
3 |
270 |
|
|
WHERE by
skr
Can somebody please explain how WHERE works and under what circumstances it
should be used? I've found that it works for some of the things I want, but
I...
|
|
2 |
167 |
|
|
Office 2000 Access upgrade? by
TwylightZone
Can anyone give me a definitive answer as to whether I can use the Access
2007 Upgrade program to upgrade Access that came with the Office 2000?
|
|
1 |
112 |
|
|
Iif Statement by
Leslie
I am trying to get the user to input the policy number if auto assign is set
to no.
wrkfld1 : Iif( = "No", )
Except I get dialog box "Enter Policy Number"...
( 1 2)
|
February 27th, 2007 10:20 PM
by geebee
|
11 |
316 |
|
|
Update Query Question by
Gary Dolliver
Hello,
I am wanting to run an update query that will update specific records in a
table, and set a certain field to an already existing field, the first one...
|
|
2 |
156 |
|
|
Building Expressions - DON'T KNOW HOW by
Sandi
Ok - so here is my delima - I have an access database and I am using the
query feature and need the query to pull out specific information. The
problem is...
|
February 27th, 2007 09:23 PM
by Sandi
|
8 |
216 |
|
|
iif function in query by
skigal
I have an iif function in a query as follows:
Gas Jan 06-05: IIf(1,"",IIf(1,"",(-)/))
It appears to be calculating properly but I am not able to format the...
|
|
2 |
141 |
|
|
Averages by
skigal
I have a simple table consisting of 13 columns. The first col is the
location and the next 12 are the scores received in each of 12 months, some
months have...
|
|
6 |
123 |
|
|
|
|
4 |
192 |
|
|
|
February 27th, 2007 07:53 PM
by Alex
|
6 |
183 |
|
|
|
|
1 |
137 |
|
|
paramter query by
JRS
I would like a query where I am prompted (thinking parameter query) for a
name such as sally. the names however in the database are merged from many
systems...
|
February 27th, 2007 06:47 PM
by fredg
|
2 |
144 |
|
|
IIF Statements nested by
Todd
Hi, I this statement I wrote. It works for nearly all 7500 records except
for a sporatic 1,200! I can't figure out why. Any suggestions?
PartInj: IIf( Is...
|
|
5 |
167 |
|
|
|
|
4 |
116 |
|
|
|
|
5 |
247 |
|
|
Querys by
sebastico
How do I export a group of querys into a xls workbook?
|
|
2 |
112 |
|
|
Problems with “DateAdd” by
cage4000
Hi all,
I am trying to subtract one Weekday from which is a Date field
(dd/mm/yy), but it will only subtract 1 day in general, it will not remove
the...
|
|
2 |
139 |
|
|
how to make "update"query? by
Fuzuy
I wondered what kind of query I have to use( or what steps or others I
should do) to update a field which not only retain whatever it has
already had and...
|
|
1 |
124 |
|
|
Need Help with Comparing Tables!!! by
TotallyConfused
I had posted regarding this problem. Have not had a response that works.
Last response almost worked except it was not overwriting correctly. Thought
I...
|
|
3 |
142 |