 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / October 2005Dual Date function
I have a report that is generated by a query. My Query1 has these fields: fDate, Name, Amt In the Critiera field for (fDate) I have: Between [Start Date] and [Ending Date]. This all works fine on the report with Sum for Amt at the end of the report. The data looks like this fDate Name Amt 01/01/2005 Tom 10.00 01/05/2005 Joe 20.00 01/30/2005 John 30.00 01/30/2005 Frank 30.00 The user only want to print what he entered today which is 01/30/2005 Which he will enters in the Dialog box of dates 01/30/2005 and 01/30/2005 inturn, it prints two names and a total of $60.00. HERE IS THE PROBLEM: The user want to the total of the whole month of $90.00 but only see what he input on the dates he entered in the Dialog box. Is there a way of doing this? I only using simple query and reports functions? Thanks So, are you getting rid of one parameter prompt and just prompting for one date but including all the values for the entire month in the report footer? Or, are there still two dates entered?  SignatureDuane Hookom MS Access MVP >I have a report that is generated by a query. > My Query1 has these fields: fDate, Name, Amt In the Critiera field for [quoted text clipped - 20 lines] > functions? > Thanks I didn't change anything, there are still two date prompts. > So, are you getting rid of one parameter prompt and just prompting for one > date but including all the values for the entire month in the report footer? [quoted text clipped - 24 lines] > > functions? > > Thanks Could you provide some sample records that span several months and then a couple start and end dates and what you want to see in a report? SignatureDuane Hookom MS Access MVP >I didn't change anything, there are still two date prompts. > [quoted text clipped - 30 lines] >> > functions? >> > Thanks Also, there are other months in the database that I don't want to include. That's why I prompt for begin and end dates. > So, are you getting rid of one parameter prompt and just prompting for one > date but including all the values for the entire month in the report footer? [quoted text clipped - 24 lines] > > functions? > > Thanks Run two queries. One that gets the days transactions and set th criteria for fDate to =[Whatdate] and another that extracts the mont and year from [Whatdate] in the first query and is used to sum up th month. Make the first query the source of a report and then make a su report with the second query as the source. bladelock Wrote: > I have a report that is generated by a query. > My Query1 has these fields: fDate, Name, Amt In the Critiera fiel [quoted text clipped - 23 lines] > functions? > Thank -- jahoobob |
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.