|
|
|
|
6 |
108 |
|
|
|
|
1 |
94 |
|
|
|
|
1 |
110 |
|
|
|
|
1 |
119 |
|
|
Update Query by
NEWER USER
I have a table with 4 fields and some duplicate values in Field1. Field2 has
values, but no duplicates. Field3 and Field4 are null at this time.
I want to...
|
|
3 |
80 |
|
|
Append query works, but doesn't... by
ionic-fire via AccessMonster.com
I have some custom append queries wrapped inside a transaction. They execute
just fine using the db.Execute, strSQL, dbFailOnError method.
Problem is, after...
|
|
2 |
80 |
|
|
Crosstab Queries by week by
MarieT
I need to make a crosstab query that has, as a column heading, the date of
the beginning of the week in which the date value in the record falls. I know
how...
|
|
2 |
83 |
|
|
Query by Month field for the Year by
TL
I would like to set-up a query that will extract the date for January based
on the Date field being between 1/1/2008 and 1/31/2008. This should be a...
|
March 14th, 2008 12:20 AM
by TL
|
5 |
103 |
|
|
Update Query by
Justin
I have text data in my table formated 11-11-11. I want to change the "-" to
":" so the result will be 11:11:11.
|
|
2 |
62 |
|
|
Transforming an IF...Then to Case...When by
Michiel via AccessMonster.com
Hi,
I try to converet this simple If...Then to a Case...When but get error
mesaages.
Anyone can help me to pinpoit my error?
IF...THEN (which works)
select...
|
|
6 |
79 |
|
|
a precedence problem? by
Pwyd
All right. So i have several fields in this query. Here's my problem: if i
remove the part about "alba" "natasha" and "yohannes" it includes everything.
...
|
|
6 |
91 |
|
|
Problem Query by
Lisa
When I run this query I get one nember for cases shipped.
SELECT tblInvoiceHistALL., tblInvoiceHistALL.
FROM tblInvoiceHistALL
WHERE (((tblInvoiceHistALL.)...
|
|
9 |
126 |
|
|
|
|
2 |
84 |
|
|
testing for errors by
Anne
woI am comparing amounts in tow fields:Billing Difference:
IIf(,-), which gave a lots of
empty fields and one field shows 0.00.
My second step is to show...
|
|
1 |
78 |
|
|
|
March 13th, 2008 06:53 PM
by Wiley
|
7 |
123 |
|
|
|
|
1 |
79 |
|
|
APPEND QUERY FED FROM FORM DOES NOT WORK by
BlueWolverine
Hello,
MS ACCESS 2003 XPPro
So I have this form with some fields that the user fills in by hand. They
don't link back to a table or anything but some VBA...
|
|
3 |
82 |
|
|
Expanding/Denormalizing by
croy
I'm not even sure how to title this question...
Table_1 holds values for DATE, PLACE, TYPE_ID, SIZE_ID,
SHAPE_ID, and QUANTITY.
Table_2 (lookup) holds...
|
March 13th, 2008 06:07 PM
by Chris
|
1 |
64 |
|
|
Why does it multiply my 'sum' by 17? by
Love Buzz
Ok. I am working with a select queury and all I am trying to do is sum two
numbers in a column together that share the same 'queue'.
For some reason it's...
( 1 2)
|
|
14 |
180 |
|
|
Add time from a date/time field by
Qaspec
I have a column named PlannedStartDate that contains a date/time field
(ex:2/29/2008 3:15:08 PM) in another column i want to to show what the
date/time would...
|
|
2 |
64 |