Reports
in [Access]
|
Has Anyone noticed the 3rd Quarter doesn't calculate in Northwind Using Northwind to set up quarterly reports in my db. The MonthOfQuarter: (Month([Inbound Date]) Mod 3) Separates the months quarters into 1,2,0 but the VB Code is set up for 1,2,3. The third month in any quarter shows a quantity of 0 for all Customers when there are numbers there to calculate. ... 16 Mar 2010 10:16
Conditional Formatting on client I have a report that uses conditional formatting to shade controls It runs without problem on access 2000, 2002, 2003 and 2007 Two 2003 clients have problems with the conditional formatting. No matter what I put in for an expression it formats as if the criteria is not met even Expression TRUE or expressi... 16 Mar 2010 13:58
Visibile property rpt_Events chkstatus (Check box) txtLabel1 (text box) Detail_Format... If chkstatus then me.txtlabel1.visible = false End If I am trying to add this code, but in vba, I do not get the option to add ..visible to the control. When I type this code in by hand, it states "you have entered an expression t... 15 Mar 2010 15:51
Cannot get graph to work properly i have never used the graph wizard in access before, always excel, but really need to do it in access. i tried the chart wizard, but it does not set it up correctly. Basically i need a line graph, that on the x-axis shows the hours of the day (in hour increments-24 hours), the y-axis to show a flow value (mg)... 13 Mar 2010 01:04
Macro to open up all 5 reports I am using a macro to open 5 seperate reports but when I open a report you have to use an assigned ID number to retrieve the right employee information you are looking for. At present you have to enter the employee ID # all 5 times for each report, how can I set this up to open up all 5 reports without having to e... 12 Mar 2010 18:27
Report Input Parameters I'm using Sql 2000 and Access 2007. I have a form that I'm trying to print the current record that's displaying on the form. To keep the user from having to enter the MR Number and Date I've entered the following in the Report Input Parameters: @mrnum init=[forms]![frm_eeg_edit_new]![mrn], @eeg_date date=[... 12 Mar 2010 13:56
Multi-Column Report I have a 3-column report. The SID header (GroupHeader0) has Format properties as follows: Force New Page...None New Row Or Col...Before Section Keep Together......Yes Visible.................Yes Can Grow.............No Can Shrink...........No Repeat Section....Yes Depending on the value of SID header, I w... 11 Mar 2010 20:15
Report Footer Grand TL not appearing on one page report with colum In Access 2007, I have a report with 2 columns of data with sums created in a footer. At the bottom of the one-page report, I would like the Grand Total. I can calculate the Grand Total in the Report Footer, but it jumps to a second page even when I have plenty of room on the first page. I do not have this prob... 11 Mar 2010 19:08
Ole Object visible if... Is it possible to set an ole object visible if another ole object has no data? ... 15 Mar 2010 12:21
One Record Per Page Printing-Access 2007 Report for daily appointments for senior transportation drivers. Report is grouped by Driver. Keep together is selected. Detail band: Keep together-Yes; Force New Page-Before Section; Can Grow-Yes; Can Shrink-Yes Goal: Report generated so each driver has his/her own appointments. Orientation: Landscape, pap... 11 Mar 2010 15:44 |