Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. EnergyTed

    Ms Access Query to Ms Word Table Automation

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

    Ms Access Query to Ms Word Table Automation

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

    Ms Access Query to Ms Word Table Automation

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

    Ms Access Query to Ms Word Table Automation

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

    Ms Access Query to Ms Word Table Automation

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

    Ms Access Query to Ms Word Table Automation

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

    Data Presentation

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

    Data Presentation

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

    Data Presentation

    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: ======= =========================== ==========...
  10. EnergyTed

    Data Presentation

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

    Data Presentation

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

    Data Presentation

    Hi No, the number of businesses will vary.
  13. EnergyTed

    Data Presentation

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

    Call a Value Help

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

    Select Query - Too Many Records Returned

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

    Select Query - Too Many Records Returned

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

    Select Query - Too Many Records Returned

    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]...
  18. EnergyTed

    Count Per Day

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

    Count Per Day

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

    Count Per Day

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

Part and Inventory Search

Back
Top