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 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...
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
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
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.