Search results

attached sample

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 Thanks for your help, you have steered me in the right direction, i can import the spreadsheet, than use the update query which will be a hell of lost easier than manually entering customer numbers and dates!

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 Thanks for your response, I have tried that but it doesn't work. I have found using Docmd. TransferSpreadsheet acExport works perfectly, but I have a number of reports that use date ranges, so I am also wondering if there is a way of entering the date range once

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...

This works great, thanks for your help

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 Access 2007

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 Thanks, i have tried changing that however it still records the date & time. I have the time set to medium time. On the form & in the table it only displays the time, however when I run the query it won't pick up the time as the date is still being recorded

Hi I am using =Now(), so it automatically updates, do I need to change to =Time()?

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...

I have pretty much tried every combination i can with this query, I don't think it will work. If i have the months as column headings it works but does not give me totals of each reason. Everytime I add a where statement or a parameter it states an error. I think because the column heading...

Hi When I change the pivot to Primary Reasons, it comes up with the following error; Access database does not recognize '[startdate] as a valid field name or expression. The following SQL statement is one that shows YTD figures, I just need to a the parameter query so i can also do month to...

HI I am having trouble downloading the file, I keep getting error, will keep trying. VBAinet - The report i am trying to generate involves rows that list the branch and columns that list reason codes. I currently have the exact same report that gives me YTD figures, I just need one that gives...

Hi I am still not having much luck, i created the following query; SELECT [Closed accounts].[Date Closed], [Closed accounts].[Primary reason for account closure], [Closed accounts].Branch FROM [Closed accounts] WHERE ((([Closed accounts].[Date Closed]) Between [start date] And [end date])); I...

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...