Query Totals

[jprsn]

Help!

I created a query to pull certain records out of a table.

I want to total only one field for each record pulled out of the query.

My questions is can you add a columun in a query?

I am finding that most calculaitons require (2) expressions!

How do I get a GRAND TOTAL???? The only way I have been able to do this is to import my query file to Excel.

Does anyone have an answer?

Thanks!

 

[MasterRacker]

What tool did you use to create the query? Post your question in the forum related to that product.
Jeff
masterracker@hotmail.com

If everything seems to be going well: you don't have enough information.......

 

[jprsn]

I am using Microsoft Windows 2000. Is this what you mean by what tool I am using?

This is the first time I have used Tek-Tips.

 

[MasterRacker]

Windows 2000 is an operating system.. You do not do 'queries' with an operating system. What program are you using to create this table and query?
Jeff
masterracker@hotmail.com

If everything seems to be going well: you don't have enough information.......

 

[jprsn]

Access 2000 is the program I am using.

 

[MasterRacker]

That's more like it. I know a little Access, but there are some very good people in the Access forum. Post your question there and you will get the help you need.

Programmers > DBMS Packages > Microsoft: Access - General Discussion is probably where to go.
Jeff
masterracker@hotmail.com

If everything seems to be going well: you don't have enough information.......

 

[jprsn]

Thank you for your response. I will try your suggestion!