more dimensional method like a query...

Hi,
i have a problem with a query.
First i have stocks, depending on 4 attributes. Its like a tree, so
there are 16 possible querys. Like the stock hat batchs, and the one
patchs is reserverd for diffrent projekts and some of the materials in
the stoch habe diffrent qualitys....
So i want to programm a Method with 4 attributes. All combinations of
the attributes are possible. Like getStock(batchA, ProjektX, QualityZ,
conditionF).
My question: How do i store the stock and how do i programm the
getStock method. I think arrays are not the best way...
Does someone knows a good way, or i hope there is allready a solution
somewhere. Because i cant be the first guy having this problem.
Thanks
Joe Black

.

Relevant Pages

  • RE: Help with creative thinking needed
    ... Also I note that it doesn't handle subqueries. ... Another specific name that comes to mind for query performance is Joe ... designated stock items and have a field of # of Days to Stock. ... Are there other ways of shaving milliseconds from calculations and queries, ...
    (microsoft.public.access.modulesdaovba)
  • Re: How do I set up a query with combo-box?
    ... table Stock, but it sounds like that might not be so. ... combo box first and open the query, or better still a form or report based on ... frmMyForm, based on the query put the following in the button's Click event ... The user now opens the unbound frmTypeDlg dialogue form, ...
    (microsoft.public.access.queries)
  • Re: Incrementing Days between two dates..
    ... Creating dummy records isn't usually necessary. ... generate data for a report, you can use a cross-tab query to ... > it from the sum of the stock and the deliveries. ...
    (microsoft.public.access.queries)
  • RE: Help with creative thinking needed
    ... designated stock items and have a field of # of Days to Stock. ... query to get sales info for each stock ... totals was considerably faster than using separate queries, ... Are there other ways of shaving milliseconds from calculations and queries, ...
    (microsoft.public.access.modulesdaovba)
  • Re: Displaying fields in a stock table
    ... Hi Steve. ... added a non visible column that was bases on StockID in the Stock Table. ... various forms linked to the Query allong with the correct Serial Numbers ... Box to display the Make/ Model text that is associated with the ID by ...
    (microsoft.public.access.gettingstarted)