Solved

ignore space between names within string

Posted on 2009-05-20
9
450 Views
Last Modified: 2012-05-07
The code below does not like the space between Manufacturer and Name:
Manufacurer Name
If i remove the space in between, the code works fine.
Is there a way to handle this?
SELECT Benchmark_LessThanr50Percent.* INTO test1

FROM Benchmark_LessThanr50Percent, [SELECT Benchmark_LessThanr50Percent.Manufacturer Name, Sum(Benchmark_LessThanr50Percent.Spend) AS SumOfSpend

        FROM Benchmark_LessThanr50Percent

        GROUP BY Benchmark_LessThanr50Percent.Manufacturer Name

        HAVING (((Sum(Benchmark_LessThanr50Percent.Spend))>100))]. AS Benchmark1

WHERE (((Benchmark_LessThanr50Percent.Manufacturer Name)=[Benchmark1].[Manufacturer Name]));

Open in new window

0
Comment
Question by:karinos57
  • 4
  • 2
9 Comments
 
LVL 119

Accepted Solution

by:
Rey Obrero earned 250 total points
ID: 24434095
enclosed it with square brackets []

[Manufacturer Name]
0
 
LVL 119

Expert Comment

by:Rey Obrero
ID: 24434113
copy and Paste this

SELECT Benchmark_LessThanr50Percent.* INTO test1
FROM Benchmark_LessThanr50Percent, (SELECT Benchmark_LessThanr50Percent.[Manufacturer Name], Sum(Benchmark_LessThanr50Percent.Spend) AS SumOfSpend
        FROM Benchmark_LessThanr50Percent
        GROUP BY Benchmark_LessThanr50Percent.[Manufacturer Name]
        HAVING (((Sum(Benchmark_LessThanr50Percent.Spend))>100))) AS Benchmark1
WHERE (((Benchmark_LessThanr50Percent.[Manufacturer Name])=[Benchmark1].[Manufacturer Name]));
0
 

Author Comment

by:karinos57
ID: 24434142
i am getting input message box which reads like "Enter Prameter Value"
0
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
LVL 119

Expert Comment

by:Rey Obrero
ID: 24434187
karinos57,
seen my second post?
0
 
LVL 1

Expert Comment

by:mcfitz13
ID: 24434853
Yeah that should do it.
0
 
LVL 119

Expert Comment

by:Rey Obrero
ID: 24503496
karinos57,

wondering why you have to accept a comment like that as the solution to your problem..
0
 
LVL 1

Expert Comment

by:mcfitz13
ID: 24503521
I agree.... I don't deserve anything.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

920 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now