summing fields

[diesel_medic]

Hi,

I am currently trying to produce an accountancy package of use with Ebay in Access. I have a table that lists all the expenditure, as imported from Ebay/Paypal. For each record there is a field that records the nett valve of the transaction as well as a field, 'OverheadType' which categorises each transaction. The source of this field is a combo box of fixed values - Advertising, Bank Fees etc. I would like to be able to display the totals for each of these 'OverheadTypes' in a form (frmProfitAndLoss) using a start and end date (selected by the user on the same form) to select which records to process. I've tried to do this by extracting the information and storing it as one record in a temporary table, but without any success. Any ideas?

 

[KeithG]

Select [OverheadType],Sum([Net Value])
From YourTable
Where date between [Start] and [end]
group by overheadtype

 

[diesel_medic]

Thanks for that, just what I was after.
Now the problem I have is displaying the results. I have a form (frmProfitAndLoss), which has text boxes to display the results of the above query. Is there a way of geting the text box to display the contents of one field, based on the contents of another field in the same record. I could write a loop, but I was wondering if there was a simplier way of doing it.

 

[KeithG]

I don't understand the question, can you give an example. Almost anything can be done.

 

[diesel_medic]

I don't understand the question, can you give an example. Almost anything can be done.

The query creates a 2 field table, the first field listing the the different 'OverheadTypes' and the second the summation of the values associated with those 'OverheadTypes'. I wish to extract the numeric values and display them in text boxes on a form, so I need to be able alocate the value in each textbox, depending on the value in the 'OverheadType' field.