I have various tables in one form. I want to calcuate the currency fields.
But not all fields have a number. One table has the final cost to the
customer, one table has the handling fee, one table has my fees and credits
from invoices. I want to be able to add the profit numbers and subtract the
subtract the fees to me and add the credits to me.
Should this be done in a query instead?
I tried doing this in the form design, but I am only able to choose from the
list of that particular table. I need to be able to choose all lists in all
tables.
--
Lisa F

Lisa F wrote:
>I have various tables in one form. I want to calcuate the currency
> fields. But not all fields have a number. One table has the final
> cost to the customer, one table has the handling fee, one table has
> my fees and credits from invoices. I want to be able to add the
> profit numbers and subtract the subtract the fees to me and add the
> credits to me.
> Should this be done in a query instead?
> I tried doing this in the form design, but I am only able to choose
> from the list of that particular table. I need to be able to choose
> all lists in all tables.

I would likely do it in a query because I find it more intuitive to do
it that way. You should be able to do it either way.

--
Joseph Meehan

Dia duit

Joseph - what is your reply? there was nothing there.
--
Lisa F


"Joseph Meehan" wrote:

> Lisa F wrote:
> >I have various tables in one form. I want to calcuate the currency
> > fields. But not all fields have a number. One table has the final
> > cost to the customer, one table has the handling fee, one table has
> > my fees and credits from invoices. I want to be able to add the
> > profit numbers and subtract the subtract the fees to me and add the
> > credits to me.
> > Should this be done in a query instead?
> > I tried doing this in the form design, but I am only able to choose
> > from the list of that particular table. I need to be able to choose
> > all lists in all tables.
>
> I would likely do it in a query because I find it more intuitive to do
> it that way. You should be able to do it either way.
>
> --
> Joseph Meehan
>
> Dia duit
>
>
>

Lisa F wrote:
> Joseph - what is your reply? there was nothing there.


I replied at the bottom of your message.

>> I would likely do it in a query because I find it more intuitive
>> to do it that way. You should be able to do it either way.



>
>> Lisa F wrote:
>> >I have various tables in one form. I want to calcuate the currency
>> > fields. But not all fields have a number. One table has the final
>> > cost to the customer, one table has the handling fee, one table has
>> > my fees and credits from invoices. I want to be able to add the
>> > profit numbers and subtract the subtract the fees to me and add the
>> > credits to me.
>> > Should this be done in a query instead?
>> > I tried doing this in the form design, but I am only able to choose
>> > from the list of that particular table. I need to be able to choose
>> > all lists in all tables.
>>
>> I would likely do it in a query because I find it more intuitive
>> to do it that way. You should be able to do it either way.
>>
>> --
>> Joseph Meehan
>>
>> Dia duit

--
Joseph Meehan

Dia duit

What does "dia duit" mean?
--
Lisa F


"Joseph Meehan" wrote:

> Lisa F wrote:
> > Joseph - what is your reply? there was nothing there.
>
>
> I replied at the bottom of your message.
>
> >> I would likely do it in a query because I find it more intuitive
> >> to do it that way. You should be able to do it either way.
>
>
>
> >
> >> Lisa F wrote:
> >> >I have various tables in one form. I want to calcuate the currency
> >> > fields. But not all fields have a number. One table has the final
> >> > cost to the customer, one table has the handling fee, one table has
> >> > my fees and credits from invoices. I want to be able to add the
> >> > profit numbers and subtract the subtract the fees to me and add the
> >> > credits to me.
> >> > Should this be done in a query instead?
> >> > I tried doing this in the form design, but I am only able to choose
> >> > from the list of that particular table. I need to be able to choose
> >> > all lists in all tables.
> >>
> >> I would likely do it in a query because I find it more intuitive
> >> to do it that way. You should be able to do it either way.
> >>
> >> --
> >> Joseph Meehan
> >>
> >> Dia duit
>
> --
> Joseph Meehan
>
> Dia duit
>
>
>

I found your reply. It did not stand out. I thought your reply was dia duit,
whatever that is.
If I can do it either way, then how is it done in the form?
--
Lisa F


"Lisa F" wrote:

> What does "dia duit" mean?
> --
> Lisa F
>
>
> "Joseph Meehan" wrote:
>
> > Lisa F wrote:
> > > Joseph - what is your reply? there was nothing there.
> >
> >
> > I replied at the bottom of your message.
> >
> > >> I would likely do it in a query because I find it more intuitive
> > >> to do it that way. You should be able to do it either way.
> >
> >
> >
> > >
> > >> Lisa F wrote:
> > >> >I have various tables in one form. I want to calcuate the currency
> > >> > fields. But not all fields have a number. One table has the final
> > >> > cost to the customer, one table has the handling fee, one table has
> > >> > my fees and credits from invoices. I want to be able to add the
> > >> > profit numbers and subtract the subtract the fees to me and add the
> > >> > credits to me.
> > >> > Should this be done in a query instead?
> > >> > I tried doing this in the form design, but I am only able to choose
> > >> > from the list of that particular table. I need to be able to choose
> > >> > all lists in all tables.
> > >>
> > >> I would likely do it in a query because I find it more intuitive
> > >> to do it that way. You should be able to do it either way.
> > >>
> > >> --
> > >> Joseph Meehan
> > >>
> > >> Dia duit
> >
> > --
> > Joseph Meehan
> >
> > Dia duit
> >
> >
> >

Lisa F wrote:
>I found your reply. It did not stand out. I thought your reply was dia
> duit, whatever that is.
> If I can do it either way, then how is it done in the form?
>

Dia duit, is Irish Gaelic. It is an all purpose greeting, meaning "May
God be with you"

How about some more information.

I would like to know what data you need from what tables? What is the
relationship between the tables? Give me some names (real or made up) for
the fields and tables. Also provide a sample calculation showing what
fields/tables each of the numbers came from. It might also be helpful to
know exactly what data type each field is.

It is not necessary to include field names that do not enter into this
calculation.

--
Joseph Meehan

Dia duit