Views: 6 Size: 450.6 KB">CGVending.zip
Here's my latest database for my C & G VENDING app. It's almost complete. Just a few details remain to be worked out. Here's one of them.
Begin by bringing up the main screen and printing two reports. The first is the Soda Tally Report (green label). The second is Annual Summary Report (light orange label).
All data in these reports is for demo purposes only. No actual or confidential information is contained in them, so you have the run of the entire app.
The Soda Tally Report itself is ready to go, along with similar reports for the other three groups (Coffee, Snacks, and Supplies).
I don't need any help with the Soda Group Report or its identically structured reports for the Snacks, Coffee, and Supplies groups.
The reason I'm showing you a typical one of these reports (for the four locations of the Soda group) is that I want to extract
group (=location) totals from each report (=16 groups in all, printed on four separate reports, each with four subgroups)
and pour them into appropriate fields in the Annual Summary Report.
Confession: I cheated setting up the present Annual Summary report by creating a table linked to a form, into which I manually typed in dummy numbers.
So all of the present data was just typed in by me, not magically calculated and entered by Access. The first two column-blocks on the left
are what concern us here. To their right is a section of summaries which need not detain us here, since they're just extracted and consolidated
from data in the two columns on the left. It's those 16 group totals that I'm after.
I want the Summary report to be a separate single item, not glommed onto the tally reports. What I need to learn how to do is how to
reference each group total on a separate report. Specifically, in the Tally reports the Unit Cost field is divided by the NoInUnit field, producing
the dollar amount for a single piece (such as a can of pop). Then that single piece price is multiplied by the count (tally) for each item.
Thus, with Root Beer in the Soda Tally North Machines, the unit cost ($45.345) is divided by 24 (number of units in a full case) to
determine the price for a single can. Then that's muliplied by 25 cans counted in the inventory to get a total value for Root Beer of $47.234.
(I need three decimal place accuracy for this report).
I'm NOT concerned with any of the Grand Totals at the bottom of the Tally reports for purposes of the Annual Summary. I'll get them
the "normal" way by calculated fields within the Annual report--once I have the 16 chunks of group totals data.
Thus, in the Soda Tally report, teach me how to transfer the $149.912, $276.000, $296.309, and $389.306 totals from the Value column
into the corresponding slots in the Annual report.
I know how to manipulate "regular" data from one place and get it to another. But I think calculated fields like these are a different critter,
and presumably require different techniques to move them around.
Perhaps one could give a distinct name to each group. For example, in the Soda group, we could have SodaNorthMachinesTotal, SodaNorthStoreTotal, etc.
However it's done, I want Access to do the following:
Look in the Soda Tally Report and capture each total for the four groups. Then transfer that information into the control sources for each of the corresponding
fields in the Annual Report. Repeat for all the other groups.