Append with multiple criteria??

[Gary F Shelton]

Want some advice on how to design some data. I have created an inventory table.
In the table it has many fields which provide good reference points. I now
want to have a new field "Go Sell" that is as simple as telling me a yes or
no indicator.

The issue I have is this. In the inventory table there are sku's that are
discontinued, damaged, past shelf life, approaching shelf life, on quality
release staus, etc etc etc... that are ready for sale. In my new field "Go
Sell" how would one advise that I write the many different append queries to
the new table as I don't want to do this manually?

 

[KARL DEWEY]

How are ypou recording 'sku's that are discontinued, damaged, past shelf
life, approaching shelf life, on quality release staus, etc?'
Post sample data and your table structure with field names and datatype.

 

[John W. Vinson]

Want some advice on how to design some data. I have created an inventory table.
In the table it has many fields which provide good reference points. I now
want to have a new field "Go Sell" that is as simple as telling me a yes or
no indicator.

The issue I have is this. In the inventory table there are sku's that are
discontinued, damaged, past shelf life, approaching shelf life, on quality
release staus, etc etc etc... that are ready for sale. In my new field "Go
Sell" how would one advise that I write the many different append queries to
the new table as I don't want to do this manually?

I don't think you need either a new field OR an Append query. An Append query
will create completely new records in some table - and I don't see what point
there is to a new table.

I would suggest instead that you simply create a Query based on your inventory
table, using all of the various criteria which determine that an item is "go
sell". This Query would simply display all such items and could be used as the
basis for a report or form. The query would need to use OR logic (by putting
the criteria on each field on a separate line in the query grid) so that the
item would show if it's approaching shelf life, OR if it's on quality release
status, OR whatever else.