Recent content by accessma

Is there a way to assign a field a value temporarily in a query? My problem seems to be that if you are calculating a percentage of say 15,000 which in this case are total sales. That number is the total of two categories; East and West. The East and West totals are aggregates of months...

You and me both....

Thanks but sorry no. Same result. You think the Abs val is hiding the minus sign?

Here is what I changed it to: SELECT ApTest.[GrossAmt], ApTest.[VenNum] FROM ApTest WHERE (((ApTest.[GrossAmt]) In (SELECT [GrossAmt] FROM [ApTest] GROUP BY Abs ([GrossAmt]), [GrossAmt] HAVING Count(*)>1 ))) ORDER BY Abs ([GrossAmt]), ApTest.[GrossAmt]; Runs and finds dups but no "-" sign...

Would you alter my query to show me what is correct? Its the only way I will get it. Thanks

Confused, its already being grouped by Abs ([GroupBy])? Are you saying put it somewhere else?

That threw the followinf error: "You tried to execute a query that does not include the specified expression "GrossAmt" as part of an aggragate. Here is what ran: SELECT ApTest.[GrossAmt], ApTest.[VenNum] FROM ApTest WHERE (((ApTest.[GrossAmt]) In (SELECT [GrossAmt] FROM [ApTest] GROUP BY Abs...

Using this query: SELECT ApTest.GrossAmt, ApTest.PaidAmt, ApTest.DistAcct, Abs([GrossAmt]) AS Expr1 FROM ApTest WHERE (((ApTest.GrossAmt) In (SELECT [GrossAmt] FROM [ApTest] As Tmp GROUP BY [GrossAmt] HAVING Count(*)>1 ))) ORDER BY ApTest.GrossAmt; I can successfully find all the positive...

I got this far but it says I have an extra ( near my Abs part of the query. Microsoft and Google help not that much help. Can anyone see the syntax error? SELECT ApTest.InvNum, ApTest.PoNum, ApVenTest.VenNum, ApVenTest.VenName, ApTest.GrossAmt, Abs([GrossAmt]) AS Expr1 FROM ApVenTest INNER...

I should clarify my error I get, says I am trying to execute a query that does not include the specified expression 'GrossAmt' as part of an aggregate function.

Changed it to this: SELECT ApTest.[GrossAmt], ApTest.[VenNum] FROM ApTest WHERE (((ApTest.[GrossAmt]) In (SELECT [GrossAmt] FROM [ApTest] As Tmp GROUP BY Abs ([GrossAmt]) HAVING Count(*)>1 ))) ORDER BY ApTest.[GrossAmt]; Now it throws an error saying it cant find GrossAmt

I've got this query. SELECT ApTest.[GrossAmt], ApTest.[VenNum] FROM ApTest WHERE (((ApTest.[GrossAmt]) In (SELECT [GrossAmt] FROM [ApTest] As Tmp GROUP BY [GrossAmt] HAVING Count(*)>1 ))) ORDER BY ApTest.[GrossAmt]; Which works fine but I I want to include negative amounts as being a...

Im saying import a text file, scrub it deleting the extra spaces, and convert it to a tabbed file using VBA.

Here is the BE

I have an unusual problem. I have a form called frmSample. On the form are several combo boxes which the user can select different criteria and then the query collects the entries, selects the records and loads them into the form called frmProject. There are lots of problems getting it to...