Search results for query: *

I run this query and I still get the full count of 11,181 which in a sense is saying that a point inside one yard is by default outside another yard and therefore all points are counted. What I have done is made a query of a subquery (points inside the yards) LEFTJOIN/IS NULL which is working...

Attached the yard boundaries file as well so you can see the full picture. There are 18 lifts within the boundaries and there are 11,181 lifts in total in 'MyTodayLifts' which should give 11,163 which is what I am trying to...

Apologies Skip, I was replying to your 18:27 comment and never saw your 18:39. I have tried your NOT and some other variants like below but they all come up short. The story is that we have refuse trucks lifting/emptying refuse bins from households and there are some anomaly bins that get...

Skip ,yeah it does matter a bit as that would exclude valid lifts to the east and west of the yards, whilst that wouldn't amount to a whole lot of data points within this data set, the result with just using the Lats as suggested does not give near the correct result, only about 60%. I think as...

Thanks Skip, yes I need a kick in the head for mixing my ANDs and ORs up, However what was going on in my head was that I looking for Lats that were above and lats that were below the bounds of the yards. I tried what you suggested with the Lat and Longs but did not get the result that I...

Skip this was a prayer answered, I went on expecting to have to trawl through many threads to find an answer to my question but i found it in the very first thread. My query was very similar in that I had GPS points for Bin lifts in the lifts table L, and I had upper and lower bound GPS points...

Thanks again Duane, I have started to convert my major data churning read only queries into pass-through queries, all the time that I will save now not having to watch spinning discs I will use to push my boundaries that bit further, thanks again

Thanks Duane NOT IN was what I was looking for although something to note was that the sub query as presented in access just choked, the tables are linked tables to a SQL database across a network but I just ran the suggested query on the SQL Server side and that worked a charm (although not...

Hi I have a table that contains different transaction types for customers and I am looking for a list of customers that does not have a particular transaction type. What I have and it works, is one query that gives me all the customers from that table that have that transaction type and then I...

Excellent Andy, Thank you so much for that Queries within queries, where will it all end?

MS Access does it VBA does it VB6? I am linked to a MS SQL Server Database and my vba knowledge is of no use. I try the 2 following methods but neither work An update recordset which has more than one table linked but only updating a single field does not work Set objRs = New...

I have an access adp project file that I created on access 2000, when I try to run it in access 2007 it just doesn`t recognise the sql cmd instructions and I get the error "the text, ntext, and image data types cannot be compared or sorted except when using IS NULL or Like Operator, which makes...