 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / December 2005Math Problem w/ Reports - Need Help
I have information that I would like to print out in my report, much like when it sums the information for you. However, what I need the report to do is subtract the information in the columns not add it. Is there a way to do this in the reports section? If not how could I build a query to do this? Example of what I am looking for is below. Week# Day Date Sales Total NOR 32 Tues 20040809 879005 5.476988186 20050808 924072 4.945177432 'Day' = Tues (2 detail records) 45067 0.5318100754 Can anyone help? You've provided a sample of the output -- how you want your results displayed. What we don't know is your input -- how your data is stored. A query may (or maybe not?!) be able to take your (table) data and massage it part-way (or all the way) into what you want printed in your report. Specifically how it would do that will depend on how your data is stored!  SignatureMore info, please ... Jeff Boyce <Office/Access MVP> > I have information that I would like to print out in my report, much like > when it sums the information for you. However, what I need the report to do [quoted text clipped - 10 lines] > > Can anyone help? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.