Re: Query for Left(String,5) - Access 2007
- From: JohnH <JohnH@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 1 May 2008 14:36:03 -0700
Hi John, wanted you and Klatuu know I solved my problem. I can do the query
using design view if I simply don't do a join between the zip table and the
name table. I just put the cireteria in the where clause that you and Klatuu
said to use and tha did the trick.I'll bet you two just assumed I was doing
that already. Sorry it took so long for the light to dawn.
Thanks again for your help.
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:
- Prev by Date: RE: Crosstab query problem
- Next by Date: Do you have to pay for the translating service on Office?
- Previous by thread: convert zero-length to Null
- Next by thread: Do you have to pay for the translating service on Office?
- Index(es):
Relevant Pages
|
