Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Who yields - client or developer? Your opinion

Re: Who yields - client or developer? Your opinion

From: Graham Bellamy <dontwriteme_at_ask.first.com>
Date: Thu, 30 May 2002 04:58:44 +1000
Message-ID: <ad3864$b3u$1@perki.connect.com.au>


It's not that it doesn't work in a form (though it would be nice if it accepted the Me keyword, or even better, simply the control name, but that's another thing). It's that I really need to use it (or an equivalent method) in a query. The reason is that this Ingredient Rate is used to calculate the quantity, and from that the cost of the ingredient. Then I need to calculate the total cost of all ingredients for the item, then the total cost of all items in the job. Then I would be able to create various types of cost reports.

"Tom Ellison" <tellison_at_jcdoyle.com> wrote in message news:3CF475A1.F6F26656_at_jcdoyle.com...
> Dear Graham:
>
> I was not thinking of putting the Eval() not only in a query, but in a formula on your
form
> that calculates the quantity extension.
>
> What isn't working about it?
>
> Tom Ellison
> Microsoft Access MVP
Received on Wed May 29 2002 - 13:58:44 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US