|
|
Remove text from a field by
StratfordWard
Hello All:
We are trying to update about 8,000 customer records and unfortunately
inherited some fields that heretofore had very few input parameters. We...
|
|
2 |
143 |
|
|
Crosstab Column Headings by
Movies Man
None of the Field Names are showing up as column headings for my crosstab
query.
Here is my SQL:
TRANSFORM Avg(dbo_tblTranCHECK.DISC_PRINT) AS...
|
|
1 |
166 |
|
|
|
July 10th, 2008 11:05 PM
by Rus925
|
7 |
194 |
|
|
Calculate Year from Current Year by
MB
I have a table that has a field called YearInstalled. Data type is Number
(long integer) with validation rule: Is Null Or Between 1000 And 2999. (I
only...
|
July 10th, 2008 09:24 PM
by MB
|
4 |
182 |
|
|
Query that by
Matthew Pfluger[_2_]
I am designing a database that stores tasks, hours, start dates, and end
dates. Management wants to see an estimated hours by month for each task.
Example: ...
|
|
3 |
150 |
|
|
|
|
3 |
188 |
|
|
|
|
0 |
126 |
|
|
Need help with query linked to form. by
Dan
Hi, I am trying to run a query based off of an unbound field in a form.
Essentially I would like the end user to input a date in the form and hit the
command...
( 1 2)
|
July 10th, 2008 06:09 PM
by Dan
|
10 |
214 |
|
|
Question on Query Comparing 2 values by
Joe C
Hello Group,
I have 2 recordsets with the 2 exact same fields. I would like to
perform a compound comparison of the 2 fields from each table. That
is;...
|
July 10th, 2008 05:58 PM
by Joe C
|
2 |
166 |
|
|
Help with complicated query? by
fktx
I am still new to Access and queries, but I understand the basics of SQL. I
have my table set up in the following format:
StationID Date_Time ...
|
July 10th, 2008 05:54 PM
by fktx
|
8 |
141 |
|
|
Delete query by
JOM
I have a table that has 20 fields and might contain duplicate information
based on 3 fields(ID, LoanNum, date). How do I create a delete query that
would...
|
|
2 |
185 |
|
|
= by
blancla
I created this expression from other 2 expressions
Expr3: IIf(,"MISS","HIT")
Expr1 is a variance from Field1 and Field2
Expr2 is Field2 x 2%
Expr3 should be...
|
|
1 |
145 |
|
|
Access SQL Question by
Kevin
I'm trying to UPDATE the value of a COUNT() operation into a field viz.
UPDATE table1 SET field = ( SELECT COUNT(*) FROM table2
WHERE table1.PrimaryKey...
|
July 10th, 2008 04:43 PM
by Kevin
|
3 |
157 |
|
|
Deranged Calculation by
KWhamill
I'm not sure this is going to make any sence
I need to take the Sum of these amounts in table A and B grouped by Account
# separetly and then compare them ,...
|
|
6 |
197 |
|
|
|
July 10th, 2008 03:46 PM
by bswood7
|
2 |
191 |
|
|
A couple of text parsing questions by
scubadiver
Question no.1
Eg, the following
NORCREST, , WOODSIDE ROAD, , , BANCHORY, KINCARDINESHIRE, AB314EN
How do I get "AB314EN" on its own ie. just the text after...
|
|
3 |
185 |
|
|
|
|
3 |
213 |
|
|
Delete all modules but 1 by
auujxa2 via AccessMonster.com
Here is code I have that deletes all queries, forms, and reports. The last
part I want to delete all modules but one. Any ideas? Case 4 is modules,
and the...
|
|
4 |
252 |
|
|
Picking up last 4 letters from a field by
CAM[_2_]
In my query I have an account account number that I only want to pick the
last 4 letters. The account number has 8 numbers and text. This field is
actually...
|
|
2 |
204 |
|
|
Module problems by
Jennifer
I have my queries,tables, modules, and macros all set up. Below is the
function my module serves. I changed the name of a table, and it will not
work now- I...
|
|
2 |
192 |