Search results for query: *

Hi Skip Copy and Paste, brilliant you deserve a star for that. Stop wasting my time. Ted

Hi Andy So you ask the same question a few times, then criticize the code I need help with! What is the point of you taking your time to respond if you cannot provide any help/advice? Thanks for nothing. Ted

Hi Andy The word document is based on a predefined structure with logos, text, etc. Excel is not an option. Ted

Hi Andy They need/want to be able to edit the document after the data has been updated. Ted

Hi All Please see latest current code - Private Sub Command5_Click() Dim appWord As Word.Application Dim docx As Word.Document Dim dbs As DAO.Database Dim rs As DAO.Recordset Dim strTemplateName As String Set appWord = GetObject(, "Word.Application") Set docx = appWord.Documents.Add...

Hi All I have been asked to automate the creation of a word document to enable the user to edit once the data from the query has been updated. I have successfully created a button on a form that updates the word document for the current record. However, when I try to enhance the code to...

Just a mistype, the results are now as expected. Thanks for everyones help. Ted

Hi PHV Yes, this is the results - InvoiceID Type TariffYear InvoicePeriod ScheduledRunDate Name TotalCharge 1 RUN_THREE 2008 11: 01/02/2009 - 28/02/2009 27/10/2009 5030898.19 1724 RUN_THREE 2008 12: 01/03/2009 - 31/03/2009 25/11/2009 6643882.41 Much the same as dhookom crosstab except...

Hi Duane The result of your crosstab is ideally what I am trying to achieve only with the additional rows for each business - MaxOfID Invoice Period: Name: Scheduled Run Date: Tariff Year: Total Charge= Type: ======= =========================== ==========...

Hi Duane I am very close but I am missing the rest of the businesses with same MaxOfID that equals 1. In the sample data, I am trying to show businesses A, B and C for MaxOfId, where your crosstab only shows 1 row with MaxOfId that equals 1. I hope I am explaining myself clearly. Kind...

Hi Duane I think i can create the crosstab query, but how do i create the Max(ID) where the ID is <= the current row ID? Kind Regards Ted

Hi No, the number of businesses will vary.

Hi I have a csv file with thousands of rows which holds monthly invoice data. Unfortunately, the data is not held how I would expect it and I am finding it difficult to manipulate, please see sample data - ID,Field1,Field2 1,Type:,THREE 2,Tariff Year:,2008 3,Invoice Period:,11: 01/02/2009 -...

Hi I would really appreciate some help/advice please. I am trying to manipulate 2 scripts into 1. The first script creates the value I would like to utilise in the second. However, currently the second script requires a value to be inserted in the html which I do not know how to amend...

Hi Golom and PHV Fantastic, this works great. Much appreciated. Ted.

Hi Golom and PHV Both of your tips have reduced the dataset to the required 5 rows, however the first row being returned is wrong - The End_date should be 31/07/2011. Company Ownership Start Date Item Ref ED 2 19/02/2005 101087510109 10/05/2012 This should be - 2, 19/02/2005...

Hi Here is my base data - Company Ownership Start Date Item Ref 2 19/02/2005 101087510109 7 01/08/2011 101087510109 9 11/05/2012 101087510109 2 28/06/2012 101087510109 9 30/07/2012 101087510109 Here is my query - SELECT tblBaseData.[Company], tblBaseData.[Ownership Start Date]...

Hi Duane An example of actual data would be - Company Name, Ownership Start Date, Item CompA, 01/01/2011, Item1 CompA, 01/01/2011, Item2 CompA, 01/01/2011, Item3 CompA, 01/01/2011, Item4 CompA, 01/01/2011, Item5 CompA, 01/01/2011, Item6 CompA, 01/01/2011, Item7 CompA, 01/01/2011, Item8 CompA...

Hi Duane I finally have some time to experiment and test the queries above. I am not sure where the Dmin() function should be exchanged too allow for multiple ownerships changes? Is it Nz(Ownership_1.[Ownership Start Date] - 1, Dmin()) AS OwnEndDate Or Nz(Dmin(Ownership_1.[Ownership Start...

Hi Duane I haven't had time to test the queries but on first look they seem to do exactly what I am looking for. I will report back when I have had time to test them, especially the possible change to the Dmin() as I know ownership has changed multiple times and this will need to be tested...