Solved

Compile error in query expression

Posted on 2004-10-05
3
715 Views
Last Modified: 2012-05-05
Hi,
I get a compile error when trying to execute this query:
SELECT Mid([Location Name],10,4) AS Branch
FROM Receives;
The [Location Name] = US BANK #0585 WRIGLEY BUILDING
Let me know what it can be.
Thank you
0
Comment
Question by:lnchopo
3 Comments
 
LVL 15

Accepted Solution

by:
will_scarlet7 earned 125 total points
ID: 12226664
Hi lnchopo,
There does not seem to be anything wrong with your query statement. Is it possible that your table actually stores the Location ID # in [Location Name] instead of the text name of the Location, and it is using a lookup to ge the text name?

Sam
0
 
LVL 1

Expert Comment

by:tiffanyhale
ID: 12250434
I tried to duplicate your error, however the query works fine.  

Are you getting the error when you run a query or are you running code using the SQL statement to produce the results?
0
 

Author Comment

by:lnchopo
ID: 12276789
I was able to adjust the raw data before I have to work with it. Sorry for the late response.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question