Re: Query for Left(String,5) - Access 2007

Tech-Archive recommends: Speed Up your PC by fixing your registry

I did try createding an access table from the linked exxel file and using it
instead of the linked excel file only because I can't think of anything
else, but same issue. As soon as I try to go to the bottom of the result list
and/or export the results to excel I lock up with 100%cpu usage until I end
task. Just for kicks I tried my usual metod of putting the like "*12345*" in
the name.zip criteia and that works fine except that I have to manually put
the zips in and can only put in so many before the query is too big and I
have to run it multiple times to get all the zips in...yuk.

Thanks
John


"JohnH" wrote:

No Null values. There are 64 records in Boston and all have valid zipcodes.
Boston is the only field in the table. It is a Linked Excel file if that
means anything.

Thanks
John


"John Spencer" wrote:

I would look for a null value in one (or more) of the Boston.Boston
values. If that is the case, the query is going to try to link every
record in the NAME table to that record (or records) in the Boston table.

So, are there any records in Boston table where the Boston field is
blank (null)? If so, we need to work around that.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================


JohnH wrote:
Well John it sort of worked.
The query runs and I see my data but if I try to do something like go to the
end of the list or export it to Excel Access locks up and I have to
Taskmanager end Access to get out.

Not sure what that's about?

Thanks
John

"John Spencer" wrote:

Well, you certainly can edit the SQL view. I do it all the time and
often I start there.

The Query design view actually creates SQL. It is just a user interface
that simplifies the process of writing the SQL.

If you open the sql view you should be able to paste the code I posted
into it. You might want to make a backup copy of your current query first.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================


JohnH wrote:
Thanks John,
Where do I enter sql code to create a query? I've never used anything other
then the design view for creating queries. I've never fully understood the
point of the sql view since you can't edit it? I suspect I can edit sql
somewhere?

Thanks
The-other-John

"John Spencer" wrote:


.

Relevant Pages

  • Re: Corstabquery or normal query
    ... This is my SQL for Query: ... "John Spencer" wrote: ... 2007 Deacon Bob 1 ...
    (microsoft.public.access.reports)
  • Re: Using If expressions with an Or expression, and a Count questi
    ... "Amin" wrote: ... you guys (and a cool SQL website) so I am now coding exclusively in SQL. ... "John Spencer" wrote: ... IT is the ENTIRE query. ...
    (microsoft.public.access.queries)
  • Re: Trim Data
    ... The query does run and returns all other fields correctly except this one ... "John Spencer" wrote: ... please post the SQL of the query. ... "KARL DEWEY" wrote: ...
    (microsoft.public.access.queries)
  • Re: Query expression help
    ... Yes your SQL wors great! ... SQL into a query and try to look at it in design view it gives me an error ... "John Spencer" wrote: ... quarter for that one employee. ...
    (microsoft.public.access.gettingstarted)
  • Re: DBMS and lisp, etc.
    ... Naively implemented with SQL, again for 10 ... (1 query for the initial orders, 1 query for each order for its ... soon as you upgrade to the SQL database. ... (eq (order-customer orderA) ...
    (comp.lang.lisp)