Re: union query with form critera

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

No beacue there is different data for each type, ie Book has ISBN,
movie has a DVD/VHS, etc. There is no status type, I determine the
status by the sold price. Inventory has sold_price = 0, Sold > 0, and
All has sold_price >= 0 or no where clause. A status column will not
work for this since an item can be both Sold and All or Inventory and
All.

Basically the WHERE part that I need to change will need to be one of
the three:
book_inventory.sold_price)>=0) ALL
book_inventory.sold_price)=0) Inventory
book_inventory.sold_price)>0) Sold

So the variable that will change is not the price but the equality
sign.

.

Relevant Pages

  • Re: Sold Shaman set... :[
    ... > vanished from your inventory, ... I'm not blaming them because of my mistake. ... I can understand if I sold an apple but it was an armour set I paid 60g. ... realized I lost it I was in an istance. ...
    (alt.games.warcraft)
  • Re: Inventory Database
    ... Create an option group on the Sales form with 4 option buttons or a combobox ... > I am working on creating a timeshare sales and inventory database. ... > be sold either by odd years, ...
    (microsoft.public.access.gettingstarted)
  • help with an array
    ... units in stock, the price of each unit, and the value of the inventory ... private double numberinstock; // number of movie in stock ... private double priceofitem; // the price of the movie ...
    (comp.lang.java.help)
  • Re: riftrax suggestion
    ... Not that it affects your argument, but I am not sold on RiffTrax, for at least two reasons. ... Not only do I have to buy the audio file, I have to rent the movie in question and work out a reasonable way to sync it up with an audio player of some sort. ...
    (rec.arts.tv.mst3k.misc)
  • Re: How would you...
    ... inventory and sell certain products. ... I don't need to track to whom products were sold, ... "Jeff Boyce" wrote: ...
    (microsoft.public.access.tablesdbdesign)