Expressions and Total Row

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello -

I've created an expressions dividing two fields in my query. When I leave
the total row as defaulted, 'group by', I'm prompted for parameters (which
are already in my query). When I change the total row to 'expression', the
query runs. Now I want to sort assending by this expression, and again I'm
prompted for the parameters.

Any help would be appreciated.

Marc
 
Total Sales: Total Retail Sales
Total Cost: Total Cost of Sales
Store COS %: [Total Cost]/[Total Sales]
 
That isn't your sql. A WAG suggests you might want to replace your derived
column names with the expressions that created them.
Store COS %: [Total Cost of Sales]/[Total Retail Sales]

--
Duane Hookom
MS Access MVP


Marc said:
Total Sales: Total Retail Sales
Total Cost: Total Cost of Sales
Store COS %: [Total Cost]/[Total Sales]

Duane Hookom said:
Share your SQL and prompts.
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Query problem 1
Parameter Query with DSum 1
Need Help with Totals Query 24
Parameter/Criteria settings for percentage expression field 2
Total Expression Help 4
Crosstab query error 1
Calculations in a Totals Query 4
trying to get a sum in access 2003 1

Back
Top