Search results

Hi I have set up a button that I click on enter two date ranges and then it exports multiple reports to excel. The issue I have is on report lists reasons down the side and date across the top, however the reason are exporting as numbers and not as text. If I export the report manually in...

HI I have a table that lists customers, their branch and how long since they transacted with us. What I want to do on a form is have a combo box that lists the branches and once you select the branch it gives you a list of customers that have been inactive for a certain time period. I have set...

Hi Recently I added a new field to an access table (open date). I than copied the table to excel to get rid of some columns and printed to give to staff to write down the dates for me. (didn't save the spreadsheet) I have now gone back into the access sheet and the rows no longer run in order...

Hi I have recently set up a button that exports mutliple queries to one Excel file, using TransferSpreadsheet code. This works great and saves a lot of time, the only thing is on many of the queries I have a date range set, so you have to enter a date range to get the results. Is there away that...

HI Recently I set up a button to export a report automatically to Excel using the following code: DoCmd.outputTo acOutput Report, "Report1", acFormat.xls, "J:\Insurance Dept\Report1.xls", True This works great, however I was wondering 2 things: 1. How do you set up to transfer multiple reports...

Hi I currently have a number of reports I export to excel each month. Currently I have them in saved exports and at the end of each month I go in and click on each one to export to excel. Is there a way I can either get access to do this automatically for me or even create a button to make...

Hi I currently have a form that staff complete and email. I have set up a query that collects the data from the form and report as well. I have added a button to the form that staff click on and it emails the report from the data just entered on the form. Currently it emails in a TXT format...

Hi I currently have a table records calls received. Part of the table has a field for date and another field for time. I have a query to calculate calls received & the reason during each month, however the problem I have is it does not work, because the time field records the date as well...

Hi I am trying to run a cross tab parameter query for date range, to produce a table below; --------Deceased----Moving----service----etc (Closed reasons) Branch abc------Totals--- def ghi My current sql statement appears as below, the problem I have is it will not seperate the totals for each...

Hi I have 2 queries, one calculates total new members by branch by the month, the other calculates closed members by branch by the month. they look like: ---------------Month-----month----etc Branch Name----Total-----Total-----etc Branch Name Etc is it possible to run a query that will calculate...

Hi I have two tables, One lists client details (name,dob,branch they are allocated to etc) and another table on products they have purchased (this is a Yes/No table) As the clients can choose multiple products I need to add up the "Yes" I have seen many articles on this but are having no luck, I...

I am in the process of setting up a data base on people that join our organisation. I need to produce a report that lists by area and by age group as below; Branch--------0-10-----11-20-----21-30-----etc ABC------------8---------28--------20 DEF------------12--------26--------25...

Hi I am trying to create query to record calls & reason codes between certain times, by the month; Ideally the report would appear as below; Calls received between 5.00 and 6.00pm Reason-------aug------sep-----oct---etc abc-----------1---------4-------3---- def------------4---------6------4----...

I am in the process of developing a new Database in Access 2007, it is for survey results. I want to be able to report on specific reason codes by the month, ideally the report would appear as below; Example: Jul Aug Sep Oct Deceased 6...