Don't Want Parameter Prompt! 3

[JOEYB99]

I'm using MS Access 2003. I use the Build function to sum two calculated sums - [sumofhours] + [sumofdays].

When I run my query it prompts me twice because of the square brackets. I click OK on these prompts and it gives me the correct results.

But how do I get rid of this parameter effect? It is annoying. Can someone please help me out?

 

[PHV]

What is your actual SQL code ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[LonnieJohnson]

It sounds like you have an aggregate query (using group by and sum). If so, the column that you are doing the sum on change the Group By on the Total line in the query grid to Expression in the drop down box and that should take care of it.

ProDev, Builders of Affordable Software Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!

 

[lespaul]

sounds like you are doing something like:

SELECT SUM(Hours) as SumOfHours, SUM(Days) As SumOfDays, SumOfHours - SumOfDays FROM TableName

you can't use an alias in the same query like that you have to do:

SELECT SUM(Hours) as SumOfHours, SUM(Days) As SumOfDays, SUM(Hours) - SUM(Days) As SomeOtherField FROM TableName

Leslie

Come join me at New Mexico Linux Fest!