Re: Who yields - client or developer? Your opinion

Dear Graham:

While you cannot reference a column name from the query inside the Eval() string, you can work around it for simple cases, which is all I expect you need.

For example, in a query, put:

  Eval(CStr([Ingredient Rate]) & "* 7")

and you will get the ingredient rate times 7 as a numeric result.

The string "* 7" could come from another column in another table, where you look up the conversion using the units of measure.

Before going too far, make up a list of all the necessary conversions. If you'll post them here, I'll bet we can solve this in a flash.

Tom Ellison
Microsoft Access MVP

Graham Bellamy wrote:

> 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 Thu May 30 2002 - 00:50:52 CEST