access calculation issues

  • Thread starter Thread starter jeff
  • Start date Start date
J

jeff

Long story
I sell full time on ebay and I have their Sales Assistant
pro program which I run my business on. One of the joys
of the program is that I can print out access consignment
sales reports for each seller of mine and a profit and
loss report for my own products.

Either way I don't know how basic this problem is but
their support can't seem to help me so it's probably
something like tying your shoes. I don't know what info
you need to be able to help or even if you want to help
but here goes.

The page is a group header, details and group footer
I need to get the sum of a column, in the details section
of that column I have:
(Name) Sales
DataField =[AmountDue]-[ShippingCost]-[InsuranceCost]
text Sales

In the group footer (where the total SHOULD be I have:
(Name) SumOfSales
DataField =[AmountDue]-[ShippingCost]-[InsuranceCost]
text '=Sum([Sales])

I hope some of this means something to some of you, I
have tried every combination I could think of and cannot
get the column to total.
If you can and are so inclined I would appreciate any
help you could give me.
 
Hi, Jeff.

I'm not familiar with Ebay's applications, but I'll try to help anyway. It
appears that you are trying to make a calculation in the detail section of
your report and putting this calculation in a text box named "Sales" so that
you can see how much income you have from each sale. Then in the Group
Footer section, where one usually places the totals of columns, you are
referencing this text box, but you can't display the sum of this "Sales"
column.

You have another text box, "SumOfSales," in the Group Footer section to
calculate the sum of these incomes for the entire group. But instead of
displaying the sum, you are only displaying the same value in the "Sales"
text box of the last record in the group.

Am I right so far?

If so, then you only need to change the value in the Control Source of the
"SumOfSales" text box in the Group Footer section so that it reads:

=Sum([AmountDue]-[ShippingCost]-[InsuranceCost])

and make sure that the "Running Sum" is set to "No" for this text box.

The reason that you you are having trouble displaying the sum of the "Sales"
column is because "Sales" isn't a column from the query or table used as the
RecordSource for this report. "Sales" is merely a calculation for each
display of each record. The reason that the syntax above works is because
it references columns in the query or table used as the RecordSource for the
report.

Access wizards make it look like database applications are so simple that
even a child could do it. Don't be fooled. Access has a pretty steep
learning curve, and manipulating reports to display exactly what you want
requires some skill. (Hint: do the calculations in the query. It's far
easier to create calculations in the query for the report and just use the
report to display and format the results.)

HTH.
Gunny

Coming soon:
For your Microsoft Access, database development and maintenance needs, see:
http://www.softomagixly.com


jeff said:
Long story
I sell full time on ebay and I have their Sales Assistant
pro program which I run my business on. One of the joys
of the program is that I can print out access consignment
sales reports for each seller of mine and a profit and
loss report for my own products.

Either way I don't know how basic this problem is but
their support can't seem to help me so it's probably
something like tying your shoes. I don't know what info
you need to be able to help or even if you want to help
but here goes.

The page is a group header, details and group footer
I need to get the sum of a column, in the details section
of that column I have:
(Name) Sales
DataField =[AmountDue]-[ShippingCost]-[InsuranceCost]
text Sales

In the group footer (where the total SHOULD be I have:
(Name) SumOfSales
DataField =[AmountDue]-[ShippingCost]-[InsuranceCost]
text '=Sum([Sales])

I hope some of this means something to some of you, I
have tried every combination I could think of and cannot
get the column to total.
If you can and are so inclined I would appreciate any
help you could give me.
Click to expand...
 
Back
Top