|
|
Recordset automatically updates by
NevilleT
I am updating some records using a standard VBA function. I want to create a
history record to show the old and new values. The approach I used was to
create a...
|
February 20th, 2007 11:35 AM
by NevilleT
|
2 |
191 |
|
|
ERROR: aggregate function? by
musosdev
Hi, I wonder if someone could help. I'm trying to run the following query on
an Access database..
SELECT Stories.StoryTitle, COUNT(Comments.CommentID) AS...
|
February 20th, 2007 10:38 AM
by musosdev
|
4 |
129 |
|
|
Round 4 decimals up by
Pilgrim
Hello, Using MS 2002. I know this is spelled out below but - need a liitle
help. I have records that have a cost field out to 4 decimals (12.034). I
would...
|
|
4 |
153 |
|
|
Export filename being trancated to 8 letter by
Peter Tickler
When exporting queries to DBF (Dbase IV) format, the filename is suddenly
being truncated to 8 letters. I am using Access 9.0.7616 Sp-3.
Is this the result...
|
|
0 |
128 |
|
|
Ambiguous outer joins by
gmore
Hello folks!
I've got a problem. I guess it's why we always come in here when that's the
case :)
I have three tables as follows:
SIR (PK : id)
SIR_D (PK :...
( 1 2)
|
|
11 |
332 |
|
|
Free Flash Games by
Flash Games
Free Flash Games http://www.clipplay.com/ fun videos games and more.
Fun flash games. Free flash games videos and more.
|
|
0 |
186 |
|
|
Add 1 when T/F fields are true by
Rod
Hello,
I have a field, . I have 6 true/false fields, , ,
, , , and . I would like to count the number of time
is true and store that value in .
My...
|
|
2 |
110 |
|
|
Add to Data by
LindaC
I have one form I am using for users to enter info on their archive records.
They will input all fields except the location in the warehouse where their...
|
February 19th, 2007 11:14 PM
by Smartin
|
1 |
109 |
|
|
calculating "how many" months by
buckpeace
If I have 2 fields (DOB) and (service date) How woudl I calculate the
number of months between them? I need to use an access query to calculate
that. ...
|
|
3 |
305 |
|
|
|
February 19th, 2007 09:40 PM
by Anna
|
0 |
135 |
|
|
|
|
1 |
121 |
|
|
Repeated Data by
K
Good day,
I have two query’s that are linked together to generate information from two
different tables and return the information into one query.
Table 1...
|
|
7 |
152 |
|
|
Figure months from a anchor date by
buckpeace
Lets say a child was born on 5-15-2004. (dob = Field 1)
There is an immunization SERVICE date (Field 2) of 5-18-2005
I need to write a query that will show...
|
|
2 |
128 |
|
|
Make Table query from a Linked Table by
conrad
Hello all,
I am trying to create a Form with a command button that executes a "Make
table" query with "date" criteria "Between !! And !!" that references...
|
|
2 |
117 |
|
|
|
|
13 |
227 |
|
|
Append Query by
Red via AccessMonster.com
Good day everyone,
I have an append query that is mis-behaving. When I view the query it shows
the correct records that should append but when I actually run...
|
|
4 |
216 |
|
|
|
|
3 |
134 |
|
|
Expression on a report by
oxicottin
I have an unbound text box with the expression =Sum().
I want to categorize by text box . For example, the sum of shift 1 is
12 hours, shift 2 is 24 hours,...
|
|
6 |
115 |
|
|
|
|
3 |
166 |
|
|
WHERE AND OR by
Tamal
Dear Sir
I have to select from the field EXCHNG_CODE containing GMV or MBH and frm_dt
contain 01/01/1986 or 01/01/1995.
I have written in the quary as...
|
|
2 |
135 |