Reports :: How To Put Borders Like In Excel And To Calculate Gratuity
Oct 17, 2014
1. I want to put borders like in excel to my reports in access.
2. I want to calculate gratuity like this: nil for completing less than 1year service, 7 days for service between 1 to 3 years, 14 days for service between 3 to 5 years, 21 days for completing 5 years and 30 days for service exceeding 5 years. The calculations to be made on basic salary and the no. Of days in a month to be taken as 30 days. Can you send me with an example how to do it in a query.
I have several reports that include subreports in them, each one has a bold border surrounding it. When viewing the reports in Access, the spacing and layout is great.
But when I print the reports--either physically or to PDF--the text within the subreports somehow shifts left and up. Some of the subreports--by virtue of chance--happen to have enough extra space, but others don't and part of the text gets clipped by the border.
I'm not exactly motivated to go through the reports and readjust the layout for each one but if there's a database setting that I can change to correct it that would be nice.
I've attached a screenshot (where the layout is perfect) and a printed PDF (where the text is clipped) of one of the reports. The issue can best be seen in the Public/Private ZooMobile and Indoor/Outdoor ZooMobile subreports.
I generate reports of various lengths and would like them to be outlined by a solid border (both vertically and horizontally). So far I have drawn lines of fixed length but I really need a border that will grow and shrink with the length of my report. Any ideas?
Is there a way to delete the borders from a form? You know the ones from the bottom and right hand side which have the buttons on for you to skip between records?
Also the one on the left which has the arrow in the top corner.
I have an Access 2009 report that displays the sums at the bottom of some columns. Is there a way to calculate and display the percentage one sum is of another?
I have a contract management database where contracts have a start date and an end date. I also have a date parameter set up whereby I can show live contracts between overlapping records.
I want to be able to count the number of days for each contract that is live between the dates of the parameters.
For example my contract might run from 1st to 30th November but I might want to report from 10th October to 10th November so the number of days I need the query to return is 10 days as my contract is not live before the 1st November. Or my query might run from 1st October to 31st December, then I would need it to show 30 days as it covers the whole of this contract.
This works great and my report gives me my columns for each expression in minutes they way it should. Now here is the question...is there a way to insert a text box for each column/expression so I can calculate the Average for each column/expression?
i.e. I want the report to show the average minutes of Expr1 and Expr2, etc at the bottom of each column.
i have an excel data for assets and i have imported it into access 2010 but i want to be able to do the ffg;
1. want to be able to generate reports like how many computers does a particular branch have. 2. i want to be able to sum the no of each field heading per branch
I created a database to record time logged per workorder for each employee on my job. Each time log has a specific "Trade" attached to it along with a number of hours the employee spent on that workorder. I've created a report to display how much time the selected employee spent on each workorder (within a date range) and now I want to see what percentage of their time was spent on a particular "Trade" (for instance, during September Employee "name" spent "percentage" of their time on Electric, "percentage" on HVAC, "percentage" on Plumbing...[and so on])
I have trades listed in the table and in the time log, the form writes to the trades area of the table (probably very elementary for this discussion) and the report lists the name and grand totals with percentage of total time on each workorder, but does not list any trade information.
How can I add this into my report, preferably at the end (Report Footer?)
hi. i am working first time with query and reports. i have created a database. i have reports and query. i have a button in my form by the name of (View reports) if a user clicks on that button it opens another form with 3 options 1) Problems all report 2) problems resolved 3) Problems not resolved Now what i really want is when a user clicks on Problems all report it should go directly into excel worksheet based on my query which i have assigned and the width, column should be perfect in excel so then a user can print. secondly same thing goes for problems resolved based on my query which wil show all the problems which have been resolved and should open it in excel with everything alligned and ready to print. i know it is possible and i have been able to just print Problems all based on report not with my query and the formatting was really bad. i need to print reports based on my query directly in Excel worksheet with everything perfectly formatted. any help will be really appreciated. Thanks alot
I'm trying to Export one of my Access Report to Excel, I kept getting this error message.. "There is an Invalid used the Dot, or ! Operator or Invalid of Parentheses..My report is working fine, except when I try to export it to Excel, then this error message pop up..
Hello all...I'm having a problem when exporting some text from Access 2000/XP to Excel using the EXPORT function. The reason why report is used to export is b'cos I need certain layout & to be ported over to Excel.
Text like '00133484-001' or '00130898-001' will be changed to another number after EXPORT, can anyone help me in this ? How can I set these numbers so that they remain the same ?
When exporting a report to Excel my Yes/No fields do not export. The Label nor the field itself exports. I am using the Table to create the report, not a query and sorting data within the report.
It only happens once in a while a few times in a row and then, without changing anything, it's all fine again. It does happen on other pcs as well. (It happens on Office10 and Office13)
I'm not exporting tons of data to excel just two normal-sized querys.
This is some of the VBA code:
Code: Set qdf = CurrentDb.CreateQueryDef(tmpAbfrageLehrgaenge, SQL_Lehrgaenge) Set qdf2 = CurrentDb.CreateQueryDef(tmpAbfrageKunde, SQL_Kunde) DoCmd.TransferSpreadsheet acExport, , tmpAbfrageLehrgaenge, ExcelDateiName, True
I have a report generated per insurance company selected. There are around 10 insurance companies.
Is there a way to run the report and export it directly to Excel (I don't need the report in Access) for all companies where each company will be in one spreadsheet? So, 10 companies, there will be 10 sheets in the Excel file.
My form: "Dailyissue" My attachement field: "Attachement_1"
I attached an image in Attachement_1, I want to set that image in a cell of excel using VBA. How can I do it? (I don't want to read the image from the PC, I want to use the attached image).
I have a table with fields of Title, Description, and URL. I have a report with a text box, IsHyperlink set to yes and Control Source set to =[Title] & "#" & [URL] & "#" . When I open the report in report view, it works great - the Title is displayed as a hyperlink and if I click it, I go to the URL. However, if I export the report to rtf or excel, I only get the Title - it is not a hyperlink. How to get the display text (Title) and hyperlink address (URL) from the access report to Word rtf and excel.
I have an excel file that I need to prepare to create a report.It would be great if I could do this with Access 2003. This would mean that I need to import the excel file and create a table to handle this.Is there by any chance that I don't need to create a table and I can process the excel file? Or maybe automate the import of the excel file into table and only use a few of the columns so later I can create the report in access.Also what I need to do is add some columns with text in it (a standard text) that needs to add a day taken form the column to the right.
I simply would like to avoid to create a table from the import as this would make me end with a lot of tables (or mabye option to delete the table after finishing producing the report.
I receive attendance data in Excel with two columns, StaffCode and DateTime, from a biometric machine.
Each staff member clocks in in the morning and clocks out in the evening.
Optionally, they also clock out for lunch and back in after lunch.
Each StaffCode may therefore have 2 or 4 entries per day of attendance.
Staff details (name and department) are specified in a related table.
I wish to design two reports in Access as follows:
1. Daily Attendance Report (Filtered by current date or custom parameter) Department (1st Group level) StaffName ClockedIn LunchOut LunchIn ClockedOut
2. Weekly/Monthly Attendance Report (filtered by current week/month or custom parameter) Department (1st Group level) Date (2nd Group level) StaffName ClockedIn LunchOut LunchIn ClockedOut