|
|
Sorting by Week and Year by
sq75222
I have a problem on the soting by week, when i convert date to week ( "ww
YY") and sort as ascending the results is not i want see as below.
Week : 1...
|
March 31st, 2008 02:41 AM
by sq75222
|
2 |
115 |
|
|
Query AND criteria by
Fly Boy 5
I'm trying to find models 250, 350, 550 and 750 by using "And" criteria. It
seems to only work with two of the four.
Any help would be appreciate.
JW
|
|
4 |
118 |
|
|
|
March 30th, 2008 05:16 PM
by IElite
|
1 |
102 |
|
|
Union query and exclusion of data by
Syed Zeeshan Haider[_2_]
Hello Everybody,
I am usin Access 2003 Pro and trying to create a rather complex union query
but don't seem to implement conditions.
Let's say I have two...
|
|
4 |
101 |
|
|
Update query by
PeterR
I am trying to update my clients labour & materials rates from april 1,
using the client & materials tables.
The update works fine in the query, but when I...
|
|
1 |
86 |
|
|
Query based on other queries problem by
Gridrunner
I am trying to find a work-around for the read-only problem when a query has
a Group By clause in it. I am working in Access 2007. Here is a summary of
what...
|
|
2 |
84 |
|
|
Update Query Question by
mcl[_2_]
I have successfully used update queries to change a values to a specific new
value.
But I realized for the 1st time when I tried using it to update fields to...
|
|
3 |
100 |
|
|
Maybe a Crosstab Query by
Proko
I have a table called Tbl_Jewellery with the fields lng_JewelleryID and
str_Metal. Some jewellery can be made out of more than one metal so it is not...
|
March 30th, 2008 06:06 AM
by Proko
|
2 |
105 |
|
|
Update Query Question by
mcl[_2_]
You have obviously never used ESRI's ArcGIS. It links to a table NOT a
query. I'm not exporting anything.
I open ArcGIS and add a layer. I point it to the...
|
|
0 |
101 |
|
|
Specific Detail Table Row by
Gary B[_2_]
MASTER Table:
ClaimsPrimaryKey
DETAIL Table:
AutoNumberPrimaryKey Date ClaimsPrimaryKey ClaimsStatus
This represents, of course, a one-to-many...
|
|
1 |
114 |
|
|
|
|
3 |
101 |
|
|
Anniversery Dates by
Ernst Guckel
Hello,
This seems to be a problem but I cannot figure out why...
SELECT qryEmpDates.EmpFirstLast,
DateAdd("yyyy",,) AS EmpAnniversery,...
|
|
2 |
113 |
|
|
How many nulls in each field? by
Peter
I am importing large, 60 field 300,000 record csv files and am quickly
overloading Access. I need to query each table, once imported (all fields as
text),...
( 1 2)
|
March 29th, 2008 09:34 PM
by Peter
|
10 |
165 |
|
|
|
|
7 |
144 |
|
|
Looking for date field that is empty by
Aurora
I am using Access 2003.
I have a query in which I want to search for records that include a date
field that is empty. I tried - isnull - but that did not...
|
|
8 |
145 |
|
|
Website Help by
mestrebisli
im building a website and i tried using an accesss DB but i have 2 main
problems with it!
1. when i try to create the connection using:
new...
|
|
0 |
118 |
|
|
DCount function for filtered data in table by
Kaylen
Now I am thinking with all the experts in here, I am wondering if anyone can
help me with a formula that can calculate just the selective range of data of
a...
|
|
7 |
164 |
|
|
IIF in query by
samotek via AccessMonster.com
I have the following expression in my query :
Expr1: **
Can you hlp me build an IIF with the following condition :
If size 1 then **"2
else
**
--
|
|
1 |
137 |
|
|
What is wrong with this formula? Help! by
Kaylen
=IIf(DCount("*","UM Files"," IN ('Y','N')
AND =#" & &
"#")=0,"N/A",FormatPercent((DCount("*","UM Files"," ='Y' and =#" & & "#")/DCount("*","UM Files","...
|
March 29th, 2008 07:49 AM
by Kaylen
|
2 |
185 |
|
|
Query Help by
lmossolle
I am using the following on a Query, In this I would like to see a projected
days and a actual days. I am seeing all entries on the chart though. I only
need...
|
|
1 |
109 |