SQL Expression Question 1

[brainmetz]

Everytime I run the following code:

SELECT (All_Urls.[Computer Name]), (-1 * (All_Urls.[URL Address] LIKE '*att*') * Sum (All_Urls.[SumOfTotal Time])) AS [SumOfSumOfTotal Time]
FROM [All_Urls]
GROUP BY (All_Urls.[Computer Name]);

I recieve an error stating:

You tried to execute a query that does not include the specified expression '(-1 * (All_Urls.[URL Address] LIKE '*att*') * Sum (All_Urls.[SumOfTotal Time])' as part of an aggregate function.

Can anyone please help me decifer this message.

Thanks in advance.

 

[coco86]

I think this might solve your problem:

SELECT (All_Urls.[Computer Name]), Sum(-1 * (All_Urls.[URL Address] LIKE '*att*') * Sum (All_Urls.[SumOfTotal Time])) AS [SumOfSumOfTotal Time]
FROM [All_Urls]
GROUP BY (All_Urls.[Computer Name]);

OR

SELECT (All_Urls.[Computer Name]), Sum((-1 * (All_Urls.[URL Address] LIKE '*att*') * All_Urls.[SumOfTotal Time])) AS [SumOfSumOfTotal Time]
FROM [All_Urls]
GROUP BY (All_Urls.[Computer Name]);

OR (but probably not what you want)

SELECT (All_Urls.[Computer Name]), (-1 * (All_Urls.[URL Address] LIKE '*att*') * Sum (All_Urls.[SumOfTotal Time])) AS [SumOfSumOfTotal Time]
FROM [All_Urls]
GROUP BY (All_Urls.[Computer Name]),(-1 * (All_Urls.[URL Address] LIKE '*att*') * Sum (All_Urls.[SumOfTotal Time]));

Depending on what you're trying to do.

 

[brainmetz]

Thanks your secondone worked...i just had to change my data type from Memo to text with 255 characters.

The first one returned the same error as I had before.

Thanks alot.