DataBase - Print 7 days of data on a report

I need to print 7 days worth of a report. I tried Today()+7 and DATE()+ 7 to
give me 7 days but no joy.

Can someone help

Thanks

AL

  Allen Browne replied to AL Rios

If you wanted the previous 7 days, you might try this in the Criteria row in
query design under your date/time field:

--
Allen Browne - Microsoft MVP.  Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

  AL Rios replied to AL Rios

That woriked

Thank you


AL

Page Footer DataBase hi, here's my scenario of my problem i had one report (Report A) and it has a page footer once i viewed it the page footer appears, but when i sub report the Report A on a another report (Report B) the page footer of Report A does show and it supposed to be shown at the page footer of Report B. its there anyway to show the page footer of Report A to Report B

Count and Filter Result DataBase My report has = Count(*) in the group header and I want to filter the results. Report Example: IDnumber Group Header Total of Reports Last Name First Name Idnumber 2 Smith Joe show the records of reports with the total of 4 or more. Access Reports Discussions Report (1) DateDiff (1) Ccumodsactionsother (1) Ccusanctionsother (1) Dateofreport (1) Reviewdate (1) Sonya (1) Unit (1) Try this in the query used as source for the report - -- SELECT [Last Name], [First Name], [Idnumber], Count([Idnumber]) AS [Total of Reports] FROM YourTable WHERE current code for my query. Where would I put the below infromation? SELECT [Minor Disciplinary Report].Last, [Minor Disciplinary Report].First, [Minor Disciplinary Report].IDnumber, [Minor Disciplinary Report].Unit, [Minor Disciplinary Report].Dateofreport, [Minor Disciplinary Report].[Gpsanction 1], [Minor Disciplinary Report].[Asddsanctions 1

Combine report DataBase On the A report, I would like to link or insert the total field that is on the other report, report B. Is there away that I can make the report A shows the report B textbox ? Please help. Thanks Chi Access Reports Discussions Report (1) Chi (1) Subreport (1) Textbox (1) DEWEY (1) Use a subreport. - - KARL DEWEY Build a little - Test a little No, not unless report B is displayed as a subreport on report A. If report B is not used

Access2007 won't run report event procedures (e.g. Detail Format) DataBase Program control never calls the event procedures. Here are the only event procedures that run from the code listed below: - -- -- Report Open Report Load Report Activate Report Got Focus Detail Paint . . . Detail Paint Report Unload Report Lost Focus Report Deactivate Report Close - -- -- (Note: the 'End Sub' lines have been removed for posting) Option Compare