Get grand total for "min" totals by group

[Metz]

I have just started trying to do programming in Access 97 at work.&nbsp;&nbsp;I am familar with tables, queries and reports.&nbsp;&nbsp;I want to set up a bidding table to get the lowest bid by Subcontractor by group (phase).&nbsp;&nbsp;I ran a report and got a &quot;min&quot; total by phase.&nbsp;&nbsp;Now I need to get a grand total of all these &quot;min&quot; totals.&nbsp;&nbsp;Can I do something that isn't too complicated to achieve this?<br>

 

[DougP]

In the Report Footer add a text box and put this<br>=Sum([YourFieldName])<br><br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.

 

[Metz]

When I put =sum([phase]) in the report footer, it gives me a total of all the phase amounts.&nbsp;&nbsp;I need to get a report that will give me the lowest bidding amount in each each phase.<br><br>sub&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;phase&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;amount<br>sub1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;02200&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$5,000<br>sub2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;02200&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$6,500<br>sub3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;03300&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$3,000<br>sub4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;03300&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$4,750<br><br>want the following results:<br><br>sub1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;02200&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$5,000<br>sub3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;03300&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$3,000<br><br>grant total&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$8,000<br><br>we want this report to show the lowest bidding subs and get a grand total for a bid.<br><br>thanks

 

[DougP]

you need a Group <br>Click &quot;View&quot; &quot;sorting and grouping&quot;<br>In the field/Expression pick a field to group on.<br>Look below that see Group footer put a &quot;Yes&quot; in there to<br>turn on Group Footer.<br>put the Sum thingy in the group footer too, it will sum each group. <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.

 

[Metz]

I am not trying to get a total by group, I am trying to get the lowest amount by group and then get a total of all the lowest amounts to get one grand total.&nbsp;&nbsp;This is so we can give the owner what the job is going to cost by phase.&nbsp;&nbsp;We are trying to find out who the lowest sub is for each phase.<br>

 

[Geekette]

dear metz,<br>what you need is the <b>min</b> function:<br><br><b>min([amount]) as (LowestBid) from <i>tablename</i> where.....</b><br><br><u> <i>then </u></i> do a sum:<br><b>sum([LowestBid])</b><br>