Current Expenditure

[Guest]

Hello,

I have query into expenditure data as at month end should be entered. An
example of the field format is given below
Item of Expenditure Jul 31 Aug 31 Sep 30
Water
Electricity
Rent

I want to create another column called "Current Expenditure" that should
give me the updated expenditure at any given point in time. i.e under the new
column, that data as at today should be that of 31 Aug.

I would be grateful for whatever support you guys can give to me on this

Thx

 

[Duane Hookom]

If your display is similar to your table structure then I would suggest you
either use Excel or study up a bit on normalization. There are some good
links from Jeff Conrad's site
http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html#DatabaseDesign101

If you have questions about this, come on back.

 

[Guest]

I have already tried Excel and I could not get what I wanted even when I
posted for support. I am also most getting to my goal in Access, the only
thing that now remains is to pick out the last entry and append it to my
column "Total Expenditure".

Reagrding the site, I would appreciate more specific guidelines, as I am not
so confortable as to where I should look on the site

Thx

 

[Duane Hookom]

What is the structure of your table or tables? A more normalized table
structure would have fields like:

Item -> text Item of Expenditure
ExpDate -> Date of Expenditure
ExpAmt -> Amount of Expenditure

 

[Guest]

I reckon that my table is fully normalised with the following fields;
Item of Expenditure
Expenditure Date (e.g 31 Jul is one field, 31 Aug is another field onto 30
Jun). Under these fields, the expenditure amount should be entered
accordingly.

I hope this would make things clearer.

 

[Duane Hookom]

If you have multiple date fields then your table is not fully normalized.

 

[Guest]

Hello,

I had actually given you the layout of my query.

My expenditure table has the item of expenditure as the primary key and the
expenditure fields named 31 Jul, 31 Aug up to 30 Jun

These expenditure fields have their datatype as numbers, they are not date
fields. I believe that my expenditure table is normalised. However, if you
have contray views please let me know.

Thx

 

[Duane Hookom]

I have told you several times already that I have contrary views and
provided a more normalized structure.

 

[Guest]

I did not get your input on how the structure could be more normalised.

 

[Duane Hookom]

From a previous reply:
========================
A more normalized table structure would have fields like:

Item -> text Item of Expenditure
ExpDate -> Date of Expenditure
ExpAmt -> Amount of Expenditure
========================