Prev: jeramie bellmay
Next: Count occurrences
From: KARL DEWEY on 22 Jan 2010 19:28
Not need for experssion builder just use the query field as source for the
text box on the form.

--
Build a little, test a little.


"Bob H" wrote:

> KARL DEWEY wrote:
> > Take a closer look at what I posted. The multiplication function is an
> > asterisk and not an 'x' as you used.
> >
> > ([Shipping_Control].[CargoQty] * [tblValues].[Value]) AS CommercialValue
> >
>
> mmm, yes ok it is an astrisk, doh!
> Ok that works a treat now, but my next goal is to get the
> CommercialValue from that query into the text box on the main form.
>
> I have tried using an expression builder which points to that
> CommercialValue from that query (qryPartValue), but it doesn't do
> anything, and when I go back into design view to check it, the
> expression has gone from the control source, and is using the
> CommercialValue control source from the table instead.
>
> Thanks
> .
>
From: Bob H on 23 Jan 2010 04:58
KARL DEWEY wrote:
> Not need for experssion builder just use the query field as source for the
> text box on the form.
>

Yes, thats what I thought initially, but the said control source from
the qryPartValue which gives me the Commercial Value, is not showing in
properties. I can't see how to get it there as a source.

The main Shipping_Control form uses the tblShipping_Control as the
source, and the controls from that table are the only ones showing/available

Thanks
From: KARL DEWEY on 23 Jan 2010 22:07
In the main Shipping_Control form source SQL you have to join the
qryPartValue to tblShipping_Control.

If you can not do it then post both and someone can show how to do it.

--
Build a little, test a little.


"Bob H" wrote:

> KARL DEWEY wrote:
> > Not need for experssion builder just use the query field as source for the
> > text box on the form.
> >
>
> Yes, thats what I thought initially, but the said control source from
> the qryPartValue which gives me the Commercial Value, is not showing in
> properties. I can't see how to get it there as a source.
>
> The main Shipping_Control form uses the tblShipping_Control as the
> source, and the controls from that table are the only ones showing/available
>
> Thanks
> .
>
First  |  Prev  | 
Pages: 1 2
Prev: jeramie bellmay
Next: Count occurrences