|
|
Using If or Iif to determine a value by
CW
I have a query that calculates various costs. There's one field that has 3
possible values, and depending on what it is the value (cost) can be shown in...
|
|
3 |
182 |
|
|
Edit Update Query by
dburrells
How do i get into an already created Update Query in order to edit it?
|
|
1 |
157 |
|
|
|
|
4 |
188 |
|
|
Len Function by
Jackie
Would appreciate some help as I'm a novice Access user. I have a table with
employee numbers. The majority are 7 characters (text) that start with a
letter...
|
|
2 |
203 |
|
|
Dividing across queries by
OverMyHead
Is it possible to create a query that divides the results of one query by the
results of another query?
If so...how?
Thank you to all for any help you can...
|
|
2 |
163 |
|
|
Create a distinct Join by
webicky
Using Access 2003, It is easy for me to a distinct Left join: Table 1
ID has 157 unique ID records. table 2 has 249 records some duplicate
records in order...
|
|
3 |
202 |
|
|
Update Date value to current year by
helpmeplease
How do I update the "Hire Date" date value to the current year or the next
year if the "Hire Date" is less then 365 days old to be shown as an
evaluation due...
|
|
3 |
148 |
|
|
find the latest date in access 2007 by
roch bell
hi there!
I'm a bit stressed trying to get this sorted by I just cant!
My question is the following. I have a database of three tables: Dis_cat, admission...
|
|
2 |
155 |
|
|
Searching for a digit or letter only by
Grd
HI there,
I need to query a product_code which is a text column. I want all results
whe
The first 'letter' is a 6.
The second letter must be a letter (not...
|
|
6 |
288 |
|
|
|
|
3 |
137 |
|
|
Date in Access field is ######## by
CSR@AEWJL
I recently ran a query based on the date field. Ever since then, some of the
dates in the field show up as ###### instead of the date I originally
entered. ...
|
|
1 |
168 |
|
|
|
|
1 |
160 |
|
|
Deleted information by
way over my head
I deleted tables that had relationships to my master query. Now i can only
see the master in SQL which I have no experience in. I've tried other means,...
|
|
2 |
150 |
|
|
|
|
5 |
254 |
|
|
Total line makes query too complex by
kratz
So I have created my functions to calculate the expected deduction per
deduction per agent number per account number. The problem I am having now is
that I...
|
January 7th, 2010 08:51 PM
by kratz
|
0 |
170 |
|
|
Ampersand in Query Criteria by
AG[_3_]
Access 2000 through 2007.
How can I escape the ampersand used in query criteria?
If I type a & b as criteria in a query, Access changes it to "a" & "b".
The...
( 1 2)
|
January 7th, 2010 08:29 PM
by AG[_3_]
|
12 |
495 |
|
|
|
|
1 |
149 |
|
|
Pivot Table Averages by
jschping
Hi,
I have a table where I have lists of colleges that my students have applied
to as well as their status. The table has fields for student ID (foreign key...
|
|
0 |
195 |
|
|
IIf function, & Date(), & AND, & & by
Hurrikane4
I'm trying to get the query to check if an anniversary date is within the
next 30 days, so I tried using this formula, but it did not work.
Your help is...
|
|
6 |
184 |
|
|
Office 2007 - rename query problem by
finster26
I'm using Office 2007 - Access. I rename a working query. I run the query but
it asks for a paramater which has the old name it. For example: ...
|
|
2 |
151 |