Please watch out for that lookup. You could be trying to filter the content
of that field thinking its a text field when really it's a number field.
These sentences do not make sense. They contradict each other.
I have a field named Purchase Method with that's a Lookup,this is in a table.
I do have a field for each purchase method,
If you persist in working in a table and in using lookups then it will be
very difficult to know how to advise you.
You need to be working in a query and one without lookups.. PurchaseMethod
may be a primary key number linking to a table listing the Purchase methods
and not the text field which you see displayed but you will never know that
Get rid of your lookups in your tables by replacing the Combos in Table
Design with Text boxes and then take the time to add combo boxes to your
forms instead. In the long run, it will be worth it.
I suspect you are trying to do things in reports which should be done in
your query but you say (or seem to be saying) that you are working in a
table with lookups.
You say that
In > my Report in which I can select either Web Site, Direct Bill, or Eplans
I
have no problem with the totals
then what is your problem?
Do you have your report grouped by Payment method with eg
=sum(MyCashField) in the group footer?
If this is what you mean, then all you need to do is to copy and paste the
same text box into the report footer to sum the whole field.
If you mean that you want to add up several text boxes which say
=Sum([Field1]) and =Sum([Field2])
just add a textbox and type into it
=sum([Field1]) + Sum([Field2]) + Sum([Field3])
Evi
teelee said:
I have a field named Purchase Method with that's a Lookup,this is in a table.
I do have a field for each purchase method, which I'm gathering by the (bad
lad) is not the way to go. The TPM and AuthNetCharge would only be subtracted
with the EPlan and Web Site Charge. The Direct Bill is that, Direct Bill. In
my Report in which I can select either Web Site, Direct Bill, or Eplans I
have no problem with the totals. The problem I'm having is to show the totals
in the Report for all Plans, which has the plans customers and purchase
methods. Am I going with this the wrong way? is there another way to do this?
Thanks in Advance
Evi said:
What is the name of the field which tells you how the product has been
purchased? Or do you (you bad lad!) have different field for each purchase
method?
Do you need to subtract AuthNetCharge and TPmCharge (whatever they are)
from all these methods?
or do you need to do different things with the other methods?
Instead of having one field which tries to do it all, you could use
different fields in your query so
assuming you have been good and have the purchase method in a field called
ChoiceField, in one column in your query you can have
TotalEPlan: IIF([ChoiceField]<>"E Plans",0,whatever arithmetic you do on
your E plans)
thus the field will contain 0 if Choice field doesn't contain E Plans)
Total this field
Evi
Evi
I have a Query set up this way Total:
[WebCharge]-[AuthNetCharge]-[TPmCharge]. This works great when I want to
see
the the total for web Charges. But I have 3 ways in which products can be
purchased, which are: Web Charge, E Plans, and direct bill.
The problem I'm having is I don't know what expression to use to total in
my
reports to show all totals. When I see the Report I want all the totals to
show. I have on report form a way that I can select which way I would like
to
view purchase methods, I just can't seem to figure out how I would have
the
report show all purchase methods and the totals.
Thanks
