total cost

[steve111]

hi,

In my report I have a various amount of lines that show items to purchase
these line items have a cost

I have got a total cost for each line item
but I need this cost to go below the final items to be purchase weather it is one item or 20

at present the total cost is at the top of the report , as I don't want it at the bottom of the page

any help appreciated
steve

 

[steve111]

sample attached please enter number "1" when prompted P/O number please see total cost in header I would like it after the last line of line items line items could be one or 50 thanks again steve

 

[rm.harper]

sample attached please enter number "1" when prompted P/O number please see total cost in header I would like it after the last line of line items line items could be one or 50 thanks again steve

(might be me but i cant access the report once the file is opened in access)

If your totals box works but you just wish to change its position its simple really; right click the totals box>hover over LAYOUT and click remove. You are then free to move the box anywhere on the report.

If this isnt your problem then my solution wont work


Im having a similiar sort of problem; i have a total box now which calculates Quantity x Price and gives me a total. Unfortunatly this is a pre vat price so i would like it to calculate the vat and then a grand total.

Subtotal: £0.00 (=[quantity]*[price])
VAT: £0.00 (=[Subtotal]*0.2)
Grand Total: £0.00 (=[Subtotal]+[vat])

Just dont know how to do it, tried loads of different ways but think im missing a simple but vital step which is messing with it all

 

[bob fitz]

Hi Steve,
Try the attached db and let us know if this is what you want please.

 

[steve111]

hi bob , once again yo have done a great job for me
I can now see why I kepted getting repeated line item total costs

2 parts of the jigsaw completed

thanks
steve