Status Column

[andyaerial]

Hi guys,

Another problem I need help with...

I have a table that contains a list of items. These items are tables, chairs, cofas, tvs and the like. What I am after is a way of creating a column that is like a 'status' column. For instance the values would be 'stock' 'sold' 'scrapped' 'written off'. How do I create this column so that either of my three forms could change the value? I used to have an excel spreadsheet that did this for me however the amount of data that that sheet had to hold became too much and I 'm now upgrading to an access database. My excel formula was this:-

=IF(TRACKER!R2,"SCRAP",IF(TRACKER!P2,"W/ OFF",IF(TRACKER!AG2,"STOCK",IF(TRACKER!AE2,"SOLD",IF(TRACKER!AA2,"STOCK",IF(TRACKER!Y2,"SOLD",IF(TRACKER!U2,"STOCK",IF(TRACKER!Q2,"SOLD","STOCK"))))))))

any help would be appreciated.

I'm using access 2007.

 

[jdraw]

Hi guys,

Another problem I need help with...

I have a table that contains a list of items. These items are tables, chairs, cofas, tvs and the like. What I am after is a way of creating a column that is like a 'status' column. For instance the values would be 'stock' 'sold' 'scrapped' 'written off'. How do I create this column so that either of my three forms could change the value? I used to have an excel spreadsheet that did this for me however the amount of data that that sheet had to hold became too much and I 'm now upgrading to an access database. My excel formula was this:-

=IF(TRACKER!R2,"SCRAP",IF(TRACKER!P2,"W/ OFF",IF(TRACKER!AG2,"STOCK",IF(TRACKER!AE2,"SOLD",IF(TRACKER!AA2,"STOCK",IF(TRACKER!Y2,"SOLD",IF(TRACKER!U2,"STOCK",IF(TRACKER!Q2,"SOLD","STOCK"))))))))

any help would be appreciated.

I'm using access 2007.

Strongly recommend you get some info on database design.
Here's a good starting point.
http://www.allenbrowne.com/casu-22.html

Here's a link to some data models to help identify some of the things that you may need to consider in your database.
http://www.databaseanswers.org/data_models/index.htm
Look at some of the Business rules and models, perhaps some will help.

 

[andyaerial]

Thanks for your advice, but after watching that video and reading some of those articles it's still not clear to me what is required.

Could you shed any more light on it or even give me a starting point from which I can learn to create this column?

The database is going to be used as an active log and the items that come into my place are all unique, therefore a table with product codes,ids and a stock level is not applicable.