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...

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

How can i delete all ole objects from my database I tried update table set field = null but it does not work thanks

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...

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...

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...

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...

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...

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...

MASTER Table: ClaimsPrimaryKey DETAIL Table: AutoNumberPrimaryKey Date ClaimsPrimaryKey ClaimsStatus This represents, of course, a one-to-many...

When I build a simple expression in a querry based on two other fields, both numeric, the result is a text/Date value. e.g., Expr1: + When I try to Format...

Hello, This seems to be a problem but I cannot figure out why... SELECT qryEmpDates.EmpFirstLast, DateAdd("yyyy",,) AS EmpAnniversery,...

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),...

I've entered the following expression in a query: TotalPay: (*)++ The query doesn't return the resulting calculation. What am I doing wrong? -- Chris

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...

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...

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...

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 ** --

=IIf(DCount("*","UM Files"," IN ('Y','N') AND =#" & & "#")=0,"N/A",FormatPercent((DCount("*","UM Files"," ='Y' and =#" & & "#")/DCount("*","UM Files","...

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...