Printable View
I want to know how to display only a record for a month if there alot of records in that particular month. For example, in the month of July, i have 3 records in my database, 12th of July, 21st of July and 28th of July. How do i just display the 28th of July for that particular month? Now i am only able to display all for that particular month, and i have many other months too! HELP!
One option is to use the date field and Group the report by month. Use the Group Footer to display the record rather than the Detail Section.
so any coding needed anywhere for the grouping.? cos i tried grouping, and sort by month, they came out all the records for the month.
Group By Month.
Sort By Date in ascending order.
Suppress the Details section.
Print everything in the Group Footer section which essentially means only the last detail record will be printed.
hmmm. sounds logical. shall go try and reply asap. :duck:
er.. still not working. they do show the last record. but it shows the last record of every date. OMG!:eek2: :eek2:
Ok. For example, my form prompts the user to choose the search range using a datetimepicker, From and To Date(For Example, From 28th Apr 2006 to 27th Jul 2006). When the user clicks the search button, the form will then pass the value from the datetimepicker to the report, recieved by the parameterfields and stores the value in the fields to perform searching and displaying. The solution that i have done is only able to display all the dates that is within this date range. The solution you gave me only show the last record for every date. yup. I want to display only one record for that particular month for that particular company. yup. By the way, thanks for attending to me so far. =)
Hi Coke,
for this i think you need to pleay with selection formula, something like this
..SelectionFormula= "{Tbl.Date1} >= #" & Me.DatePicker1.selectedvalue & "#" and "{Tbl.Date2} >= #" & Me.DatePicker2.selectedvalue & "#"
hope this helps
ta
It still seems like you are not Grouping By Month.Quote:
The solution you gave me only show the last record for every date.
Post a screenshot of the Group Options dialog for the date field.
thks faizee :)
this code is type in the report.? and wad does the"#" means? wad is tbl? care to explain? :)Code:..SelectionFormula= "{Tbl.Date1} >= #" & Me.DatePicker1.selectedvalue & "#" and "{Tbl.Date2} >= #" & Me.DatePicker2.selectedvalue & "#"
oh btw, brucevde , i solve it with your method, displaying the fields in the group footer, but i added another group, so that for every month, every Company last Record will be display! :) but got one more small problem. the last record is not the latest date. So how can i sort them so that the latest date is the last Record.?
And Lastly, the Numbering of the record is abit funny:confused: anyhow jump here and there :afrog: how to solve this.?
never mind abt the numbering. i deleted it. so no more problems for that. haha. ok.